Senior Data Architect modernizing Alberta justice data marts into an integrated enterprise data warehouse. Designing ETL, Power BI testing, data models, governance, and reporting architecture.
About the role
- Full-Stack Data Engineer responsible for transforming data into actionable insights and structured reports. Join Manulife’s team to enhance analytics and reporting with hybrid work arrangement.
Responsibilities
- Build automated data extracts and feeds from curated Gold Layer models
- Develop formatted operational and regulatory reports (Power BI, Tableau, SAC, SSRS, Crystal Reports)
- Design and maintain ETL/ELT pipelines using ADF, Informatica or similar tools
- Create reliable outbound data delivery via SFTP, APIs, or managed file transfer platforms
- Implement data validation, reconciliation checks, and robust quality controls
- Maintain clear lineage from Gold Layer to downstream outputs with audit readiness
- Optimize extraction logic for performance and scalability
- Build and manage scheduling, monitoring, and alerting for production pipelines
- Work closely with Finance, Actuarial, Operations, and business partners to gather and translate reporting needs
- Document feeds, mappings, data definitions, and technical specifications
Requirements
- Bachelor’s degree in computer science, Software Engineering, or a related field (or equivalent experience)
- 4+ years’ experience in data engineering, BI engineering, or analytics engineering
- Advanced SQL skills and strong understanding of 3NF and analytic modeling
- Hands‑on experience with ETL/ELT platforms (Informatica, ADF or similar)
- Practical experience building formatted reports (Power BI/Tableau/SAC/SSRS/Crystal Reports)
- Ability to generate and automate file‑based outputs (CSV, TSV, XML, JSON etc.)
- Experience delivering feeds via SFTP, MFT, or API frameworks
- Strong data quality, validation, and reconciliation skills
- Good understanding of data warehousing and data model design
- Familiarity with scheduling/orchestration tools (ADF, Airflow, Control‑M, Autosys)
Benefits
- Health insurance
- Dental benefits
- Vision benefits
- Short- and long-term disability insurance
- Life and AD&D insurance coverage
- Adoption/surrogacy and wellness benefits
- Employee/family assistance plans
- Retirement savings plans
- Generous paid time off program including holidays, vacation, personal, and sick days
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Senior Data Architect integrating Alberta court data marts into an enterprise data warehouse. Designing ETL, data models, governance practices, and Power BI validation reports.
LP
Senior Data Engineer
LinkedIn Recruiter Post
Senior Data Engineer contract role: design/build ETL/ELT pipelines using Azure stack, primarily remote in Canada, occasional onsite in Edmonton.
Data & Analytics Engineer building scalable data platforms for Ledgebrook, an insurance company. Designing pipelines, governance, and cloud data systems while partnering with technical and insurance teams.
Data Engineer building scalable pipelines for SumerSports’ football intelligence platform. Supporting deep learning, video, LLM, analytics, and AI - driven products across sports.
Data Platform Engineer building ingestion pipelines, storage, governance, and observability systems for Movable Ink’s AI - driven marketing personalization platform. Supporting scalable, secure, multi - tenant data services.
Senior Data Engineer building AWS ETL/ELT pipelines and dbt models for Tango’s cloud real - estate and facilities SaaS. Managing databases, data quality, warehousing, and observability.
Senior Data Engineer building AWS and dbt data pipelines for Tango’s cloud real - estate and facilities SaaS platform. Managing databases, warehouses, data quality, and analytics - ready datasets.
Data Engineer building streaming pipelines and analytical databases for Movable Ink’s data - activated marketing personalization platform. Developing Elixir/Python services and reliable event - data products at billions - event scale.
LP
Senior Data Engineer
LinkedIn Recruiter Post
Senior Data Engineer needed for a 1 - year contract with an asset management client in Toronto. Requires 7+ years of experience, Snowflake, Python, SQL, and cloud platform expertise.