
Data Warehouse Developer – Caboodle
Boston Medical Center (BMC)
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $89,500 - $130,000 per year
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