Build Your Career with Lafarge!
Exciting technology, growth opportunity and a dynamic environment.
Lafarge is the global leader in construction materials and a $20B worldwide organization
based out of Paris, France situated in 77 countries and employees 88,000 people
worldwide. Lafarge North America holds the largest presence of Lafarge global and is a
$5.5B organization on its own.
Being one of the most sustainable corporations in the world, we are currently expanding
our large-scale Corporate Infrastructure and I.T. Services Center in Mississauga and
are looking for professionals who enjoy the challenge of a dynamic environment of
which can give the opportunity to drive your career path within the corporation in any
direction imaginable to any level chosen.
Visit www.lafargenorthamerica.com and learn more about who we are and what we do.
Our global site is located at www.lafarge.com. Develop and build your career with
Title: Data Warehouse Architect
Location: Mississauga, Ontario
Department: Information Technology
The Data Warehouse Architect will be responsible for architecting solutions using
Lafarge’s Enterprise Data Warehouse, based on the Lafarge Data Model (LDM). The
candidate will be responsible for defining and creating an optimal data architecture that
effectively presents an integrated view of the enterprise data for analytical purposes.
The Data Warehouse Architect will also be responsible for creating and enforcing the
necessary metadata standards and workflow, resolving issues with data quality,
defining and developing data management standards and providing input into ETL
processes and design reviews. The candidate will also be responsible for second- and
third-level support for incidents and the change management process. Some travel
(10%) may be required, with more during project phases (75% to 100%).
Understands the Lafarge Data Model (LDM) and its strategic implementation in
North America. Communicates North America’s unique needs to the Group
DWCC and participates in the evolution of the model.
Delivers overall technical architecture for LDM implementation and integration
with ERP (JDEdwards Enterprise One) and business intelligence system
components. Understands design impacts on OLAP and ETL tools.
Delivers detailed design of data warehouse, database structures, dimensioning
strategy, and integration interfaces (BI presentation as well as data sources).
Solutions will address integrated metadata management and reporting
Works with ETL Architect to design and continuously evaluate data collection,
data staging, data movement, analytics delivery, data quality and archiving
Develops best practices and policies for all operational functions, including query
management, ETL, data collection, data validation, database tuning, access
control, backup and recovery.
Provides operational support for existing models including impact analysis and
coordination of change management of schema, mappings, data transformations
and other metadata.
Relationship with Other Jobs:
Liaises with Application and Infrastructure Architects to coordinate
interdependencies, maintain and evolve technical architecture, and resolve
Works with DBA’s to communicate needs and manage database performance.
Works with ETL Architect to communicate needs and manage ETL performance
Works with and provides guidance to key project data modeling counterparts to
ensure data quality and consistency, and to satisfy reporting needs.
Communicates to end-users and analysts the data available in various data
marts for self-serve and super-user reporting.
Works with BI Architect to explain and document the data warehouse contents,
and understand performance requirements and new data to be stored for
Bachelor's degree or equivalent experience.
Senior level experience with at least 5 years experience in data warehouse
architecture design, logical and physical modeling of data warehouse and business
Skills and Knowledge:
Real-world experience in supporting multiple users in a data warehouse
Solid quantitative, analytical, process development, facilitation and organizational
Well-developed leadership qualities.
Able to highlight issues/problems and convey complex thoughts, written and oral,
in a clear, concise, and timely manner
Technology Specific Requirements:
In-depth knowledge of star schema/dimensional modeling and data warehousing
Strong experience in implementation of data warehouse, date marts and
operational data stores, with related processes and best practices, e.g.,
Proficient in BI tools like Cognos, BO, Microstrategy, etc. and Oracle 9i or 10
For immediate consideration, please send a formated and updated resume with the
position's exact title in the subject line to firstname.lastname@example.org. Only qualified
applicants will be contacted. No agencies please.