We have an opening for EDW Developer II 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 II utilizes best practices surrounding code standards, reusable and scalable code to build semantic layer. This role works with Data Modeler and DBA to develop dimensional model (Star Schema) for EDW Semantic Layer. This role will be responsible for the following items in addition to other duties as assigned.
Develops Enterprise Data Warehouse Semantic Layer.
Utilizes Premise Health IT Toolset for agile and collaborated development
Utilize best practices surrounding reusable and scalable code
Builds Enterprise Data Warehouse data mart and semantic layer including aggregated tables, views and stored procedure
Work with Business Intelligence developers to understand front end design
Work with EDW Developer to understand EDW Semantic architecture
Work with Data Quality Analysts to ensure data quality.
Work with DBA to ensure query performance aligns with performance guidelines defined.
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 preferred or equivalent work experience
Minimum 3-5 years of experience designing, implementing, performance tuning and troubleshooting
3-5 years' experience designing and building Enterprise Data Warehouse solutions
Involved in projects using agile methodologies preferred
Experience with Epic Caboodle preferred.
Experience in the IT Healthcare industry preferred.
3-5 years' experience utilizing Microsoft SSIS or other ETL tools
3-5 years' experience SQL development including stored procedures, macros, functions
Very Strong SQL skills
Demonstrated knowledge around dimensional models or star schemas.
ETL solutions integrating multiple data sources, including data analysis and solution modeling
Strong experience with databases and database objects in MS SQL Server