> Markdown version of [/jobs/ext/603335-senior-data-warehouse-specialist](https://www.wearedevelopers.com/jobs/ext/603335-senior-data-warehouse-specialist). 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). --- # Senior Data Warehouse Specialist - **Company:** Ivory Cloud LLC - **Location:** United States (Remote available) - **Experience:** Expert - **Salary:** $115,000.0 - $150,000.0 - **Contract:** Permanent contract - **Skills:** Amazon S3, Big Data, Cloud Computing, Information Systems, Data as a Services, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mart, Data Migration, Data Warehousing, IBM InfoSphere DataStage, PostgreSQL, Microsoft SQL Server, Oracle (Applications), Systems Development Life Cycle, Release Management, Software Deployment, SQL Databases, SQL Server Integration Services, Enterprise Data Management, Informix, Information Technology, Atlassian Tools, Data Pipelines, Databricks, Control M - **Published:** June 20, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=94376982bbadef2c ## About the Role Do you have experience in Tooling?, Do you have a Bachelor's degree?, · U.S. Citizenship or Green Card only · Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related technical field., · 7+ years of hands-on experience designing and developing scalable ETL/ELT workflows that migrate data from multiple sources to target systems, including Master Reference Table (MRT) data. · Demonstrated expertise optimizing SQL performance and ETL package execution for efficiency, accuracy, and reliability. · Production experience with data integration tooling such as IBM DataStage, SQL Server Integration Services (SSIS), and Databricks, plus orchestration with Control-M. · Working knowledge of AWS data services (S3, Athena, Glue Crawler and Catalog, Redshift, EventBridge, Lambda) and relational platforms including Oracle, Microsoft SQL Server, IBM Informix, and PostgreSQL. · Experience delivering within an Agile/Scrum SDLC and tracking work in JIRA and Confluence. · Familiarity with federal data standards and security controls, including FISMA, FedRAMP Moderate, and NIST SP 800-53. ## Description IvoryCloud is seeking a Senior Data Warehouse Specialist. In this role, you will be responsible for designing, building, and maintaining the complex data pipelines that move information from client source systems into the reporting environments that program staff and leadership rely on to make better decisions. Data extracts will come from many sources, transform through documented business rules, and load it into an Enterprise Data system., · Design, build, and maintain complex data pipelines that extract, transform, and load data into client enterprise data warehouses and data marts. · Develop and optimize scalable ETL/ELT workflows to migrate data from multiple sources to target systems, including MRT loads. · Tune SQL and ETL package execution to meet reliability, security, and performance requirements for large data volumes. · Ensure data accuracy, quality, and reliability through validation, source-to-target reconciliation, and defect-free code prior to production release. · Provide technical leadership and guidance to junior team members and enforce development and secure-coding best practices. · Collaborate with data architects, business analysts, and quality assurance teams to deliver to schedule and meet stakeholder needs. · Support production deployments, troubleshoot production incidents, and respond to alerts within the contract's response-time standards. About IvoryCloud Ivory Cloud is a purpose-driven enterprise. We go to work every day driven to achieve for our customers, learn and master new skills, and take ownership in growing those around us. Through this purpose, we do outstanding, innovative, and high-quality work. We are building our team with a relentless focus on bettering our customers, building personal capability, and investing in the success of others. You are purpose-driven if the following describes you: · Driven by team and personal excellence. · Total focus on becoming a Subject Matter Expert in whatever role you have. · Flexible thinker who solves problems with both linear and non-linear approaches. · Excited to be a part of a growing company and committed to helping it grow. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Brewing Tea over the Internet](https://www.wearedevelopers.com/videos/697-brewing-tea-over-the-internet) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Business Strategies for Scaling European Tech](https://www.wearedevelopers.com/videos/1694-business-strategies-for-scaling-european-tech) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)