Data Warehouse Developer
Saxon Global Inc
Position Summary
This is a hands-on, pure development role focused on building and integrating data solutions in Informatica IDMC. The team is looking for someone who can design, develop, and deliver independently across the full SDLC, with a strong emphasis on real-time integrations over batch processing . Core Responsibilities
Key Differentiators
Candidates will stand out if they have:
This is a hands-on, pure development role focused on building and integrating data solutions in Informatica IDMC. The team is looking for someone who can design, develop, and deliver independently across the full SDLC, with a strong emphasis on real-time integrations over batch processing . Core Responsibilities
- Design, build, and maintain cloud-based data warehouse solutions
- Develop ETL/ELT pipelines using Informatica IDMC (CDI, CAI)
- Build real-time / near real-time integrations across multiple systems
- Integrate data across varied tech stacks and formats (JSON, XML, etc.)
- Support data modeling (dimensional, star/snowflake)
- Optimize SQL queries and performance
- Contribute across the full SDLC: design → development → deployment
- Ensure data quality, validation, and consistency
- Help decommission legacy on-prem systems during cloud migration
- Strong Informatica IDMC experience (critical)
- CDI (Cloud Data Integration)
- CAI (Cloud Application Integration)
- Advanced SQL
- AWS experience
- Real-time integration experience (not just batch)
- Strong ETL design and development background
- Experience working with:
- JSON, XML, and varied file formats
- Ability to work independently with minimal supervision
- Informatica certifications
- Retail or supply chain domain experience
- Shell scripting
- Experience supporting large-scale cloud migrations
- Exposure to data governance / metadata / lineage
- Supporting PSDL project + existing systems
- Recently migrated to cloud (Informatica Cloud / IDMC)
- Currently working through on-prem decommissioning
- Heavy focus on:
- Real-time integrations
- Cross-platform system integration (horizontal team)
- Existing batch processes still exist, but integration work is priority
- Pure developer mindset (NOT looking for managers or architects)
- Strong in integration-first thinking , not just ETL pipelines
- Comfortable in fast-moving, globally distributed teams
- Flexible and adaptable across changing requirements
- Proven ability to own delivery end-to-end
- Round 1 (30 min) - Technical panel
- Given a requirement → expected to walk through solution design
- Round 2 - Technical deep-dive
- Focus on past projects (PSDL + integrations)
- Deep discussion on design, architecture, and implementation
Key Differentiators
Candidates will stand out if they have:
- Strong real-time integration experience (IDMC CAI)
- Experience handling dynamic file ingestion (JSON/XML automation)
- Informatica certifications
- Supply chain / retail exposure
Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Data Warehouse Developer in McLean, VA vacancy
- ...Data Warehouse Engineer LOCATION Tysons, VA 22182 CLEARANCE TS/SCI Full Poly (Please note this position requires full U.... .... *** SIMILAR CAREER TITLES Data Engineer, ETL Developer, Data Architect, Business Intelligence Engineer, Data Integration...SuggestedTemporary workFor contractorsImmediate startFlexible hours
Cymertek
Vienna, VA3 days ago $94k - $160k
Prime Therapeutics is seeking a Senior Data Engineer to design and deliver high-performing data solutions in Washington, DC. This role entails leading scalable solutions, collaborating with cross-functional teams, and mentoring junior engineers. The ideal candidate will...Suggested$140k - $180k
Steampunk is seeking a Senior Data Warehouse Engineer in McLean, Virginia, to lead the development of enterprise-grade data platforms. The role involves managing data environments, optimizing performance, and collaborating with clients and teams in an Agile setup. Candidates...Suggested- Nationwide-IT-Services is seeking a Data Warehouse Subject Matter Expert (SME) to provide technical leadership in the design and support of SQL Server data warehouse environments. You will have over 15 years of database experience, with at least 12 years of SQL Server...Suggested
- E-Logic, Inc. is looking for a hybrid Database Developer and Administrator in the Washington DC area to enhance the performance and integrity of the analytical data warehouse for OPM and OIG. The ideal candidate will have advanced expertise in AWS Redshift and PostgreSQL...Suggested
$140k - $180k
Steampunk, Inc. is looking for a Senior Data Warehouse Engineer in McLean, Virginia. The role involves developing and optimizing enterprise-grade data platforms. Candidates should have strong communication skills and thrive in cloud-based environments. Key responsibilities...$210.58k - $220.58k
Nestlé S.A. seeks a skilled professional in Arlington, VA for a role focused on developing data pipelines and ensuring best practices for SAP BW Data Warehouse architecture. Candidates should have a Bachelor’s degree and extensive experience in SAP BW, SQL, and data provisioning...Remote work- THE OVERALL PURPOSE OF POSITION: The Data warehouse Architect will spearhead the design and development of a new, high performance enterprise... ..., and normalized and de-normalized data models). Helps to develop, implement, and maintain appropriate data governance on the...Immediate startFlexible hours
$94k - $160k
Rebates Data Warehouse Data Engineer Sr. Rebates Data Warehouse Data Engineer Sr. seeks a senior data engineer to design and deliver scalable, resilient, and high‑performing data solutions. The role drives innovation through proof‑of‑concepts, solution evaluations, and...Work experience placementLocal areaVisa sponsorshipWork visa- ...E-logic is hiring a Data Architect to design robust, modern data structures that reconcile and map diverse insurance carrier data... ...physical, and dimensional data models for the Integrated Data Warehouse (IDW) and data lake architectures. Establish standard data layouts...Work at office
E-Logic, Inc.
Washington DC4 days ago $112.8k - $257k
...Job Number: R0242060 Data Architect The Opportunity: At a certain point, experience-based system design can start to look like clairvoyance. When you've developed so many systems that you can not only orchestrate the best solution for any technology-based challenge, but...Contract workLocal areaPhase2 Technology
Alexandria, VA3 days ago- ...Senior Data Modeler Location : McLean, VA - 5 Days Onsite (Locals Only) Duration: 6-Month Contract Our client, a top-tier... ...business requirements into scalable data structures and solutions Develop and optimize SQL queries for analytics and reporting...Contract workLocal area
RIT Solutions, Inc.
McLean, VA6 hours ago $126.3k - $243.1k
...Data Architect At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger... ...government forward! You Are: The Chip and Joanna Gaines at developing data pipelines. Like turning a fixer-upper house into the best...Live inFlexible hoursAccenture Federal Services
Washington DC2 days ago$165.66k - $217.42k
...design digital solutions that enable healthcare to work better for everyone. Operating at the intersection of healthcare, technology, data, and analytics, we are helping unlock the full potential of digital health, transforming how clinical research is conducted, how...Temporary workWork at officeWorldwide3 days per weekEvinova
Gaithersburg, MD1 day ago- ...Job Family : Data Engineering & Architecture Consulting Travel Required : Up to 25% Clearance Required : Active Secret What You Will Do As a Data Architect, you will lead the design, implementation, and evolution of enterprise‑scale data architectures...Temporary workFlexible hours
Guidehouse
Arlington, VA3 days ago - ...Data Engineering Support J5 Consulting is a Maryland based company established in... ...datasets. Demonstrated experience with developing robust API integrations with proper... ...experience with dimensional modeling and data warehouse design patterns. Demonstrated...For contractorsLocal area
J5 Consulting
Washington DC2 days ago - ...Data ArchitectLocation: On-site at the National Geospatial-Intelligence Agency (NGA) Springfield, VAClearance Required: Active TS/SCIEmployment... ...such as Amazon RDS, Redshift, and Microsoft SQL Server.Develop and support ETL-based data synchronization using AWS services...
Aerstone
Springfield, VA4 days ago - ...The Squires Group is seeking a Senior Data Architect to support a high-profile federal... ...models, and enterprise data solutions. Develop and optimize ETL/ELT pipelines, data... ...Snowflake, data lakes, or enterprise data warehouses. Knowledge of DataOps, CI/CD, CDC methodologies...Hourly payContract work
The Squires Group
Washington DC13 hours ago - ...customers. I2X Technologies is seeking a Senior Data Architect to support ongoing activities... ...delivery architecture is designed and developed. They must have a service mindset, be... ...Snowflake. Experience implementing data warehouses utilizing Change Data Capture (CDC)...Work experience placementLong distance
Isys Technologies
Washington DC3 days ago - ...Description An Insight Global client is looking to hire a Sr. Data Engineer to join their team of 16 in Arlington, VA. This is a... ...projects at one time. We are looking for someone to be an architect, developer and mentor to junior level team members. You can expect 75% of...
Insight Global
Arlington, VA4 days ago - ...Senior Data Modeler Freddie Mac Location: Role is on-site at McLean VA office 5 days/week local candidates only. Final interview will be onsite Rate = $58-63/hr. on C2C Visa: USC or Green Card About the team: Capco...Work at officeLocal area
3B Staffing LLC
McLean, VA2 days ago - ...Data Architect Why choose between doing meaningful work and having a fulfilling life? At MITRE, you can have both. That's because... ...Community. The Data Architect will play a critical role in developing policy and strategy, enterprise architecture, and acquisition plans...InternshipLocal area
MITRE
McLean, VA2 days ago - ...Sr. Data Architect Location: Reston, VA (Hybrid – 1–2 Days Onsite per Month) Job Type: Contract Interview Type: Onsite interview... ...architecture and define optimized target-state models on AWS. Develop and maintain data models using ERWIN or similar modeling tools....Contract workLocal area
Lumen Solutions Group Inc.
Reston, VA2 days ago - ...Req ID: 39697 Summary Data Architect Arlington, VA Are you ready to enhance... ...decision-making. Responsibilities Develop and maintain enterprise data architectures... ...framework, including data models, databases, warehouses, lakes, and pipelines, aligning with...
Chenega Corporation
Arlington, VA5 days ago $196.37k
...Data Architect The ACLU seeks applicants for the full-time position of Data Architect... ...data. A proven track record of developing and implementing data strategies and tactical... ...like Redshift or similar cloud data warehouse solutions, such as Snowflake, Azure Data...Full timeWork at office2 days per weekACLU - National Office
Washington DC13 hours ago- ...applications, leveraging Agile development, and Data Analytics. Since we were formed in August... ...Job Responsibilities Develop data architecture, standards, and strategies... ...Support the design and implementation of data warehouses, data lakes, and other data storage...Work experience placement
TechSur Solutions
Reston, VA13 hours ago - ...Data Modeler LOCATION Tysons, VA 22182 CLEARANCE TS/SCI Full Poly (Please note this position requires full U.S. Citizenship)... ...Architect, Database Designer, Data Analyst, Business Intelligence Developer, Data Engineer, Data Scientist, ETL Developer, Information...Temporary workFor contractorsImmediate startFlexible hours
Cymertek
McLean, VA2 days ago - ...Data Warehouse Architect Design, enhance and maintain logical and physical data warehouse models. Will work with the business and the... ...create physical and logical data models to meet business needs. Develop and document overall data sourcing, data transformation and...Night shift
Software Technology Inc
Washington DC3 days ago - ...our talented Team. Job Title: Senior Data Architect Job Location: Washington, DC Project Description: Design, develop and implement modern data infrastructure... ...Snowflake. Experience implementing data warehouses utilizing Change Data Capture (CDC)...Work experience placement
Ampcus
Washington DC4 days ago - ...Paid time off Stealth Solutions is seeking an experienced Data Architect to lead data modeling, API strategy, and integration architecture... ...complex Salesforce and external system integrations Develop MuleSoft integration patterns (API-led, event-driven, real-time,...Contract workWork from homeFlexible hours
Stealth Solutions LLC
Sterling, VA1 day ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Warehouse Developer. Be the first to apply!
