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.00This 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.
Top Skills
What We Do
Boston Medical Center, located in Boston’s historic South End, is a private, not-for-profit, 567-bed, academic medical center and the primary teaching affiliate for Boston University School of Medicine.
Recognized for its high-quality, nationally ranked and comprehensive medical care for the entire family, patients have access to the most current treatment and advancements at BMC. BMC physicians lead the way in pioneering new therapies that impact the care of patients locally and worldwide.
In 2013, BMC made the decision to invest in a four-year campus redesign that includes additions to buildings, upgrades to existing structures, and an expansion of the Emergency Department. Once completed, the redesign will provide clinical workspaces with state-of-the-art facilities and equipment to solve BMC's most pressing care delivery needs.
Already complete, the hospital’s Shapiro Center is Boston’s newest outpatient care facility and features a quarter-million square feet of clinic space, key support services, one of the region’s most technologically advanced pharmacies, and a bright, spacious café. Housed in a facility that provides world-class, patient-centered care at every visit, BMC doctors are among the best in their field. Many are recognized annually as “Top Doctors” in their medical and surgical specialties by publications such as U.S. News & World Report and Boston magazine.
Boston Medical Center is also the largest safety net hospital in New England and extends into the community as a founding partner of Boston HealthNet, a network of 15 community health centers throughout Boston serving more than a quarter million people annually.
No matter whom you meet at BMC, all are committed to providing every patient and family member with the highest quality of care, respect, warmth and compassion.
