Data Specialist

North American Search Group; Canada; On-site; CAD 80,000 - 100,000; Full time

Job summary

A data solutions firm in Canada seeks a Data Engineer to design and optimize automated ETL/ELT pipelines, implement robust data models, and create high-performance Power BI dashboards. Candidates should have expertise in SQL and Power BI (DAX), along with proficiency in Python or R for data manipulation. Experience with Agile methodologies and Git version control is preferred. The position offers the opportunity to collaborate with data science teams on machine learning initiatives.

Qualifications

• Expert level SQL and Power BI skills are required.
• Proficiency in Python or R is necessary for data manipulation.
• Solid understanding of data warehousing concepts is essential.
• Experience in Agile/Scrum environments with Git version control is preferred.

Responsibilities

• Design, build, and optimize automated ETL/ELT pipelines.
• Implement robust data models to ensure compliance.
• Create and maintain high-performance Power BI dashboards.
• Partner with various teams to provide high-quality datasets.
• Maintain data integrity through rigorous validation.

Skills

Expert SQL

Power BI (DAX)

Python

R

Data Warehousing

Agile/Scrum

Git

Job description

• Data Engineering: Design, build, and optimize automated ETL/ELT pipelines to move data from raw sources into actionable reporting layers.
• Architecture & Modeling: Implement robust data models (and semantic layers to ensure organizational data is "single source of truth" compliant.
• BI Development: Create and maintain high-performance Power BI dashboards using advanced DAX to visualize complex actuarial and operational KPIs.
• Strategic Support: Partner with the Actuarial and Data Science teams to provide high-quality datasets for machine learning, pricing, and reserving initiatives.
• Governance: Maintain data integrity through rigorous validation and monitoring while version-controlling all work via Git.

QUALIFICATIONS

• Expert SQL and Power BI (DAX) skills.
• · Proficiency in Python or R for data manipulation.
• · Solid understanding of data warehousing
• Process: Experience working in Agile/Scrum environments with Git version control.