Data Engineer

We’re looking for a Data Engineer! Reach out if you’re interested and feel free to refer friends/colleagues!

Type of Employment: Contract
Title: Data Engineer
Term: 6-Month
Location: Remote, for now,/ Toronto
Job ID number: C1272

Brief description of duties:

• Contribute to designing and implementation of data architecture and technology infrastructure for new data and analytics platform with Azure data stack
• Design and build scalable ETL workflows for all data ingestion into the data platform
• Design and develop reports and analytical dashboards in Power BI
• Evaluate and implement emerging analytic tools to enhance performance and improve team productivity
• Mentor, Collaborate and foster an environment of knowledge share, design for scale and re-usability
• Partner closely with business users to understand requirements and rapidly prototype reports to maximize end-user involvement and solicit feedback
• Define and execute unit, performance, and integration testing

Must-haves:

• Minimum 7 years of experience in data warehousing, writing complex SQL queries, views, and procedures, including performance tuning and query optimization with large data set
• Strong Data Warehouse knowledge and experience, including data ingestion, transformation and ETL patterns using modern data pipelines.
• Intermediate to senior-level experience in operationalizing data platforms with Azure data solutions and using Data Factory, Azure Databricks, Azure Analysis Service, Azure Synapse and Databricks
• Strong understanding of relational and dimensional data modeling concepts
• Experience building web APIs or Azure Functions
• Hands-on experience with CI/CD on Azure DevOps

Must also have expertise in at least one of these areas:

1) Senior level experience in report design and building highly interactive dashboards using Power BI with advanced level writing of DAX query language

2) Proficient in Python or ASP.Net C#