Talent.com
No longer accepting applications
Data Engineer

Data Engineer

LeverageTek Staffing SolutionsGreater Ottawa Metropolitan Area, Canada
29 days ago
Job description

Data Engineer

Location : Ottawa, ON

Work Type : Full-time

LeverageTek is actively seeking a Data Engineer for a 2-year term role with its Ottawa-based customer

Work Location

The successful candidate will be required to work 2x / week on-site at the customer headquarters in Ottawa, ON

Security Requirement

Must be eligible for Enhanced Reliability security clearance

Key Tasks

Under the direction of Senior Manager, Data and Analytics Architecture , the Data Engineer will be responsible for the following :

Implement an end-to-end analytics solution using Microsoft Fabric to ingest data from various sources

Create semantic models

Enable dashboard / visualization creation for the business team

Assist the data management team in implementing data governance frameworks, policies, and controls

Design and implement data pipelines in Microsoft Fabric, including source mapping and documentation

Create and optimize semantic models including defining business entities, relationships, and security requirements

Implement data governance policies including classification, sensitivity, access controls, and quality validation through Microsoft Purview integration

Set up development, testing, and production environments

Create comprehensive technical documentation covering configurations, data models and business rules

Key Qualifications

  • 5+ years experience in application development, data analysis, database design
  • Experience with Microsoft data platforms (Azure Synapse, Azure Data Factory, Power BI, SSIS)
  • Knowledge and experience with Microsoft Fabric

Qualifications

  • University degree or College diploma in Business Administration, Computer Science, Computer Engineering, Information Technology or related
  • Database platform, data modeling, data quality framework
  • End-to-end data pipeline development and optimization
  • Architecture implementation
  • Power BI semantic model development (Advanced DAX, Star schema)
  • Multi-platform data integration
  • Technical documentation
  • Applying policies, procedures, and regulations
  • Client focus, organizational knowledge, communication, innovation,
  • Cross-functional team collaboration, teamwork and leadership
  • Assets

  • MS Fabric, Azure Synapse, Data Factory, Power BI, PowerShell, Azure Data Lake
  • T-SQL, Spark SQL, Python / PySpark, DAX, Power Query (M)
  • Version control (Git) & DevOps CI / CD
  • Lakehouse and Medallion Architecture
  • Star schema & Data vault
  • SQL server, Azure SQL
  • Oracle database
  • Dataverse
  • Data quality frameworks and Metadata management
  • ETL / ELT pipeline design and implementation
  • Basic security implementation (RLS)
  • Microsoft Fabric Analytics Engineer certification
  • Business intelligence visualization
  • Benefits

    Health Benefits : Drug coverage, healthcare spending account, virtual care (telemedicine), Employee and Family Assistance Program, mental health support, travel insurance, dental, vision, life insurance, disability insurance and accidental death and dismemberment coverage.

    Work Life Balance : A wide range of paid / unpaid leave, including paid vacation, family related leave and personal days.

    Retirement Planning : A Group Savings Plan

    Learning and Development : Payment of professional association memberships, online learning opportunities including a LinkedIn Learning subscription and second language training.

    Perks : Discounts through CF One Member Appreciation

    About LeverageTek Staffing Solutions

    Founded in 2003, LeverageTek provides end-to-end, cross-functional staffing solutions throughout North America. We are a trusted partner to leading private and public sector organizations and experts in talent solutions that create optimal business outcomes.

    Don’t let our name fool you. Our roots are in technology, but we are also a proven leader in accounting and finance, sales and marketing, human resources, supply chain, and legal talent acquisition. We offer contract and permanent staffing, executive search, talent mapping, management consultancy, and contractor payroll management.

    LeverageTek is an equal opportunity employer. We offer a welcoming and inclusive environment in service to one another, our customers, the candidates we represent, and the diverse communities we call home. We do all of this with kindness, empathy, and respect for each other. LeverageTek is committed to employment equity and creating a diverse and inclusive workplace. We welcome applications from all qualified individuals regardless of race, religion, gender, national origin, age, disability, and marital status.

    Accessibility accommodations are available upon request

    Create a job alert for this search

    Data Engineer • Greater Ottawa Metropolitan Area, Canada