Data Engineer
Remote
Full-time
Overview of the Role: The Data Engineer is pivotal in ensuring the effective operationalization of the organization’s data assets. They oversee the creation of our data pipelines, ensuring consistent and superior data flow for our analysts and decision-makers. The Data Engineer plays a key role in maintaining the organization’s data infrastructure, tools, and quality standards, ensuring they meet the evolving needs of the business. In the realm of data-driven insights, they troubleshoot data issues, investigate anomalies, and engage with internal teams to drive solutions. A significant aspect of their responsibility includes actively monitoring data quality and safeguarding data integrity across the organization. Fundamentally, this role is dedicated to delivering accuracy within our data ecosystem, efficiently overseeing both data projects and routine workflows, and championing the principles of data governance.
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:
- Design and implement scalable data storage and pipeline solutions in Azure.
- Establish processes to maintain data accuracy and integrity. Uphold Data Governance frameworks for data security and compliance.
- Build efficient data processing workflows in Azure. Develop data models and write queries to extract actionable insights for business decision-making.
- Select and configure appropriate Azure data storage services (e.g., Azure Data Lake Storage, Azure SQL Database, Azure Cosmos DB) based on data volume, structure, and access patterns.
- Develop reliable, scalable, and automated data pipelines using Azure Data Factory (ADF) or Azure Synapse Pipelines to ingest data from various sources, transform it as needed, and load it into target systems.
- Design solutions in Azure that can handle growing data volumes and processing demands.
- Implement data validation, cleansing, and transformation processes to maintain the accuracy and consistency of data.
- Collaborate with stakeholders to establish data governance policies, standards, and procedures. This includes defining data access controls, metadata management, and data lineage.
- Design and implement efficient data processing workflows in tools like Azure Databricks or Azure Synapse Analytics to improve performance and reduce costs.
- Build logical and physical data models to ensure proper data organization and support data analysis.
- Write SQL queries and leverage tools like Azure Data Explorer to analyze data and provide insights to business teams.
- Work closely with Information Management team, analysts, and business users to understand their data requirements and design tailored solutions.
- Communicate complex technical concepts to non-technical stakeholders effectively.
- Keep abreast of the latest Azure data services, features, and best practices to continuously improve and evolve data solutions.
Qualifications/Key Attributes:
- A minimum of 4 years’ experience in IT, with a focus on data infrastructure and management, including experience with servers, databases, and networking technologies.
- Completion of a University Degree in Computer Science, Engineering or Technology-related field required.
- Proven ability to troubleshoot and resolve technical issues related to data systems, ensuring data integrity and availability for end users and applications.
- Sound understanding of computer systems, security, telco, databases, and storage systems.
- Solid understanding of relational databases (SQL Server, PostgreSQL, MySQL, etc.) and SQL querying skills.
- Experience in at least one programming language (Python is highly preferred, but Java, Scala, etc., are valuable).
- Basic understanding of cloud concepts and experience with at least one major cloud platform (ideally Azure).
- Experience with data warehousing concepts and extract, transform, load (ETL) processes.
- Familiarity with big data tools like Hadoop, Spark, or similar.
- Experience with data visualization tools (e.g., Tableau, Power BI) helps in communicating insights.
- Superior oral and written capabilities.
- Experience working within a shifting landscape with the ability to work under pressure to meet critical deadlines.
- Strong project management abilities.
- Ability to take complex information and distil and communicate to a variety of audiences clearly when speaking and in layman’s terms.
- Ability to manage and prioritize tasks and projects.
- Highly proficient with Microsoft Office productivity tools.
- Exceptional interpersonal skills, including the ability to build professional relationships across all aspects and levels of the NPF.
- Strong analytic and problem-solving mindset.
- Ability to adapt to changing situations, new ideas and concepts.
- Curious with an eagerness to learn.
- Sound judgement and tact.
- High level of attention to detail.
- Excellent problem-solving capabilities.
- Ability to multi-task; take the initiative; be proactive; flexible.
- Ability to communicate with a diverse workforce and facilitate successful performance in a team-based environment.
- Ability to work under pressure and meet continuous deadlines.
- Innovative thinker.
- Available for overnight travel approximately 4/year.
- Ability to obtain Secret level security clearance
Competencies:
- Exceptional interpersonal skills, including the ability to build professional relationships across all aspects and levels of the NPF.
- Ability to adapt to changing situations, new ideas and concepts.
- Sound judgement and tact.
- High level of attention to detail.
- Excellent problem-solving capabilities.
- Ability to multi-task; take the initiative; be proactive; flexible.
- Ability to communicate and collaborate effectively with team members and across departments to achieve common goals. This includes active listening, respecting diverse viewpoints, and contributing ideas and expertise to group projects.
- Ability to work under pressure and meet continuous deadlines.
- Innovative thinker.
Compensation:
The starting base salary, depending on qualifications/experience, for this position is between $69,888.00 – $81,536.00.
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.