> Markdown version of [/jobs/ext/2577589-software-engineer-data-warehousing](https://www.wearedevelopers.com/jobs/ext/2577589-software-engineer-data-warehousing). 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).

---

# Software Engineer, Data Warehousing

- **Company:** Techneptune Consulting Inc
- **Location:** United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Microsoft Azure, Big Data, Information Engineering, Data Integration, Data Mart, Data Warehousing, JSON, Microsoft SQL Server, SQL Azure, Operational Data Store, Oracle (Applications), Parsing, Query Optimization, Standard Sql, Data Processing, Azure Data Factory, Sql Optimization, Snowflake, Semi-structured Data, Real Time Data, Oracle Ebusiness, Restful APIs
- **Published:** August 18, 2026
- **Apply:** https://www.dice.com/job-detail/08a8d0dc-c1a4-4e12-9940-eaa411a5f8d1

## About the Role

* 10+ years of experience in data engineering or data warehousing
 * Advanced SQL expertise across:

 * Oracle
 * SQL Server / Azure SQL
 * Snowflake

Strong hands-on experience with Azure Data Factory (ADF) (required)

Advanced SQL query capabilities, including but not limited to: Joins, aggregations, memory tables, CTEs, subqueries (all candidates will be screened for this ability)

Experience implementing:

 * Incremental data loads
 * UPSERT / MERGE patterns

Experience integrating data from:

 * Oracle EBS or similarly complex ERP systems
 * REST APIs as data sources
 * Managing orchestrated workflows involving placement of sFTP files

Strong experience working with:

 * JSON data structures and parsing in SQL
 * Hybrid structured and semi-structured datasets

## Description

The Senior Data Warehouse Engineer is responsible for designing, building, and optimizing enterprise data pipelines and data models to transform complex operational data into scalable, consumable datasets. This role will focus on modernizing data from Oracle EBS and other sources into Azure-based platforms, enabling near real-time data availability through incremental load and UPSERT patterns. This role requires deep expertise in Azure Data Factory, strong SQL engineering skills, and experience working with both structured and semi-structured data, including JSON. The engineer will also integrate external data sources via REST APIs and help standardize data for downstream reporting and analytics., * Design, build, and maintain data pipelines using Azure Data Factory (ADF)

 * Develop and implement incremental data processing patterns, including UPSERT/MERGE logic
 * Ingest and transform data from Oracle EBS into Azure SQL and Snowflake
 * Integrate REST API-based data sources into enterprise data pipelines
 * Design and maintain data warehouse and data mart structures (star/snowflake schemas)
 * Transform and normalize semi-structured data (JSON) into relational models
 * Optimize performance for large-scale datasets (indexing, partitioning, query tuning)
 * Establish standards for data modeling, naming conventions, and pipeline design
 * Partner with BI/reporting teams to ensure data is accurate, performant, and consumable
 * Troubleshoot and resolve issues across ingestion, transformation, and storage layers
 * Provide technical leadership, mentoring, and best practices in data engineering


## Related Videos

- [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [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)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure)
- [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)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [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)
- [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)