Sr. Data Warehouse Engineer- Data Modeler - Idaho Falls, Idaho United States - 18583

This closed position was filled. Check out our Jobs Search Page for our current open positions similar to this one.


Job #: 18583
Title: Sr. Data Warehouse Engineer- Data Modeler
Job Location: Idaho Falls, Idaho - United States
Employment Type:
Salary: contact recruiter for details
Other Compensation: Full Benefits
Employer Will Recruit From: Nationwide
Relocation Paid?: Yes


Our client is one of the largest, global manufacturing and distribution organizations in the West and we are searching for a talented Lead Data Warehouse Engineer- Data Modeler to design and model our data, giving form to our existing data warehouse through efficient, flexible and scalable data warehouse operations and data structures. This is a senior level role with the ability to influence IT and business direction as well as mentor junior staff on best in breed technology. With an overall mission of wellness and research into sustainable products, you will be a part of a mindful community, working to bring the enterprise to the cutting edge of technology. You will have the opportunity to influence our technology landscape through collaboration with other engineers, product owners, architects, managers and the executive team. Our ideal candidate will be a technical leader with expertise in Data Warehousing and a passion for applying technology to solve business challenges.

  • Best Places to Raise Your Kids
  • Top 100 Best Adventure Towns 
  • Idaho Falls: #1 on the June 2013 Kiplinger rating for Lowest Cost of Living Areas in the US:



Ideal Candidate will be: 

  • Seasoned experience in Kimball Data Warehousing Methodologies
  • Seasoned experience with Microsoft SQL Server, Change Data Capture (CDC)
  • Experience with SSDT Database Projects
  • Experience with SQL Server Analysis Services (SSAS)
  • Experience with SQL Server Reporting Services (SSRS)
  • Experience with Power BI (preferably on premise)

We are well aware that talent comes in all sorts of different configurations. If you're wondering whether or not you're qualified, contact us directly so we can discuss the relationship between work purpose and prior experience.

Responsibilities for this role: 

  • Support and maintain existing Enterprise Data Warehouse (EDW) Efforts
  •  Engage with business units and subject matter experts to determine requirements for data structures in the EDW
  • Design and oversee data discovery process
  • Design reporting data store portion of relational data model
  • Design reporting facts and dimensions of relational data model
  • Create physical data model
  • Design relational security model
  • Document the data dictionary
  • Oversee relational system testing
  • Provide direction and definition of data modeling strategy and delivery
  • Lead effort of delivering data modeling solutions and platform
  • Monitor, troubleshoot, and support data warehouse processes and systems
  • Document EDW systems, data flows and processes
  • Ensure changes conform to standards, are thoroughly tested, and will not break systems
  • Maintain familiarity and provide direction for the field’s concepts, practices, and procedures
  • Participate in technical design and code reviews
  • Lead or mentor Data Warehouse Engineers as needed



  • Bachelor’s degree in Computer Science, Business Information Systems or related field, or equivalent work experience.
  • Approximately 5 years experience in Data Warehouse, Business Intelligence or related field
  • In the neighborhood of 5 years experience in database solutions using TSQL and/or PL SQL
  • Ability to work and communicate well with technical and non-technical people
  • Strong problem solving skills

University - Bachelor's Degree/3-4 Year Degree