Data Warehouse Developer

Data Warehouse Developer

Location: Hybrid role in McLean, VA is preferred. However, if candidate is not local, 100% remote will be considered. Skill set is far more important than location.

Hourly Rate: $60 - $72

Contract Length: Six months to start, with a strong opportunity for extension.

Must-Have Experience

• Data Warehouse Development
• Advanced SQL proficiency
• Strong development experience with Informatica IDMC CDI and CAI
• Experience with large-scale datasets and performance optimization

Overview

We are seeking a skilled Data Warehouse Developer to design, develop, and maintain scalable data warehouse solutions that support business analytics, reporting, and data-driven decision-making. The ideal candidate has strong experience with ETL/ELT processes, data modeling, SQL optimization, and modern cloud-based data platforms.

Key Responsibilities

• Design, build, and maintain 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 (star/snowflake schemas)
• Write, tune, and optimize complex SQL queries, stored procedures, and views
• Ensure data quality, accuracy, and consistency through validation and monitoring
• Collaborate with data engineers, analysts, BI developers, and business stakeholders to gather requirements
• Support reporting, dashboarding, and analytics needs across the organization
• Implement performance tuning, indexing, and partitioning strategies
• Manage data security, access controls, and compliance requirements
• Document data models, pipelines, and warehouse architecture
• Participate in Agile ceremonies including sprint planning, standups, and retrospectives

Required Qualifications

• 5+ years of experience as a Data Warehouse Developer or in a similar data-focused role
• Advanced proficiency in SQL
• Strong development experience with Informatica IDMC CDI and CAI is required
• Strong understanding of data warehousing concepts, including dimensional modeling
• Experience working with large-scale datasets and performance optimization
• Familiarity with Agile/Scrum development methodologies

Preferred / Nice-to-Have Skills

Experience with cloud data platforms such as:

• AWS
• Experience supporting machine learning or advanced analytics workloads
• Understanding of data governance, metadata management, and lineage

Our Benefits Package Includes:

• Comprehensive medical benefits
• Competitive pay
• 401(k) retirement plan
• ...and much more!

About INSPYR Solutions

Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.