Boston Medical Center (BMC)

Data Warehouse Developer – Caboodle

Boston Medical Center (BMC)

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $89,500 - $130,000 per year

Tech Stack

About the role

  • Deliver enterprise-level data solutions that empower business partners to provide affordable, high-quality patient care and services
  • Engage with business owners and stakeholders across all organizational levels to design and implement robust BI and analytics capabilities
  • Develop, test, and document business intelligence and analytics solutions primarily leveraging Epic Clarity and Caboodle data models
  • Collaborate with the BI Architect on the creation of custom Caboodle data models
  • Design, develop, and implement robust Caboodle ETL pipelines
  • Conduct data discovery and source-system analysis
  • Collaborate with BI architects, developers, analysts, and operational stakeholders to design, validate, and publish high-quality ETL processes
  • Provide timely issue resolution during QA and User Acceptance Testing (UAT)

Requirements

  • Bachelor's degree in Computer Science, Management Information Systems, Engineering or equivalent work 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
Benefits
  • medical insurance
  • dental insurance
  • vision insurance
  • pharmacy
  • discretionary annual bonuses
  • merit increases
  • Flexible Spending Accounts
  • 403(b) savings matches
  • paid time off
  • career advancement opportunities
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQL Server SSISETLT-SQLANSI SQLEpic ClarityCaboodledata modelingdata discoverysource-system analysisstar schema
Soft Skills
collaborationcommunicationproblem-solvingstakeholder engagementissue resolutiondocumentationanalytical thinkingorganizational skillsquality assuranceuser acceptance testing
Certifications
Bachelor's degree in Computer ScienceBachelor's degree in Management Information SystemsBachelor's degree in Engineering