Data Engineer (32211)

Myticas Consulting; Canada; On-site; CAD 70,000 - 110,000; Full time

Job summary

An innovative consulting firm is seeking a skilled Data Engineer to design and implement data pipelines using Azure Synapse Analytics. This role involves integrating data from various systems, ensuring accuracy and compliance, and optimizing data models for analytics. The ideal candidate will have a strong background in ETL/ELT development, SQL proficiency, and programming skills in languages like Python or Scala. Join a forward-thinking team that values collaboration and problem-solving, and contribute to impactful projects that drive business intelligence and reporting solutions.

Qualifications

• Strong knowledge of Azure Synapse Analytics and data pipeline development.
• Experience with SQL and data modeling for analytics.

Responsibilities

• Design and deploy data pipelines using Azure Synapse Analytics.
• Monitor and troubleshoot data pipelines for performance.

Skills

Azure Synapse Analytics

ETL/ELT Development

Data Modeling

Azure Data Factory

SQL Proficiency

Programming Skills (Python, Scala, PowerShell)

Problem-Solving

Collaboration

Education

Bachelor's degree in Computer Science

3-5 years of hands-on experience in data engineering

Tools

Azure Data Factory

Power BI

Tableau

Job description

Key Responsibilities

• Design, build, and deploy end-to-end data pipelines using Azure Synapse Analytics.
• Integrate data from various third-party systems, ensuring high-quality, clean, and consistent data for downstream use.
• Work with large datasets, performing transformations and applying best practices in data architecture.
• Ensure data accuracy, integrity, and compliance throughout the pipeline development process.
• Assess existing data pipelines for performance, accuracy, and scalability.
• Implement optimizations to enhance efficiency and reduce processing times.

Data Modeling

• Design and implement optimized data models that support analytics and reporting.
• Develop both dimensional and normalized models aligned with business objectives.

Integration with Third-Party Systems

• Use Azure Synapse to extract data from third-party platforms (e.g., SaaS applications, CRM, ERP systems).

Data Layer Creation for Reporting

• Develop and maintain structured data layers that support reporting and business intelligence tools.
• Ensure data is accurate, accessible, and optimized for analysis.
• Work closely with data architects, business analysts, and stakeholders to define business requirements and translate them into technical solutions.
• Collaborate with cross-functional teams to build efficient and reliable data flows.

Monitoring & Troubleshooting

• Continuously monitor data pipelines for performance and reliability.
• Troubleshoot discrepancies and resolve issues in a timely manner.

Key Skills and Qualifications

• Azure Synapse Analytics Expertise – Strong knowledge of both data lake and data warehouse features.
• ETL/ELT Development – Hands-on experience in creating and managing complex data pipelines within Azure Synapse.
• Data Modeling – Ability to design and implement both normalized and dimensional data models.
• Azure Data Factory – Experience using Azure Data Factory or similar tools for ETL workflow orchestration.
• Third-Party System Integration – Experience integrating data from external applications using APIs and connectors.
• SQL Proficiency – Strong SQL skills for data transformation, querying, and optimization.
• Programming Skills – Proficiency in scripting languages such as Python, Scala, or PowerShell.
• Problem-Solving – Strong troubleshooting and performance optimization skills.
• Collaboration – Ability to work with cross-functional teams and align technical solutions with business goals.

Preferred Qualifications

• Experience with additional Azure services (Azure Data Lake Storage, Azure Blob Storage, Azure SQL Database).
• Familiarity with reporting tools such as Power BI or Tableau.
• Understanding of cloud-based data architectures, including event-driven and serverless computing.

Education and Experience

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field (or equivalent experience).
• 3-5 years of hands-on experience in a data engineering role, with a focus on Azure Synapse or similar data platforms.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology and Engineering

• Industries

  Technology, Information and Media and Software Development

Referrals increase your chances of interviewing at Myticas Consulting by 2x

Get notified about new Data Engineer jobs in Canada.

Senior Software Engineer - Data Platform

Full-Stack Software Engineer (New graduates: Canada)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.