Senior Developer Data and Analytics

Lafarge Africa Plc; Mississauga, Calgary; On-site; CAD 67,000 - 150,000; Full time

Job summary

A leading company in the construction sector seeks a Senior Developer in the Data and Analytics team. This role involves developing complex data models and ETL processes in Datasphere to support business analytics across North America. Candidates should possess a strong background in data warehousing and analytics with proven experience in BI tools such as SAP Analytics Cloud. Holcim offers flexible benefits and a collaborative work environment for personal and professional growth.

Benefits

Flexible Health & Dental benefits

Generous Pension Plan

Employee Assistance Program

Access to online learning

Inclusive work environment

Qualifications

• 8-10 years of experience in data analytics and development.
• Proficiency in SQL and Python, with understanding of data governance.
• Certifications in SAP Analytics Cloud or related tools are a plus.

Responsibilities

• Develop and maintain data models and ETL configurations in Datasphere.
• Collaborate with IT and other departments to ensure data accuracy.
• Monitor data performance, propose improvements, and ensure best practices.

Skills

SQL

Python

ETL

Data Warehousing

BI Best Practices

Education

Bachelor's degree in Information Technology or related field

Tools

SAP Analytics Cloud

Datasphere

PowerBI

Tableau

SAP HANA Databases

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

Estimated Wage Range $67,200 - $149,600/Annually

Travel Requirement: 11-20%

COMPANY OVERVIEW
Holcim is planning to spin-off its North American Business to unleash its full potential, capitalizing on North America’s oversized growth in construction led by the modernization of infrastructure, a surge in advanced manufacturing and AI operation and the growth of resilient cities.

Holcim plans to list the new company on the NYSE by the end of the first half of 2025 and establish its operations headquarters in the US to be fully dedicated to serving the North American market and pursue a growth strategy across the region.

The newly listed company will become North America’s leading building solutions company, with industry-leading market position to meet its customers' greatest ambitions with the most advanced building solutions from foundation to rooftop.

Description:

ABOUT THE ROLE:

We are looking for a Senior Developer - Data and Analytics to join our team and support our newly implemented Datasphere (formerly Data Warehouse Cloud) platform. This role will be tasked with developing and maintaining data models, ETL configurations, and other data assets in Datasphere. Thisrole will interact with teams from various departments throughout North America.Datasphere is our main data warehousing platform. SAP Analytics Cloud is our visualization front-end that is integrated with Datasphere.

WHAT YOU'LL ACCOMPLISH

• Demonstrate a commitment to communicating, improving and adhering to health, safety and environmental policies in all work environments and areas. Promote a culture of safety and exhibit these behaviors.
• Design, implement, and maintain complex: data models, data schema, and structures in Datasphere to meet business requirements
• Create complex views and ETL/ELT transformations using: the Datasphere graphical interface, SQL, Python, and scripting capabilities
• Provide end-to-end expertise in Datasphere to support the delivery of business requirements in SAP Analytics Cloud (visualization front-end) and other reporting platforms, in North America, that will connect to Datasphere
• Serve as the SME for the Datasphere platform to proactively identify potential issues, solutions, and improvements to keep business processes running as smoothly and seamlessly as possible
• Gain an in-depth understanding of data sources feeding into Datasphere (SAP ERPs and other systems) to decide on the appropriate joins and relationships and create data models, based on these data sources to meet business requirements (primarily in the SAP Analytics Cloud visualization tool).
• Proactively suggest improvements to existing data models and transformations already developed in Datasphere
• Ensure that all data assets developed in Datasphere are developed with performance, scalability, and accuracy in mind (handling millions/billions of records across various source tables).
• Collaborate with IT to ensure proper lifecycle management of newly developed and existing assets in Datasphere
• Monitor data performance and remediate issues with query and data processing performance as necessary to achieve quick and efficient response times in data models
• Stay up to date on changes and updates in the SAP Datasphere software via: following the SAP Product Roadmap and attending trainings, seminars, and other offerings by SAP as necessary.
• Maintain an understanding on Key Performance Indicators (KPIs) and other key company metrics to be sure that data models and data assets developed in Datasphere align with business requirements
• Other duties as assigned

