Analytics Engineer
Remote
Full-time
Overview of the Role: The Analytics Engineer bridges data engineering and analytics by designing and implementing scalable data models, transforming raw data into actionable insights, and ensuring data quality, reliability, and accessibility. You will collaborate closely with analysts, data scientists, and stakeholders, leveraging the Microsoft Fabric/Azure stack to deliver solutions that empower data-driven decision-making across the organization.
Who We Are: The National Police Federation (NPF) represents ~20,000 RCMP Members serving across Canada and internationally. We are the largest police union in Canada. The NPF is focused on improving public safety for all Canadians, including our Members by advocating for much-needed investment in the public safety continuum. This includes investments in police resourcing and modern equipment, as well as social programs including health, addiction, and housing supports to enhance safety and livability in the many communities we serve, large and small, across Canada.
Our head office is located in Ottawa but our 70+ staff work remotely across Canada. We stay closely connected through our up-to-date I.T. tools and by living our internal values: Inclusion, Innovation, Appreciation, Collaboration, and Trust.
Why work with the NPF?
- Competitive compensation package.
- Generous Group Benefit package including Health Care Spending Account.
- Group Registered Savings Plan (GRSP).
- Professional development opportunities.
- An inclusive, passionate, and fun team environment.
Key Responsibilities:
Data Modeling & Pipeline Development:
- Design, develop, and optimize scalable data models and pipelines using Azure Synapse, Data Factory, Dataflows Gen2
- Ensure efficient data integration, transformation, validation, and automated workflows.
Data Quality & Governance:
- Implement data validation, monitoring, and robust governance practices using Azure Purview and Azure Policy.
- Maintain comprehensive documentation for data models, ETL processes, and workflows.
Collaboration & Stakeholder Engagement:
- Partner with internal teams to gather requirements, develop data-driven solutions, and facilitate self-service analytics.
- Support storytelling through intuitive reports, dashboards, and data visualizations (Power BI).
Insights & Reporting:
- Develop dashboards and visualizations to deliver clear, actionable insights.
- Prepare and present quarterly analytics reports, highlighting data-driven achievements and strategies.
Continuous Improvement:
- Stay current with industry best practices and emerging technologies in data analytics and engineering.
Technologies We Use:
- Microsoft Fabric ecosystem (Azure Synapse Analytics, Data Factory, Dataflows)
- Power BI for visualization and reporting
- CI/CD workflows, version control (Git), scripting (Python, SQL), and RESTful APIs
- Infrastructure/Configuration-as-code tools (Terraform, Ansible) – a plus
- Azure Observability tools (Monitor, Log Analytics, Application Insights)
Qualifications:
- Bachelor’s degree in Computer Science, Data Science, Engineering, or related field.
- 3+ years experience in analytics engineering, data engineering, or similar roles.
- Strong proficiency with SQL, relational databases (e.g., PostgreSQL, Snowflake), and data modeling/warehousing principles.
- Experience with ETL frameworks, pipeline automation, and cloud-based data solutions (Azure preferred).
- Familiarity with programming languages (Python or R), version control (Git), and CI/CD methodologies.
- Excellent problem-solving, analytical, organizational, and technical communication skills.
- Adaptable, proactive, and collaborative, with ability to manage multiple priorities under pressure.
- Ability to effectively communicate technical concepts to non-technical stakeholders.
- French language skills considered an asset.
Other Requirements:
- Travel required 2-4 times per year
- Ability to pass a pre-employment enhanced criminal record check.
Compensation & Other Important Information:
The starting base salary, depending on qualifications/experience, for this position is between $86,381.98 – $100,778.29 range. The maximum salary for the role is $129,571.94. The ability to advance through the salary range will be based on our internal REACH Program.
Starting annual leave for this position is 3 weeks (accrued as earned) which increases to 4 weeks after five years of employment with the NPF.
While some travel is required for this role, our remote work model includes flexibility in completing work hours and a philosophy in promoting a positive work-life balance.
This posting will remain open to applications until 5pm ET, Monday July 21st, 2025.
The National Police Federation hires based on merit and is committed to employment equity. We encourage all qualified people to apply. While we welcome applications from all interested individuals, only those candidates selected for an interview will be contacted.
