Data Warehouse Developer

BMC Software

1d•Remote

About The Position

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 across all organizational levels 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, while also demonstrating the ability to lead development efforts using non-Epic data sources. Collaborates with the BI Architect on the creation of custom Caboodle data models and on the design, development, and maintenance of BI solutions derived from other organizational systems. Performs responsibilities independently and demonstrates sound judgment, initiative, and minimal need for supervisory direction. Position: Data Warehouse Developer Department: Clinical and Enterprise Analytics Schedule: Full Time Location: Remote ESSENTIAL RESPONSIBILITIES / DUTIES: The ideal candidate will possess advanced ETL development expertise within the Epic Caboodle framework and demonstrate proficiency with complementary data-warehouse technologies such as SSIS/Informatica. Design, develop, and implement robust Caboodle ETL pipelines, contributing to the continued growth, standardization, and scalability of the Caboodle Data Warehouse. Conduct data discovery and source-system analysis to understand data structures, assess data quality, evaluate upstream workflows, and inform optimal ETL and dimensional modeling approaches. Collaborate with BI architects, developers, analysts, and operational stakeholders to design, validate, and publish high-quality ETL processes, including the creation and maintenance of associated ETL metadata using Caboodle tools and SSIS. Administer and help support the Microsoft data warehouse toolset (including SSIS, SSMS, and SQL Server) by performing/assisting upgrades, maintenance, configuration, and troubleshooting to ensure optimal performance for the development team. Participate in and uphold design reviews, code standards, and development best practices, working closely with cross-functional IT teams to promote consistency, quality, and reusability. Provide timely issue resolution during QA and User Acceptance Testing (UAT) by investigating and correcting ETL logic, data quality issues, or environment-related defects. Troubleshoot, diagnose, and resolve ETL process failures and data anomalies, using auditing, monitoring tools, and root-cause analysis to maintain accuracy, reliability, and stability across the data-warehouse ecosystem. Enhance automation, monitoring, and operational reliability by recommending improvements to ETL frameworks, alerting, logging, and workflow orchestration.

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
Thorough understanding of the relational database model and experience in designing, modeling, developing and supporting data warehouses.
Experience working with diverse data sources.
Knowledge of SQL query optimization and performance tuning.
Experience in entity relationship data modeling and data modeling tools.
Knowledge of star and snow-flake schemas.

Nice To Haves

Epic Caboodle Development for Clarity Data
Epic Caboodle Development for Non-Epic Data
Epic Caboodle Data Model
Epic Clarity Data Model
Epic Clinical Data Model

Responsibilities

Design, develop, and implement robust Caboodle ETL pipelines, contributing to the continued growth, standardization, and scalability of the Caboodle Data Warehouse.
Conduct data discovery and source-system analysis to understand data structures, assess data quality, evaluate upstream workflows, and inform optimal ETL and dimensional modeling approaches.
Collaborate with BI architects, developers, analysts, and operational stakeholders to design, validate, and publish high-quality ETL processes, including the creation and maintenance of associated ETL metadata using Caboodle tools and SSIS.
Administer and help support the Microsoft data warehouse toolset (including SSIS, SSMS, and SQL Server) by performing/assisting upgrades, maintenance, configuration, and troubleshooting to ensure optimal performance for the development team.
Participate in and uphold design reviews, code standards, and development best practices, working closely with cross-functional IT teams to promote consistency, quality, and reusability.
Provide timely issue resolution during QA and User Acceptance Testing (UAT) by investigating and correcting ETL logic, data quality issues, or environment-related defects.
Troubleshoot, diagnose, and resolve ETL process failures and data anomalies, using auditing, monitoring tools, and root-cause analysis to maintain accuracy, reliability, and stability across the data-warehouse ecosystem.
Enhance automation, monitoring, and operational reliability by recommending improvements to ETL frameworks, alerting, logging, and workflow orchestration.