Data Engineer and Analytics Specialist

Job Title: Data Engineer and Analytics Specialist

Job Location: Remote Canada
Job Duration: Long Term

Description

The Data Engineer and Analytics Specialist delivers enterprise data engineering, business intelligence, and analytics solutions across multiple projects and hybrid or cloud environments. This role designs and operates data pipelines, warehouses, lakehouses, dimensional models, dashboards, and analytical solutions using technologies such as Python, PySpark, SQL, Azure, Databricks, Microsoft Fabric, Power BI, and related platforms. The position translates business requirements into reliable data and analytics products, communicates insights to stakeholders, and supports modernization, automation, and informed decision-making.

Responsibilities

• Design, build, maintain, and optimize scalable data pipelines across on-premises, hybrid, and cloud platforms, including Azure, Databricks, Microsoft Fabric, GCP, and AWS.
• Develop and support data warehouse and lakehouse solutions using star schemas, snowflake schemas, fact tables, dimension tables, data marts, and other enterprise data models.
• Plan, execute, validate, and support data migration and modernization initiatives across on-premises, cloud, and cross-database environments.
• Develop end-to-end ETL/ELT workflows using Python, PySpark, SQL, SSIS, Azure Data Factory, Fabric Data Factory, Dataflows, notebooks, and other data integration tools.
• Implement data quality validation, error handling, logging, monitoring, scheduling, performance tuning, security controls, and access management for reliable data operations.
• Create executive dashboards, KPI reports, self-service BI solutions, and interactive Power BI reports using DAX and appropriate visualization techniques.
• Analyze trends, patterns, anomalies, and business performance using Python, R, statistical methods, predictive models, and AI-enabled techniques, and communicate findings to technical and non-technical audiences.

Qualifications

• Minimum 4 years of experience building executive dashboards, KPI reporting, self-service business intelligence solutions, and business performance reports.
• Minimum 4 years of experience working with cloud modernization initiatives or hybrid and cloud data platform implementations.
• Minimum 2 years of experience planning, executing, validating, and supporting data migrations across on-premises, cloud, and cross-database environments.
• Minimum 4 years of experience designing enterprise data warehouses or lakehouses using star schemas, snowflake schemas, and fact-and-dimension modeling.
• Minimum 5 years of experience working as a Data Engineer and/or Data Analyst.
• Minimum 5 years of experience using Python, including PySpark, and SQL to develop, orchestrate, optimize, and troubleshoot enterprise-grade ETL/ELT workflows.
• Minimum 4 years of experience designing and implementing ETL processes and data pipelines that transform and load data from multiple sources into data warehouses or lakehouse environments.

Nice to Have

• Minimum 1 year of experience using AI-assisted development tools to improve productivity, code quality, documentation, testing, and data engineering workflows, with appropriate review and quality controls.
• Minimum 2 years of experience designing, implementing, or maintaining DevOps, CI/CD, and Infrastructure as Code practices for automated deployment and management of cloud-based data platforms.

Experience with modern data technologies such as Microsoft Fabric, Databricks, Spark, and Delta Lake, as well as supporting enterprise-scale public-sector applications in public-sector or mixed-delivery environments.