BMC Software

Compensation

Full Description

POSITION SUMMARY: 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. JOB REQUIREMENTS EDUCATION: Bachelor's degree in Computer Science, Management Information Systems, Engineering or equivalent work experience is required PREFERRED CERTIFICATIONS: 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 EXPERIENCE: 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 KNOWLEDGE AND SKILLS: 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. Compensation Range: $66,500.00- $96,500.00 This range offers an estimate based on the minimum job qualifications. However, our approach to determining base pay is comprehensive, and a broad range of factors is considered when making an offer. This includes education, experience, skills, and certifications/licensures as they directly relate to position requirements; as well as business/organizational needs, internal equity, and market-competitiveness. In addition, BMCHS offers generous total compensation that includes, but is not limited to, benefits (medical, dental, vision, pharmacy), discretionary annual bonuses and merit increases, Flexible Spending Accounts, 403(b) savings matches, paid time off, career advancement opportunities, and resources to support employee and family well-being. NOTE: This range is based on Boston-area data, and is subject to modification based on geographic location. Equal Opportunity Employer/Disabled/Veterans According to the FTC, there has been a rise in employment offer scams. Our current job openings are listed on our website and applications are received only through our website. We do not ask or require downloads of any applications, or “apps” job offers are not extended over text messages or social media platforms. We do not ask individuals to purchase equipment for or prior to employment. Working at Boston Medical Center is more than a job. It’s a chance to make a difference as part of our mission to provide exceptional and equitable care to all. As a nationally-recognized leader in health equity, nursing, initiatives to combat climate change, and many other areas, BMC is dedicated to improving the health of our community in Boston and beyond. BMC’s mission to provide exceptional care without exception extends to our employees, and we have been recognized as a top employer and best place to work. A strong sense of teamwork and support for our staff are the bedrock of BMC, as we know that we can only provide exceptional care to patients when our staff are cared for too. Boston Medical Center is an equal employment/affirmative action employer. We ensure equal employment opportunities for all, without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity and/or expression or any other non-job-related characteristic. If you need accommodation for any part of the application process because of a medical condition or disability, please send an e-mail to Talentacquisition@bmc.org or call 617-638-8582 to let us know the nature of your request. Boston Medical Center participates in the Electronic Employment Verification Program. As an E-Verify employer, prospective employees of BMC must complete a background check before beginning their employment at the hospital. BMC requires all staff to be vaccinated against COVID-19 and flu, as well as receive a booster dose of the COVID-19 vaccine. According to the FTC, there has been a rise in employment offer scams. Our current job openings are listed on our website and applications are received only through our website. We do not ask or require downloads of any applications, or “apps” job offers are not extended over text messages or social media platforms. We do not ask individuals to purchase equipment for or prior to employment. To avoid becoming a victim of an employment offer scam, please follow these tips from the FTC: FTC Tips