Return To Search

Data Warehouse Developer

Location: McLean, VA

Job Type: contract

Company: IDR

Category: Development and Architecture

Job Description Apply Now

IDR is seeking a Data Warehouse Developer to join one of our top clients for a remote opportunity. This role involves designing, developing, and maintaining scalable data warehouse solutions that support business analytics, reporting, and data-driven decision-making within a dynamic and data-centric industry.

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

#LI-Remote All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. IDR is subject to certain governmental recordkeeping and reporting requirements for the administration of civil rights laws and regulations. In order to comply with these laws, we invite employees to voluntarily self-identify their race or ethnicity, gender, and veteran status (if applicable). Submission of this information is voluntary and refusal to provide it will not subject you to any adverse treatment. The information obtained will be kept confidential and may only be used in accordance with the provisions of applicable laws, executive orders, and regulations, including those that require the information to be summarized and reported to the federal government for civil rights enforcement. You may access this form here.

Apply Now