Enterprise Data Warehouse Architect

Job ID: 338672    Posted 2 days ago

Coppell, Texas

Contract to Hire

Development and Architecture

Job Details

IDR is seeking an Enterprise Data Warehouse Architect to 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.

Required Skills for the Enterprise Data Warehouse Architect: 

  • 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.
 What’s in it for you?
  • 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

Why IDR?

  • 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

Similar Jobs


Why Us?

IDR has been in business for over 25 years and offers access to hundreds of companies across the country to work for. For many of the contractors that work for us, there are some unique benefits to being a part of the IDR team. One specific benefit is that we believe our contractors are part of something bigger than yourself. We are an employee-owned company and in an ESOP (Employee Stock Ownership Plan), as the share price of our company grows, so does your equity in our company. Our contractors, as well as our internal employees, can participate in this plan after one year of service. In addition to joining our ESOP program, you will also receive weekly pay, 401k access, and access to three different benefit plans that cover 50% of the individual premiums along with access to unlimited behavioral health sessions with a licensed counselor.

About Us

IDR, Inc. is an award-winning, employee-owned staffing firm with headquarters in Alpharetta, GA and offices in the Nashville, Dallas, and Denver markets. Founded in 1998, IDR has grown to serve businesses and professionals across industries including IT, healthcare, accounting and finance, government services, and professional services. Recognized for our expertise and the high-touch approach of our Engagement Management Program, IDR continues to build rewarding partnerships with companies and consultants. Our best-in-class service has earned IDR ClearlyRated’s Best of Staffing Client and Talent awards for ten consecutive years, in addition to awards from Staffing Industry Analysts and Best and Brightest Companies to Work For. With our commitment to empowering talent and developing leaders, we’re passionate about what we do and how we do it, and we look forward to working with you.