Data Warehouse Developer – Caboodle
Job Description: • Responsible for delivering enterprise-level data solutions that empower business partners to provide affordable, high-quality patient care and services. • Engages with business owners and stakeholders to design and implement robust BI and analytics capabilities. • Develops, tests, and documents business intelligence and analytics solutions primarily leveraging Epic Clarity and Caboodle data models. • Collaborates with the BI Architect on the creation of custom Caboodle data models and maintenance of BI solutions. • Participates in design reviews, code standards, and development best practices. • Troubleshoots, diagnoses, and resolves ETL process failures and data anomalies. Requirements: • Bachelor's degree in Computer Science, Management Information Systems, Engineering or equivalent work experience is required • Minimum five years of paid work experience as a Developer using SQL Server SSIS or equivalent ETL tool. • Minimum 2 years of experience with developing ETL for Epic Caboodle Data Warehouse • Minimum five years of experience with T-SQL or ANSI SQL coding and tuning • Minimum three years working in relational databases. • Experience with utilizing star schema data stores as the basis for ETL targets Benefits: • Health insurance • 403(b) savings matches • Flexible Spending Accounts • Paid time off • Discretionary annual bonuses • Career advancement opportunities • Resources to support employee and family well-being