Data Warehouse Engineer

US-MI-Auburn Hills
Information Technology


Guardian Industries, a global company headquartered in Auburn Hills, Michigan, employs around 17,000 people and operates facilities throughout North America, Europe, South America, Africa, the Middle East and Asia. Guardian’s diverse group of companies are involved in the manufacture of high-performance float, coated and fabricated glass products; the manufacture of high-quality chrome-plated and painted plastic components for the automotive and commercial truck industries; and the distribution of specialty building products. Guardian’s vision is to create value for customers and society through constant innovation using fewer resources. Guardian is a wholly owned subsidiary of Koch Industries, Inc. Visit


Develops and supports the organization’s data warehouse applications and related systems; consults and collaborates with stakeholders, functional and technical staff, and other data consumers to assess, identify, determine, and document user needs and requirements, design solutions, and model data. Designs, implements, tests, troubleshoots, documents, and supports data models, programs, scripts, and ETL (Extract, Transform, and Load) processes that produce appropriate and useful business intelligence capabilities. Develops and modifies measures and dimensions as business requirements demand. Determines and evaluates alternative approaches to meet user needs, and recommends optimal solutions.

Primary Responsibilities:

  • Work with DBA, Data Architect and other development resources to develop and support ODS (Data Lake) and Data Warehouse solutions including normalized and dimensional data structures, ETL solutions, integration solutions, maintenance, etc. 
  • Participate in business requirements gathering and assist in translating business requirements into technical requirements for Developers.
  • Manage technical execution of development tasks to ensure that solutions add real business value, system architecture is aligned with business goals, and the design is consistent with the enterprise architecture strategy
  • Manage support tasks and ensure root causes are understood and resolved.
  • Guide trouble shooting and conduct code and QA review.
  • Embrace key technology trends and help the development teams leverage those technologies to provide business value.
  • Participate in enterprise data management strategies and drive the execution of these strategies with business product managers and other stakeholders.
  • Work with business stakeholders from a variety of departments and at all levels of the organization.
  • Provide training to key business users on how to use data in a tabular or multidimensional cube.

Minimum Qualifications: (generally I reordered and

  • 5+ years of Data Warehouse design and development experience
  • Expertise in Microsoft technologies including SQL server, SSAS and SSIS
  • Strong knowledge of tabular and multidimensional cubes; normalized and dimensional modeling
  • Experience in enterprise data management solutions
  • Demonstrated sense of logic, creativity, decision making and problem resolution
  • Excellent communication skills

Valued Experience:

  • Understanding of AWS and the strategies of hosting a cloud based solution.
  • Understanding of PowerBI Premium
  • Understanding of Microsoft TFS
  • Understanding of Virtualization Layer like Denodo or IBI iWay
  • Experience in an Agile development environment

The environment you would be working in: 

  1. Tooling
  2. Visual Studio 2017
  3. MS SQL Server 2016
  5. Git
  6. Hardware
  7. High-end hardware (current generation i7, 32GB RAM, 500GB SSD)
  8. Multi-1080p or single 4k monitor configuration
  9. Office Life
  10. Mid-height cubes in bullpen configuration
  11. Standing desks available
  12. On-site cafeteria that is good and budget-friendly
  13. Beautiful building and grounds with quiet areas to escape to, when needed
  14. People
  15. You will be paired with a mix of mid-to-senior developers that support the existing applications
  16. Most developers are full-stack and well-versed in current technology platforms, but not necessarily in our desired platforms
  17. Some developers, and architects, will have academic knowledge of desired platform but limited practical experience

What do we have to offer?

  • A culture that places top priority on integrity and compliance
  • Encouragement to challenge the status quo and share knowledge
  • Responsibilities and rewards based on contributions
  • Competitive compensation and a wide variety of benefits including health/dental/life insurance, prescription coverage, STD and optional LTD, paid vacation and holidays, and a 401 (k) with a $1 for $1 match up to 7%.


For more information about Guardian Industries LLC., visit us at


Guardian Industries LLC. is an Equal Opportunity Employer.




Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed