We have an opening for EDW Developer to work at our corporate headquarters in Brentwood, TN!
Premise Health is a leading worksite health and patient engagement company dedicated to improving the cost and quality of employee healthcare. We believe healthcare should be about helping people get, stay and be well. That's our mission and it's the foundation of everything we do. With more than 40 years of experience, Premise Health manages more than 500 worksite-based health and wellness centers across the country. The company serves more than 200 of the nation's leading employers, including a significant number of the Fortune 1000.
Enterprise Data Warehouse (EDW) Developer utilizes best practices surrounding code standards, reusable and scalable code to build Caboodle Data Warehouse. This role will be responsible for the following items in addition to other duties as assigned.
Develops Enterprise Data Warehouse.
Utilizes Epic Caboodle Toolset for agile and collaborated development
Utilize best practices surrounding reusable and scalable code
Creates tables, views and stored procedure to support Premise Health Analytical needs
Work with Business Intelligence developers to understand front end design
Work with Data Integration team in building staging area
Work with Microsoft BI data tools stack
If you want to join a team of knowledgeable, compassionate, like-minded healthcare professionals, join Premise Health for an unlimited opportunity with the company that is changing the face and the place of the healthcare industry as we know it.
We are an equal opportunity employer.
Bachelor's Degree in a Business or Science discipline or a related discipline
1-3 years' experience designing and building Enterprise Data Warehouse solutions
1-3 years' experience SQL development including stored procedures, macros, functions
Star Schema Knowledge
Experience in Epic a plus
Experience in Caboodle/Star Development a plus
Experience in Clarity Data Models a Plus
Experience in Agile - Scrum a plus
Previous experience with ETL tools (Cognos, Informatica, etc) a plus
Advanced skills in MS SQL Server (tuning, designing for performance) preferred