Data & Analytics Engineer, MS Fabric
About The Position
Armstrong Collective is seeking a versatile Data Engineer with deep expertise across the Microsoft Fabric platform. This individual contributor role involves informal technical leadership, where you will guide approaches, influence best practices, and support peers while remaining hands-on in design, build, and delivery. You will be responsible for ingesting high-volume data, designing canonical data models, modernizing legacy T-SQL workloads, modeling data in the Lakehouse, and delivering trusted analytics solutions. A key aspect of this role is proactively collaborating with stakeholders, aligning work to business outcomes, and contributing to advancing a governed, self-serve analytics ecosystem.
Requirements
- 5+ years of data engineering experience with delivery of batch and streaming workloads.
- Strong Power BI development experience including semantic models, reports, dashboards, and advanced DAX.
- Demonstrated expertise in enterprise data modelling including ER, normalized, and dimensional modelling.
- Experience designing canonical data models across multiple systems and use cases.
- Hands-on experience with Microsoft Fabric, Lakehouse, Pipelines, and Notebooks.
- Strong Spark / PySpark experience with production environments such as Databricks or Fabric.
- Experience converting complex T-SQL workloads into Spark with structured validation approaches.
- Strong T-SQL knowledge and understanding of relational systems.
- Experience with CI/CD practices, including source control and deployment pipelines.
- Experience supporting self-serve analytics and enabling business users.
- Proficiency with data modelling tools.
Nice To Haves
- Relevant Microsoft and data certifications (e.g., DP-700, DP-600, PL-300, DP-203, Databricks certifications).
- Experience with Fabric Copilot or AI-assisted development tools.
- Exposure to data mesh, medallion architecture, and modern data design patterns.
- Experience in regulated or data-sensitive industries.
Responsibilities
- Design canonical data models, taking ownership of data quality, integrity, and alignment to business needs.
- Apply entity-relationship, normalized, and dimensional modelling techniques with strong attention to detail and continuous improvement.
- Design and implement end-to-end data pipelines, proactively identifying risks and ensuring reliability and scalability.
- Build and optimize Spark / PySpark pipelines, ensuring performance, maintainability, and quality outcomes.
- Lead the modernization of legacy T-SQL workloads into Spark, influencing design decisions and ensuring successful delivery.
- Design and maintain Power BI semantic models, enabling business-friendly and high-performing datasets.
- Build intuitive Power BI reports and dashboards that drive decision-making and user adoption.
- Champion self-serve analytics by enabling users, promoting best practices, and contributing to governance standards.
- Leverage Fabric and Copilot capabilities to improve productivity and generate insights.
- Implement monitoring, observability, and data quality controls, taking proactive action on issues.
- Collaborate with stakeholders, guiding discussions and clarifying requirements to deliver effective data solutions.
- Contribute to standards, CI/CD practices, and documentation, influencing continuous improvement across the team.
Benefits
- Medical, Dental, Vision, Life Insurance
- Short term disability, long term disability benefits
- Travel emergency assistance
- Vacation time and sick time
- Up to 5% RRSP and/or TSFA match
- Two complimentary annual train tickets after first year of employment
- Discretionary bonus program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
