Data Warehouse Developer

Churchill Downs Incorporated; Louisville (KY); On-site; USD 85,000 - 120,000; Full time

Job summary

Churchill Downs Incorporated (CDI), headquartered in Louisville, KY, seeks a Data Warehouse Developer to design, implement, and maintain our data warehouse and reporting systems to empower self-serve analytics for users. You will work in a collaborative Scrum environment, building ETL processes and semantic models with MicroStrategy/SSAS and SQL Server.

The role requires a Master’s degree and 2+ years’ experience as a data engineer or data developer, with a focus on scalable, high-volume data

Qualifications

• Master’s degree in computer information technology, computer science, business analytics, data analytics, or a related field.
• 2+ years of experience as a data engineer or data developer.
• Design, implement, and optimize enterprise-scale data warehouse and data store architectures across business domains.
• Architect ETL pipelines with SSIS, BIML, replication and CDC for high-volume environments.

Responsibilities

• Design, implement, and maintain the data warehouse and reporting systems to enable pre-designed reports and self-serve analysis.
• Translate business requirements into detailed technical specifications and data models.
• Collaborate in an agile/Scrum environment to deliver scalable data solutions.

Skills

Data warehousing

ETL pipelines

SQL development

Semantic models

Self-service analytics

Education

Master’s degree in IT/CS/Analytics

Tools

SSIS

BIML

SSAS

Transactional Replication

Change Data Capture

Job description

Select how often (in days) to receive an alert:

Churchill Downs Incorporated (“CDI”) (Nasdaq: CHDN) has been creating extraordinary entertainment experiences for more than 150 years, beginning with one of the most iconic and enduring events in sports and entertainment—the Kentucky Derby. Headquartered in Louisville, Kentucky, CDI blends a rich legacy with a forward-looking approach to growth. Through the acquisition, development, and operation of live and historical racing entertainment venues, the expansion of online wagering services and other technologybusinesses, and the ownership and operation of regional casino gaming properties, CDI offers diverse career opportunities across the country. Our success is driven by dedicated team members who are passionate about delivering exceptional experiences, embracing innovation, and helping shape the future of entertainment.

JOB SUMMARY

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 modeleddatabase 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.

EDUCATION AND EXPERIENCE

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.

CHURCHILL DOWNS INCORPORATED

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability.

Work With Us

Churchill Downs Incorporated is an inclusive and fun place to work. We celebrate unique approaches and points of view. We believe diversity is a mindset that drives excellence. We’re always learning, evolving and growing. We innovate through mutual respect of ideas and collaboration. This allows us to build a common language that inspires our team members and propels us toward the achievement of our vision.