> Markdown version of [/jobs/ext/2716086-data-warehouse-architect-4](https://www.wearedevelopers.com/jobs/ext/2716086-data-warehouse-architect-4). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Architect 4 - **Company:** Intersources Inc. - **Location:** Chesterfield, VA, United States (Remote available) - **Contract:** Permanent contract - **Skills:** Microsoft Azure, Data Mapping, Data Mart, Data Warehousing, File Systems, Apache Hadoop, Microsoft SQL Server, SQL Server Integration Services, Azure Data Factory, Data Lakes, Data Pipelines, Workday - **Published:** September 4, 2026 - **Apply:** https://www2.jobdiva.com/portal/?a=62jdnw10t7d77ytz0lbaey9qxonk3b05a9tqw96rb7z6hlfo7xj79l9g6mp6aj2o&compid=0/jobs/27794696#/jobs/27794696 ## About the Role *Local Richmond area candidates or those willing to relocate to the Richmond area during this engagement due to onsite work requirement *ONSITE interviews only *Candidates must be willing and able to work onsite 3 days/week, NO Exceptions Candidate will be expected to create and modify pipelines with a cloud-based Enterprise Resource Planning (ERP) system. To manage these pipelines the candidate will need experience with Azure Data Factory (ADF) and Sql Server (SSIS) pipelines. Candidate will be creating data pipelines that support data marts and will be expected to code processes according to our standards. Candidate will be well-versed in current methodologies for synchronizing data mart datasets from source systems via file-based extracts. Working with our business partners to develop data mapping from one system to another is desirable but not strictly required. Skill Required / Desired Amount of Experience Candidate will need to be experienced with Azure Data Factory Pipeline development for both Azure and local Sql Server environments.Required5YearsCandidate will need to be experienced with SSIS development for both Azure and local Sql Server environments.Required2YearsCandidate will ideally have experience with Azure file storage data sources (data lake, blob, hadoop)Highly desired1YearsCandidate will be expected to successfully complete training on HIPAA and PIIRequired Candidate should have excellent communication skills (written and verbal)Required Candidate will need to be self motivated, independent, and willing to work flexible hours.Required Candidate will be expected to work from home on occasion and therefore required to have a dependable high speed internet connection.Required Candidate will be expected to pass CJIS background checks.Required Candidate will have experience authoring Workday reports and outbound integrationsNice to have Candidate should be comfortable mentoring other personnel regarding Workday technologies.Nice to have Ideally, candidate would have experience working with Workday StudioNice to have ## Related Videos - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Destigmatizing the Workplace: Building Real Inclusion](https://www.wearedevelopers.com/videos/1492-destigmatizing-the-workplace-building-real-inclusion) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [WeAreDevelopers LIVE - How DevRel Makes Tech More Human](https://www.wearedevelopers.com/videos/2149-wearedevelopers-live-how-devrel-makes-tech-more-human) - [The Data Mesh as the end of the Datalake as we know it](https://www.wearedevelopers.com/videos/156-the-data-mesh-as-the-end-of-the-datalake-as-we-know-it) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)