• Senior ETL Developer

    Location US-MA-Boston
    Job Posted Date 1 month ago(12/18/2018 6:04 PM)
    Job ID
    full time
  • Overview

    Located in Boston and the surrounding communities, Dana-Farber Cancer Institute brings together world renowned clinicians, innovative researchers and dedicated professionals, allies in the common mission of conquering cancer, HIV/AIDS and related diseases. Combining extremely talented people with the best technologies in a genuinely positive environment, we provide compassionate and comprehensive care to patients of all ages; we conduct research that advances treatment; we educate tomorrow's physician/researchers; we reach out to underserved members of our community; and we work with amazing partners, including other Harvard Medical School-affiliated hospitals.


    The Senior ETL Developer is a critical member of the Informatics & Analytics team supporting the implementation and on-going development and operations of the enterprise data warehouse (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 healthcare analytics and data warehouse architecture.  The incumbent will utilize their business analytical, architect design, and development skills to test integration solutions to ensure the needs of their customers are met.  . This individual works on problems of moderate to large scope in which analysis of situation or data requires a review of identifiable factors.


    To be successful:

    The Senior ETD Developer will be an experienced lead developer with extensive enterprise background using MS SQL Server. The incumbent 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..  The incumbent will understand the full lifecycle of data warehousing and business intelligence projects. They will interact and build strong working relationshipswith directors, leads, architects, consultants, business analysts, co-developers and business/clinical users.


    • Designs, builds and maintains data warehouse solutions to support Reporting and Analytics projects
    • Provides expertise and architectural leadership in the areas of Data Governance and Master Data Management
    • Works 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
    • Integrates source system data into the EDW, including initial development of extraction/integration routines
    • Participates in the design, development and implementation of the Health Catalyst Platform supporting Clinical and Research Analytics
    • Uses the EDW Console (part of the Health Catalyst family of products) to configure batches, execute ETL tasks and monitor health of the EDW
    • Creates and executes test plans using end-user success criteria as a guide
    • Implement security through a combination of data and application level using role based user access
    • Use IDERA to monitor DFCI EDW data access and provide audit reports to appropriate data owners
    • Coordinate with DBAs on capacity planning, data archival, data purging, transaction log maintenance as well as backup and data recovery
    • Supports on-going production operations and maintenance of current and legacy systems.
    • 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
    • Supports troubleshooting and problem resolution activities as needed, including acting as an escalation point for technical and process issues
    • Performs Peer document reviews and code reviews to ensure adherence to user requirements as well as established standards and conventions.


    • Master’s Degree required, in Computer Science, financial/operating systems data architecture, or a related technical field
    • Minimum 6 years experience in data warehouse architecture, design, development and data integration
    • 8+ years of related professional experience including 6+ years in data warehousing development in large reporting environment(s)
    • 6+ years of experience programming in T-SQL
    • Must have a strong understanding of Kimball approach to data warehousing using denormalized star schemas and snowflakes.
    • A strong understanding of Data Architecture, ETL Architecture, advanced SQL concepts and Data warehousing tools is required.
    • Development experience with ETL tools, such as Microsoft SSIS , Informatica
    • Experience working with Epic and Peoplesoft/Oracle
    • Experience maintaining complex database applications, ability to write, understand, and tune complex SQL, T-SQL queries, stored procedures, functions, views and triggers
    • Rewrite and correct existing inefficient or poorly performing queries and stored procedures/T-SQL to run more efficiently and to ensure stronger performance
    • Experience working with relational databases including SQL Server, PeopleSoft/Oracle
    • Hands on experience performance tuning database applications including indexing, with ability to interpret execution plans
    • Strong understanding of SQL Server security, performance monitoring and optimizing
    • Experience with medical/clinical data exchange standards, such as FHIR and HL7
    • Prior experience working with healthcare financial and revenue cycle systems is strongly preferred

    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.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us!

    Not ready to apply? Connect with us for general consideration.