WHAT WE'RE LOOKING FOR

Education: Bachelor's degree or 8-10 years of equivalent experience

Field of Study Preferred: Information Technology, Analytics, Data, Finance/Accounting, or related field of study
Required Work Experience: 8-10 years of experience
Required Training/Certifications: Certifications in SAP Analytics Cloud, Datasphere, SQL, or Python are a plus

Required Computer and Software Skills:Experience in any number of the following tools: SAP Analytics Cloud (SAC), Datasphere SAP Business Planning and Consolidation (BPC), SAP Business Objects, PowerBI, Tableau, Qlik, SQL, Python, Scripting, APIs, JSON, OData connections, SAP HANA Databases etc.Datasphere and SAP Analytics Cloud are the tools that our team actively uses. Since the popularity of certain BI and Data Warehousing solutions changes over time, and all BI and Data Warehousing tools are conceptually similar, training will be offered as necessary should the applicant have general experience in BI and Data but not SAP Analytics Cloud and Datasphere specifically.

Travel Requirements: 25%

Additional Requirements:

• Strong knowledge of BI, Data Warehousing, and related best practices, including knowledge of: SQL, Python, ETL/ELT, scripting, and other coding languages commonly used by BI/Data professionals.
• Experience in working with Datasphere or BW HANA, third-party data sources, or other data warehousing platforms.
• Understanding of data governance, data privacy, legal, and other principles surrounding data.
• Successful candidates must adhere to all safety protocols and proper use of Holcim approved Personal Protection Equipment ("PPE"), including but not limited to respirators. Employees that are required to wear respirators must be clean shaven where the respirator seal meets the face in order to pass the qualitative and quantitative fit test.

WHAT WE OFFER

• Flexible Health & Dental benefits coverage for you and your dependents
• A generous Pension Plan designed to support you through various stages of your career and life
• Access to voluntary programs like RRSP and TFSA for future financial planning
• Healthy Living support through an Employee and Family Assistance Program (EFAP), offering confidential assistance for work, health, or life challenges
• Easy access to mental health and well-being support
• Service recognition awards to celebrate your contributions
• Perks & discounts on a variety of products and services
• Access to online learning platforms, financial educational assistance, and a culture that fosters career growth and opportunities
• Financial support for new parents beyond statutory benefits
• An inclusive and welcoming environment where everyone can be themselves
• A collaborative work culture in a supportive and team-oriented work environment
  

YOUR HOLCIM EXPERIENCE
At Holcim, there is endless opportunity for you to play your part. Whether you’re in a technical, managerial, or frontline role, you can shape a career that works for you. With us you’ll have the chance to embrace the passion we share for our planet. You’ll be encouraged to seek out diverse perspectives, share your ideas and build the skills and connections you need to perform at your best. Because it’s only when we work together in a culture where everyone thrives, that we can build the world we all want to live in.

In compliance with the ADA Amendments Act (ADAAA), if you have a disability and would like to request accommodation in order to apply for a position with us, please call [phone] or email [e-mail] . This email address and phone number should only be used for accommodations and not general inquiries or resume submittals.

Driven by our purpose to build sustainable solutions for people and our planet, Holcim US encourages interested candidates who meet many, even if not all of the job requirements to apply for a position. We provide a safe working environment for all and strive for diversity in our teams and inclusivity in our work.

We take pride in our hiring processes and our commitment thatall qualified applicants will receive consideration for employment without regard to age, race, color, ethnicity, religion, creed, national origin, ancestry, gender, gender identity, gender expression, sex, sexual orientation, marital status, pregnancy, parental status, genetic information, citizenship, physical or mental disability, past, current, or prospective service in the uniformed services, or any other characteristic protected by applicable federal, state or local law. Our goal is to drive excellence and to ensure we create an environment where every individual has the opportunity to succeed. Holcim (US) Inc., Holcim - ACM Management, Inc., and their affiliates and subsidiaries are an Equal Opportunity Employer, deciding all employment on the basis of qualification, merit and business need.

While we sincerely appreciate all applications, only candidates selected for an interview will be contacted.