Data Engineer

The Opportunity: McElhanney has an exciting opportunity for a Data Engineer in our Data & Analytics team. In this role, you will have the opportunity to design, build, and optimize our information/data infrastructure. This will directly contribute to McElhanney’s digital transformation journey to be one of Canada’s leading insight-enabled engineering consultants.   At McElhanney, we are committed to fostering a culture of diversity, equity, and inclusion which celebrates the successes that comes from a team that is diverse in expertise, experiences, and perspectives. Well-known and respected throughout the industry for the integrity and quality of our work, we are also known for treating our employees well. We care about your physical and mental wellbeing and therefore offer an excellent total compensation plan, including competitive industry salaries, a performance bonus plan, and a comprehensive benefits package. We are proud of our long history, international reputation, and tradition of employee ownership. We believe in working together. We believe that you can make a difference!   We are open to both full-time and contract opportunities, with the potential for long-term employment depending on candidate suitability and preference for the role. While working in the Vancouver office is preferred, the successful candidate can be based in any city centre in BC or Alberta and can work on-site or remote.Deadline to Apply: June 10, 2026 What You’ll Be Doing:As a data expert and experienced data engineer, your primary responsibility is participating in all facets of data transformation, business data modelling, documentation, delivery, and maintenance of information and reporting solutions.   This position reports to the Division Manager, Information and Data Architecture.   Your responsibilities will include: Designing, building and documenting data transformation and enhancement pipelines and data models Providing guidance on industry best practices to improve data process flows, increase data sharing efficiencies, and improve enterprise-wide data management Working with stakeholders across McElhanney to improve the end-to-end quality of data which includes data collection/intake, data cleansing, and data quality assurance Supporting the continued evolution of digital business transformation, data science and analytics in achieving our ambitious data strategies and goals   What You’ll Bring: Degree in Information Technology, Computer Science, Computer Engineering, or a related field. At least 5 years of hands-on work in data analysis, data transformation, dimensional data modelling, data visualization, and business intelligence 5+ years of experience in a business intelligence technology role 5+ years of experience with data exploration and transformation using SQL platforms. 3+ years of experience working with PySpark and/or Python/pandas platforms for data manipulation and transformation. Comprehensive understanding of cloud-based architecture (Microsoft Fabric is preferred), application development, and system integrations Proven experience in executing large initiatives with complex data transformations leveraging diverse pool of enterprise systems and data stewards. Ability to deliver consistent high-quality deliverables in a complex fast-paced environment with minimal oversight. A track-record of building and fostering strong relationships within an organization Knowledge of leading industry trends and experience in deploying enterprise-wide best practices. Experience with Microsoft Fabric, Azure, and Power BI technologies is preferred. What Can We Offer You? The salary range for this position is $90,000 - $110,000 per annum. McElhanney offers fair compensation that is commensurate with the individual’s education, experience, skills, and professional qualifications. The posted base salary/wage range is representative of the required level of qualifications and experience for the position as noted in the job posting. The salary offered will be based on the experience and qualifications of the successful candidate.   Challenging and rewarding opportunities as part of a dynamic, synergistic business intelligence team leveraging leading edge technologies. Flexible work hours to accommodate your lifestyle A workplace culture that is characterized by safety, respect, and inclusion for all Maternity leave top-up and parental leave Competitive salary and participation in our generous Performance Bonus Plan Participation in our numerous programs that support our Four Cornerstones: people & communities, clients & partners, processes & technology, and financial. Great benefits, including extended health and dental coverage, healthcare spending account, and RRSP matching Employee and Family assistance program, which offers 24/7 support for all employees and their families either online or over the phone Continuous support for your professional development and growth including access to courses on our Learning Hub, paid professional development, mentorship program, and encouragement to join internal committees such as, Young Professional, Women at McElhanney, Equity Diversity and Inclusion, and technical service groups.   Application Instructions: Please include your most up-to-date resume when applying Candidates are welcome to include optional samples of work, such as GitHub profiles, project summaries, or examples of relevant data engineering solutions. This is not mandatory but may help support the application.