This is an in-office position from our corporate headquarters in Louisville, Ky.

You will be a great fit for this role if:

• You are highly proficient with SQL and enjoy using it to solve complex logic problems
• You want to continue learning new skills and methodologies to become a better developer
• You enjoy helping others and get a thrill from others gaining insight based on your work
• You pay attention to details but also understand how your work fits into the larger picture
• You are willing to embrace Agile principles and practices
• You enjoy a fast-paced business atmosphere with co-workers that are committed, focused, open, and driven towards success

Key Responsibilities:

• Build and maintain ETL and Data Warehouse objects (including SSIS, Transactional Replication/CDC, SQL Procedures, MicroStrategy semantic model, SSAS, MDS/DQS, BIML, PowerShell scripts)
• Contribute to the design and optimization of our data layer as the company’s single layer of the truth
• Translate business requirements into detailed, production-level technical specifications and data models
• Contribute to our ETL framework by learning our current capabilities and leveraging your unique insights and experience
• Modify existing reports and/or to develop new reports by analyzing databases, data sources, and structures for the benefit of users

Required Qualifications:

• Eight years of experience working with data warehouses; Microsoft SQL Server preferred
• Three years of experience designing, implementing and maintaining normalized, operational data store, and dimensionally modeled database systems.
• Five years of experience designing and developing Extraction, Transform and Load (ETL) processes.
• Bachelor’s degree or equivalent work experience in Computer Science or a related discipline
• Strong experience using SQL including complex stored procedures, common table expressions, analytic functions, query optimization, and indexing
• Working knowledge of data management and data warehousing technologies related to data modeling, database administration and performance tuning, archiving and disaster recovery
• Three years of experience with object oriented languages; preference with C#, PowerShell, or Python

Desired Qualifications:

• Experience working with low-latency data systems (stream processing, CDC, etc.)
• Experience using agile/scrum methodologies to iterate quickly on product changes, developing user stories and working through backlogs
• Experience with Business Intelligence tools (MicroStrategy preferred)
• Experience working with multi-terabyte data sets
• Experience designing and building enterprise conceptual or logical data models
• Ability to effectively communicate at different levels in and across the organization and to articulate to non-technical audiences the advantages and disadvantages of using various technologies and standards