Boston Medical Center (BMC) · 1 day ago
Data Warehouse Developer (Caboodle)
United States
Full-time
Remote
Mid, Senior Level
$72K/yr - $104K/yr
5+ years expBoston Medical Center (BMC) is seeking a Data Warehouse Developer (Caboodle) to deliver enterprise-level data solutions that enhance patient care and services. The role involves designing and implementing robust BI and analytics capabilities, primarily using Epic Clarity and Caboodle data models, while collaborating with various stakeholders across the organization.
Non ProfitHealthcareHospitalHealth CareMedical
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
Qualification
Required
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
Preferred
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
Benefits
Medical
Dental
Vision
Pharmacy
Discretionary annual bonuses
Merit increases
Flexible Spending Accounts
403(b) savings matches
Paid time off
Career advancement opportunities
Resources to support employee and family well-being
Company
Boston Medical Center (BMC)
Boston Medical Center (BMC) is a 511-bed, equity-led academic medical center and a proud member of the Boston Medical Center Health System.
5001-10000 employees
H1B Sponsorship
Boston Medical Center (BMC) has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (53)
2024 (51)
2023 (51)
2022 (38)
2021 (26)
2020 (32)
Funding
Current Stage
Late StageTotal Funding
$342.49MKey Investors
AmeriCorps Public AlliesNational Institute on Drug Abuse (NIDA)The Boston Foundation
2024-07-09Grant· $0.06M
2023-02-23Debt Financing· $232M
2019-04-23Grant· $89M
Leadership Team
David Beck
Senior Vice President & Chief Legal Counsel
Recent News
2025-11-11
2025-11-10
Company data provided by crunchbase