Share This Job
Job ID:

20 Overland Street, Boston, MA 02215


Employment Type:
Full time

Work Location:
Full Remote: 4-5 days remote/wk


The DFCI Enterprise Data Warehouse(EDW) ETL Developer is a critical member of the Informatics & Analytics team supporting the implementation and on-going development and operations of the EDW in support of the overall DFCI mission to improve quality and manage healthcare expense trends.  This is a hands-on position that requires a technical and functional understanding of data warehousing and healthcare analytics.  Responsibilities include analyzing business requirements, and architecting, designing, developing, and unit testing integration solutions to meet customer needs.

The role is expected to understand and apply best practices and provide expertise in acquiring data from source systems to build database analytic content.  As such, it is expected that the individual will understand the full lifecycle of enterprise data warehouse and business intelligence projects. The individual in this position will interact with directors, leads, architects, consultants, business analysts, co-developers and business/clinical users. The successful candidate will be an experienced developer with extensive enterprise background using MS SQL Server. The ETL Developer will be required to identify business requirements, develop data models, perform data analysis, write advanced SQL queries and triggers, design and code complex stored procedures, and maintain and performance tune existing databases.

At Dana-Farber Cancer Institute, we work every day to create an innovative, caring, and inclusive environment where every patient, family, and staff member feels they belong.  As relentless as we are in our mission to reduce the burden of cancer for all, we are equally committed to diversifying our faculty and staff.  Cancer knows no boundaries and when it comes to hiring the most dedicated and diverse professionals, neither do we. If working in this kind of organization inspires you, we encourage you to apply. 


  • Integrates source system data into the EDW, including initial development of extraction/integration routines
  • Designs, builds and maintains data warehouse solutions to support Reporting and Analytics projects
  • Work with end users, business analysts, technical staff, and other project team members to plan, design, develop, implement, and enhance application processes and overall data and process flow and user interface applications
  • Works with teams to integrate data across clinical, administrative, and financial source systems including the management of critical master data
  • Support on-going production operations and maintenance of current and legacy systems
  • Support troubleshooting and problem resolution activities as needed, including acting as an escalation point for technical and process issues
  • Self-starter with a strong desire to learn and apply the latest technologies related to database solutions
  • Participate in the design, development and implementation of the Health Catalyst Platform supporting Clinical and Research Analytics
  • Creating Source Marts for different Sources using the Source Mart Designer Tool
  • Work with Business Users and DW Architects to create and deploy Subject Area Marts using SAM designer
  • Use the EDW Console (part of the Health Catalyst family of products) to configure batches, execute ETL tasks and monitor health of the EDW
  • Applies design principals and architectural standards, including those that support security and auditing requirements
  • Develops strong working relationships with key project team members and customers to ensure activities are aligned with business objectives
  • Diagnose and resolve database access and performance issues


  • Bachelor’s degree preferably in computer science or management Information Systems
  • Minimum 4 years experience in data warehouse architecture, design, development and data integration
  • 6+ years of related professional experience including 4+ years in data warehousing development in large reporting environment(s) related to clinical, biological, and genomics data
  • Strong understanding of Data Architecture, ETL Architecture, SQL Server security, performance monitoring and optimizing
  • Strong experience with Microsoft SSIS, SSRS, Microsoft T-SQL
  • Experience working with relational databases including SQL Server and Oracle
  • 4+ years of writing complex SQL, T-SQL
  • Experience working with Epic and Peoplesoft
  • Must have a strong understanding of Kimball approach to data warehousing using denormalized star schemas and snowflakes
  • Hands on experience performance tuning database applications including indexing, with ability to interpret execution plans
  • Prior experience working with healthcare financial and revenue cycle systems is strongly preferred
  • Experience with medical/clinical data exchange standards, such as FHIR and HL7

Dana-Farber Cancer Institute is an equal opportunity employer and affirms the right of every qualified applicant to receive consideration for employment without regard to race, color, religion, sex, gender identity or expression, national origin, sexual orientation, genetic information, disability, age, ancestry, military service, protected veteran status, or other groups as protected by law.

Follow Dana-Farber on Social Media