> Markdown version of [/jobs/ext/2196536-data-warehouse-developer](https://www.wearedevelopers.com/jobs/ext/2196536-data-warehouse-developer). 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 Developer

- **Company:** Churchill Downs Incorporated
- **Location:** Louisville, KY, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Agile Methodology, Business Analytics Applications, C Sharp (Programming Language), Databases, Data Files, Data Infrastructure, Extract Transform Load (ETL), Data Structures, Data Warehousing, Disaster Recovery, Python (Programming Language), Logical Data Models, Microsoft SQL Server, MicroStrategy, Operational Data Store, Object-Oriented Software Development, Performance Tuning, Windows PowerShell, Scrum Methodology, Query Optimization, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, SQL Server Analysis Services, Systems Integration, Database Optimization, Analytic Functions, Change Data Capture, Indexer, Data Layers, Build Management, Information Technology, Data Analytics, Data Management
- **Published:** August 23, 2026
- **Apply:** https://www.dice.com/job-detail/40028720-675e-4807-ac50-f117c504dc89

## About the Role

Education Requirement: Master's degree in computer information technology, computer science, business analytics, data analytics, or a related field.

Experience Requirement: Two (2) years of experience as a data engineer or data developer.

REQUIRED SKILLS AND ABILITIES

Must have work experience in each of the following: 1) designing, implementing, and optimizing enterprise-scale data warehouse and operational data store architectures, including normalized and dimensionally modeled systems, serving as a single source of truth across business domains; 2) architecting and maintaining sophisticated ETL pipelines leveraging SSIS, BIML, Transactional Replication and Change Data Capture, with an emphasis on scalability, data quality, and performance in high-volume environments; 3) developing and maintaining semantic models and analytical layers using platforms such as MicroStrategy and SSAS, enabling governed self-service analytics while abstracting complex data structures for business users; and 4) advanced SQL development, including complex stored procedures, analytic functions, query optimization, and indexing strategies, specifically tuned for multi-terabyte data environments and mission-critical reporting systems.

## Description

The Data Warehouse Developer will utilize (BI) development skills, including MicroStrategy, in a highly collaborative Scrum environment. As a part of the BI team, the Data Warehouse Developer will design, implement, and maintain our data warehouse and front end reporting systems that allow users to access to pre-designed reports and self-serve analysis. They will work with data warehouses and utilize Microsoft SQL Server and support our growing brick and mortar gaming facilities. Specifically, the Data Warehouse Developer will perform the following day-to-day job duties: Build and maintain Extraction, Transform, and Load (ETL) and Data Warehouse objects (including Transactional Replication/CDC, SQL Procedures, MicroStrategy semantic model, SSAS, MDS/DQS, BIML, PowerShell scripts); SSIS, Translate business requirements into detailed, production-level technical specifications and data models; Modify existing reports and/or develop new reports by analyzing databases, data sources, structures
for the benefit of users; Use SQL including complex stored procedures, common table expressions, analytic and functions, query optimization, and indexing; Design, implement, and maintain normalized, operational data store, and dimensionally modeled database systems; Design and develop ETL processes while utilizing Microsoft SQL Server Integration Services (SSIS); Use object-oriented languages such as C#, PowerShell, or Python; Use Agile and Scrum methodologies to iterate quickly on product changes, develop user stories, and work through backlogs; Understand data management and data warehousing technologies related to data modeling, database administration and performance tuning, archiving, and disaster recovery; Work with multi-terabyte data sets; Design and build enterprise conceptual or logical data models; and Contribute to the design and optimization of CDI's data layer as the company's single layer of the truth.


## Related Videos

- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Introduction to TXT](https://www.wearedevelopers.com/videos/30-introduction-to-txt)
- [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [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)