BI Developer

Job Responsibility:

About McElhanney Based in Western Canada for over 110 years, McElhanney offers innovative and practical engineering, surveying, mapping, planning, landscape architecture, and environmental services. As a 100% employee-owned and operated firm, with over 1,400 staff members in 33 locations, we are proud to offer qualified staff with shareholding options in our company. At McElhanney, we work in teams to build strong connections with our staff, clients, and local communities. Our employees enjoy working here because of our varied projects, high levels of autonomy, opportunities for career development, excellent total compensation and benefits package, and collaborating with a team of great professionals. The Opportunity: McElhanney has an exciting opportunity for a BI Developer in our Digital Business 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. The ideal candidate will have demonstrated experience in data transformation, analytics, and business data modeling using cloud-based architectures. 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. If this resonates with you, we encourage you to apply even if you don't meet all the requirements outlined. We're interested in getting to know you and what you bring to the role! While working in the Vancouver office is preferred, the successful candidate can be based in any city centre in British Columbia or Alberta and can work on-site, remote or a combination of both. Why You'll Love Working with Us: The salary range for this role is $75,000 to $105,000 per annum. McElhanney offers fair compensation that is commensurate with the individual's education, experience, skills, and professional qualifications. The posted base salary 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. What You'll Be Doing: As a knowledge expert and experienced BI developer, 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.
• Solid understanding of data analysis, data transformation, dimensional data modelling, data visualization, and business intelligence
• Knowledge of leading industry trends and experience in deploying enterprise-wide best practices. Experience with Microsoft Fabric, Azure, and Power BI technologies is preferred.
• 8+ 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 (e.g. AWS, Azure Data Lake, Google BigQuery, etc.), application development, and system integration
• Proven experience in executing large initiatives with complex data transformations across systems and stakeholders.
• A track-record of building and fostering strong relationships within an organization.

What Can We Offer You?

• Challenging and rewarding opportunities as part of a dynamic, synergistic business intelligence team leveraging leading edge technologies
• Flexible work hours to accommodate your lifestyle
• Great benefits, including extended health & dental coverage, healthcare spending account, & RRSP matching
• Maternity leave top-up and parental leave
• Competitive salary and participation in our generous Performance Bonus Plan
• A workplace culture that is characterized by respect and inclusion for all
• Continuous support for your professional development and growth
• Employee and Family assistance program, which offers 24/7 support for all employees and their families either online or over the phone
• Participation in our numerous programs that support our Four Cornerstones: people & communities, clients & partners, processes & technology, and financial
• Opportunity to join an employee-owned firm that is recognized as one of Canada's Top 100 Employers (2023).

#LI-SA1 Our Commitment to Equity, Diversity, and Inclusion At McElhanney, our unwavering commitment lies in cultivating a culture that aligns with our core values and fosters diversity, equity, and inclusion. We celebrate the collective achievements of a team rich in expertise, experiences, and perspectives, and welcome applications from individuals of diverse ethnicities, religions, backgrounds, genders, sexual orientations, gender identities, aboriginal statuses, various age groups, and those with disabilities. Requests for accommodations can be made at any stage of the selection process. If this resonates with you, we encourage you to apply even if you don't meet all of the requirements outlined. We're interested in getting to know you and explore the unique contributions you can bring to McElhanney! If this is the opportunity for you, apply now or visit to learn more. We thank all applicants for their interest; however, only shortlisted candidates will be contacted. To learn more about our recognition as Canada's Top 100 Employers (2024), visit Top Employer: McElhanney Ltd. (canadastop100.com). Visit us on Glassdoor to learn more about our employee experience. Our Purpose: Amaze our clients. Care for our communities. Empower our people. McElhanney is aware of activities where individuals have received fraudulent job offers. Please be advised that McElhanney will not ask applicants for any form of monetary exchange at any point in the recruitment process. To learn more visit: The disclosure of your information in accordance with this Policy and applicable law, including to third party service providers may result in your personal information being transferred outside of Canada, including to the United States. Such transferred personal information may be subject to the laws of these other countries and the laws of other countries regarding the collection, use, and disclosure of personal information may be different from the laws of Canada.