Kiewit Corporation Enterprise Reporting Data Modeler- Kiewit Technology Group in Omaha, Nebraska

Date: Mar 17, 2018

Location: Omaha, NE, US

Company: Kiewit

Requisition ID: 70021

Kiewit is one of North America's largest and most respected construction and engineering organizations. With its roots dating back to 1884, the employee-owned company operates through a network of offices and projects in the United States, Canada, Mexico and Australia. Kiewit offers construction and engineering services in a variety of markets including transportation, water/wastewater, power, oil, gas and chemical, building and mining. Kiewit had 2016 revenues of $8.6 billion and employs more than 20,000 staff and craft employees.

How We’re Different

• Consistently ranked within the top five of the “Top 400 Contractors” according to Engineering News-Record

• Consistently recognized as one of the best places to work in North America and in 2015, named one of Fortune’s Most Admired Companies

• Top-tier health, dental and vision insurance available from day one of employment

• 401K savings plan that includes company dollar-for-dollar match on contributions up to 6 percent

• Our employees are entitled to accrue at least 20 days paid time off each year

• We spend an average of $8,500 per employee each year on training and career development, and reimburse up to $5,250 per year in outside tuition costs

Basic Function:

This position is responsible for the logical and physical models of the Enterprise Data Warehouse (EDW)


• Perform data profiling and analysis on source system.

• Understand business requirements.

• Define a Reference Logical Data Model approach for the Kiewit EDW.

• Define physical data model.

• Detail integration points for SAP data.

• Define technical Metadata definition.

• Leverage TAS, SAP and Non-SAP data to project physical data models, and integrate into a single integrated physical data model using an industry standard data model as a reference to ensure business extendibility.

• Focus on attribute harmonization while the other Data Modelers focus on core relationships

• Work in conjunction and supporting the other Data Modelers

• Establish a core foundational Logical Data Model environment.

• Define a Reference Logical Data Model approach for the Kiewit EDW.

• Define physical data model.

• Detail integration points for SAP data.

• Define technical Metadata definition.

• Source System mapping created Reference Logical Data Model.


• Five (5)+ years experience as a data modeler for Enterprise Data Warehouses.

• Three (3)+ years experience modeling SAP data for BI with at least two (2) full lifecycles delivering a large and complex solution.

• Three (3)+ years experience with SQL Server, Oracle and Teradata.

• Working knowledge of Power Designer is a plus.

• Strong Business Intelligence data model knowledge

• Proven experience modeling flat and efficient information solutions

• Deep understanding of Master Data and Metadata.

• Proven ability to work in an environment with complex solutions and models

• Proven ability to meet aggressive deadlines

• Ability to architect a solution including detailed written/visual documentation with strong analytical and problem solving skills.

• Proven experience as an advocate for data standards.

• Proven ability to thrive within a matrixed organization

• Ability to translate complex technical terminology, concepts and issues in terms understandable to technical and non-technical management and resources staff.

• Strong interpersonal skills to resolve problems in a professional manner, lead working groups, negotiate and create consensus

• Proven ability to work with the PMO to deliver projects on time and on budget.

Kiewit is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law.

Nearest Major Market: Omaha

Nearest Secondary Market: Council Bluffs

Job Segment: Database, Engineer, ERP, Business Intelligence, Data Warehouse, Technology, Engineering