Data Engineer

Data Engineer page is loaded## Data Engineerlocations: Ottawatime type: Full timeposted on: Posted Yesterdayjob requisition id: JR-7767**Job Posting Title**Data Engineer**Job Category**Systems Engineering**Language Requirements**English / Anglais**Flexible Work Agreement Type**Hybrid / Hybride**Posting End Date** **Job Grade**PIPSC-3**Pay Range**$111,451 - $140,007**Job Summary** As a Data Engineer, you’ll work alongside a multidisciplinary team of Business Analysts, Data Engineers, and Report Developers. Together, you’ll architect, develop, and maintain NAV CANADA’s data pipelines and analytics platform infrastructure - essential components that enable business intelligence, operational insights, and strategic planning. You will collaborate closely with internal and external stakeholders to design and implement modern data solutions, optimize performance, and ensure data integrity and security. Your expertise will help shape technology roadmaps and deliver high-quality solutions that meet evolving business needs. If you thrive in a fast-paced environment, love solving complex data challenges, and want to see your impact in real-world aviation operations, this is your opportunity to make a difference.**Job Description****What NAV CANADA offers you:*** Challenging, team-oriented work environment* Competitive compensation and benefits* Defined benefit pension plan* Opportunities for growth and development* Flexible work arrangements* Diverse and inclusive workforce**Job Description****Key Accountabilities:*** Design, build, and optimize scalable data pipelines and architectures to support analytics, reporting, and application systems.* Provide technical leadership in data engineering best practices, including data modeling, ETL/ELT processes, and pipeline automation.* Develop and maintain data integration and transformation workflows using a combination of legacy and modern platforms (e.g., Azure, Azure Databricks, Power BI).* Ensure data quality, integrity, and security across all stages of the data lifecycle.* Conduct performance tuning and implement monitoring strategies for data systems to ensure reliability and efficiency.* Collaborate with cross-functional teams to translate business requirements into robust technical solutions.* Mentor junior engineers and contribute to code reviews, fostering a culture of quality and continuous improvement.* Lead moderately complex or multiple cross-functional data projects, ensuring alignment across infrastructure, analytics, and business domains.* Establish high-level and detailed schedules and tasks for solution delivery and execution with team members, ensuring clear understanding of dependencies and work products required to deliver successful outcomes.**Job Requirements****Education:*** Graduated from a recognized university or college with a degree/certification in Engineering, Computer Sciences/Information Technology, Business Administration, MBA and/or Aviation and at least 3+ years related experience.**Experience**:* 3+ years architecting and delivering enterprise data pipelines for large-scale, high-volume applications, ensuring reliability, scalability, and performance across complex environments.* 3+ years designing and implementing cloud-native data solutions leveraging Microsoft Azure services (including Data Lake Storage, Databricks, App Services), with hands-on experience optimizing workflows for cost efficiency, security, and advanced analytics. Hands-on experience with Databricks and Apache Spark including Spark SQL and using Databricks notebooks.* 3+ years leading solution planning activities – producing accurate estimates, timelines, and delivery commitments while managing dependencies and aligning cross-functional teams.* 3+ years developing advanced SQL for complex, large-scale datasets; highly proficient in Python, R, and Scala, with hands-on experience in spatial data processing and geospatial analytics.* 3+ years applying agile product delivery and CI/CD practices using Azure DevOps, with experience as a Scrum Facilitator* 3+ years experience mentoring junior engineers and analysts, conducting code reviews, and promoting best practices in data engineering, automation, and performance optimization.**Knowledge:*** Deep understanding of modern data engineering principles and best practices, including designing scalable ETL/ELT workflows, implementing data quality frameworks, and optimizing big data processing for performance and cost efficiency in cloud environments.* Strong knowledge of data delivery methodologies and tools, applying Agile and DevOps principles alongside software development, testing, lifecycle management, and project management practices.* Demonstrated expertise in advanced data analysis, leveraging SQL, Databricks, and programming languages such as Python and R to extract, transform, and interpret complex datasets, with particular focus on the PySpark library and other Spark APIs.* Knowledge of enterprise data architecture, including developing data models to meet requirements for design, storage, integrity and security, as well as dimensional data modelling concepts, star-schema, snowflake, facts and dimension.**Abilities:*** Excellent problem-solving and troubleshooting skills, with the ability to analyze business requirements, generate actional insights, and recommend effective solutions within time and resource.* Strong communication skills, both verbal and written, with the ability to present complex concepts clearly to technical and non-technical audiences and provide concise updates to management and stakeholders.* Ability to lead, manage, and prioritize work across multiple projects, acting as a technical advisor to guide and mentor team members.* Demonstrated ability to foster collaboration and build strong working relationships within and across teams and departments.**Personal Suitability:*** Passionate about data, analytics, and technology solutions, with a commitment to continuous learning and staying ahead of industry trends.* Diplomatic and customer-focused, with strong relationship-building and teamwork skills.* Demonstrates a high degree of initiative, accountability, sound judgment, and reliability, consistently delivering high-quality solutions on time.**Working conditions:*** This position is based at Ottawa Head Office – 151 Slater Street, Ottawa.* This position is a hybrid position with a minimum of 3 days per week on site.NAV CANADA is committed to building a skilled, diverse workforce reflective of Canadian society. If you do not believe that you match every job requirement listed on this job posting, we still encourage you to apply. NAV CANADA encourages a culture of learning and growth, and recognizes that although some technical skills are mandatory, many others can be taught.Our Company strives to create an inclusive and barrier-free selection process and work environment. If you require accommodations during this competition process, please ensure that you inform the interview coordinator or hiring manager of any accommodation measures you may require. NAV CANADA will provide accommodations throughout the recruitment and selection process to applicants with disabilities as required.The successful candidate must meet the security requirement of the position and be legally able to work in Canada.We thank all applicants for their interest; only those selected for next steps will be contacted.-NAV CANADA employees help guide the world's aircraft safely and expeditiously through Canadian-controlled airspace. With approximately 4600 employees located from coast, to coast, to coast, we offer some of the most exciting careers in the field of aviation. Our employees deliver air traffic services, design and build our technology, maintain our systems, and provide a wide variety of technical and administrative#J-18808-Ljbffr