Skip to content
mimi

Data Warehouse Developer

IDR Inc.

McLean · On-site Full-time Senior 3w ago

About the role

Position Overview for the Data Warehouse Developer

  • Responsible for designing, building, and maintaining enterprise data warehouse architectures and data marts
  • Develop and optimize ETL/ELT pipelines to integrate data from multiple source systems
  • Create and maintain dimensional and relational data models, including star and snowflake schemas
  • Write, tune, and optimize complex SQL queries, stored procedures, and views
  • Collaborate with data engineers, analysts, BI developers, and stakeholders to gather requirements and support reporting and analytics

Requirements for the Data Warehouse Developer

  • Strong experience with Informatica development, including IDMC CDI and CAI
  • 5+ years of experience as a Data Warehouse Developer or similar data-focused role
  • Advanced proficiency in SQL and data modeling concepts
  • Experience building data pipelines using various integration methods
  • Knowledge of cloud data platforms such as AWS and understanding of data warehousing principles and performance optimization

What's in it for you?

  • Competitive compensation package
  • Full Benefits; Medical, Vision, Dental, and more!
  • Opportunity to get in with an industry leading organization.

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 Staffing4 Client and Talent Award winner 12 years in a row.

Skills

AWSCAIETLIDMC CDIInformaticaSQLdata modelingdata pipelinesdata warehousingstored procedures

Don't send a generic resume

Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.

Get started free