Développeur BI (remote)

About McElhanney Based in Western Canada for over 110 years, McElhanney offers innovative and practical engineering, surveying, mapping, planning, landscape architecture, and environmental services. 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. 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. 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. 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. 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

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
• 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.
• AWS, Azure Data Lake, Google BigQuery, etc.), 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.

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

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

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. Care for our communities. 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.