Enterprise Data Warehouse Architect

IDR is seeking an Enterprise Data Warehouse Architectto join one of our top clients in Dallas, TX. If you are looking for an opportunity to join an organization with the restaurant industry nd work within an ever-growing team-oriented culture, please apply today!

Position Overview/Responsibilities for the Enterprise Data Warehouse Architect

• The position is responsible for the architecture, oversight, build, enhancements, and maintenance of the Enterprise Data Warehouse and end-to-end BI solution. This position will be responsible for the accuracy, consistency, completeness, and timeliness of the data.

• 7+ Years of experience in data warehousing with a solid understanding of relational databases and ETL concepts.
• Understanding of dimensional modeling, relational modeling, business process relationships, and best practices in enterprise data and data warehouse design.
• Experience with SQL Server & Teradata Technologies
• Wizard in coding skills within SQL.
• Proficient in designing and architecting ETL processes with hands-on experience leading data extraction, data cleansing, data mapping, data transformation, data loading, and data validation using tools like SSIS, Informatica. Etc.
• Experience architecting and designing Data Warehouses, BI dashboards, KPIs, metrics and reports.
• Experience working with cloud and on-premise data sources and targets.
• Knowledge in using tools such as Informatica Data Quality and Informatica Data Catalog.

• Competitive compensation package
• Full Benefits; Medical, Vision, Dental, and more!
• Annual Bonus Potential!
• Generous Dining Discounts!
• Onsite Gym!
• Opportunity to get in with an industry leading organization
• Close-knit and team-oriented culture

• 25+ Years of Proven Industry Experience in 4 major markets
• Employee Stock Ownership Program
• Dedicated Engagement Manager who is committed to you and your success
• Medical, Dental, Vision, and Life Insurance
• ClearlyRated's Best of Staffing® Client and Talent Award winner 10 years in a row