Data Warehouse Developer (ETL/SQL)
Location: McLean, VA
Job Type: Contract
Company: IDR
Category: Development and Architecture
Job Description Apply Now
The Data Warehouse Developer (ETL/SQL) plays a crucial role in designing, developing, and maintaining scalable data warehouse solutions. This position supports business analytics, reporting, and data-driven decision-making within a dynamic, data-centric industry. As a Data Warehouse Developer (ETL/SQL), you will be responsible for creating robust infrastructure that enables organizations to collect, store, and analyze large volumes of data efficiently. This opportunity is ideal for individuals who are passionate about leveraging technology to drive strategic business outcomes and enjoy collaborating with cross-functional teams to deliver impactful data solutions. Working as a Data Warehouse Developer (ETL/SQL) in McLean, VA, you will experience the advantages of contributing to a technologically advanced community committed to innovation and excellence in data management.
Data Warehouse Developer (ETL/SQL) - SummaryAs a Data Warehouse Developer (ETL/SQL), you will be responsible for architecting, building, and maintaining enterprise-level data warehouse solutions. This includes designing data marts, creating and optimizing ETL/ELT pipelines, and developing complex SQL queries to support high-quality business intelligence and analytics. By collaborating with teams such as data engineering, analytics, and business intelligence, you will ensure the seamless integration of data from diverse sources, enabling actionable insights for organizational growth and efficiency.
Duties & Responsibilities- Design, build, and maintain enterprise data warehouse architectures and data marts that support current and future business requirements.
- Develop, implement, and optimize ETL/ELT processes for integrating data from multiple, disparate source systems into the data warehouse.
- Create and maintain both dimensional and relational data models, including the design of star and snowflake schemas to facilitate efficient data retrieval.
- Write, tune, and optimize complex SQL queries, stored procedures, and database views for data transformation, cleansing, and aggregation purposes.
- Collaborate with data engineers, analysts, business intelligence developers, and stakeholders to gather requirements and deliver high-quality reporting and analytics solutions.
- Ensure data integrity, accuracy, and security across all data warehouse solutions.
- Utilize Informatica tools, including IDMC CDI and CAI, for the development and maintenance of integration workflows.
- Monitor, troubleshoot, and resolve issues within ETL/ELT pipelines and data warehouse environments to maintain high system availability and performance.
- Document data models, processes, and technical specifications to support ongoing maintenance and knowledge sharing.
- Stay current with industry trends, best practices, and emerging technologies related to data warehousing, ETL, and cloud platforms.
- Competitive compensation package designed to attract and retain top talent in the data warehousing field.
- Comprehensive benefits including medical, vision, dental, and life insurance coverage.
- Employee Stock Ownership Program to foster a sense of ownership and long-term investment in your career.
- Access to a dedicated Engagement Manager focused on supporting your professional development and success.
- Recognition as a part of an industry-leading organization with a strong reputation for excellence.
- Opportunities to work within a supportive, award-winning team environment.
- Minimum of 5 years of experience as a Data Warehouse Developer, Data Engineer, or similar data-focused position.
- Strong expertise with Informatica development, particularly IDMC CDI and CAI modules.
- Advanced proficiency in SQL, including query optimization and performance tuning.
- Solid understanding of data modeling concepts and experience creating dimensional models (star and snowflake schemas).
- Hands-on experience building data pipelines using various data integration methods and ETL/ELT tools.
- Knowledge of cloud data platforms such as AWS, and a deep understanding of modern data warehousing principles and performance optimization strategies.
- Detail-oriented problem solver with a strong analytical mindset and passion for working with large datasets.
- Effective communicator who can collaborate with both technical and non-technical stakeholders to translate business needs into actionable data solutions.
- Driven to stay updated with the latest advancements in data warehousing, ETL technologies, and cloud computing.
- Demonstrates a proactive approach to troubleshooting, system optimization, and continuous improvement.
- Thrives in fast-paced, data-centric environments and enjoys tackling complex challenges.
- The Data Warehouse Developer (ETL/SQL) position offers the chance to contribute to a technologically advanced organization with over 25 years of industry experience.
- Join a team recognized for outstanding client and talent satisfaction as evidenced by multiple industry awards.
- Enjoy working in McLean, VA—an area known for its vibrant professional community and access to leading technology resources.
- This opportunity provides valuable career development pathways and the support of experienced leadership invested in your growth.
- Apply now for the Data Warehouse Developer (ETL/SQL) position by clicking the job application button and take the next step in advancing your career in data management and analytics.
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.