The DFCI Enterprise Data Warehouse Operations Lead 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.Â Responsibilities include analyzing business requirements, and designing, developing, and unit testing integration solutions to meet customer needs. This individual works on problems of moderate to large scope in which analysis of situation or data requires a review of identifiable factors.
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 data warehousing 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 lead with extensive enterprise background using MS SQL Server. The EDW Operations Lead 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.
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
Guide and oversee a team of personnel focused on technical issues, including software development and production releases
Integrate source system data into the EDW, including initial development of extraction/integration routines
Maintain EDW Infrastructure including Server Maintenance and Software/Hardware Upgrades
Use the Operations Console (part of the Health Catalyst family of products) to configure batches, execute ETL tasks and monitor health of the EDW
Architecting the strategic data architecture roadmap and creating a short and long term implementation plan including database design and the development of data relationship structures to meet business requirements and objectives
Work closely with Director, Enterprise Data Warehouse, business and technical data users, data warehouse and system design/developers, database team , external vendors, and other data stakeholders and the management team in executing Health Catalyst project tasks and responsibilities
Provide expertise and architectural leadership in the areas of Data Governance and Master Data Management
Work with EDW team to integrate data across Clinical, Genomics, Administrative, and financial source systems including the management of critical master data
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, Genomics, Financial and Research Analytics
Create EDW Data Marts using the Source Mart Designer and SAM Designer tools
Create and execute test plans using end-user success criteria as a guide
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
Perform Peer document reviews and code reviews to ensure adherence to user requirements as well as established standards and conventions.
Evaluate and recommend new tools and methodologies to assist in meeting business requirements through data integration.
Bachelorâ€™s degree required, preferably in Computer Science, financial/operating systems data architecture, or a related technical field
Minimum 8 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)
4+ years of experience programming in T-SQL
Experience with Enterprise Data Warehouse Production Operations
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 and Informatica
Experience working with relational databases including SQL Server and Oracle
Must have a strong understanding of Kimball approach to data warehousing using denormalized star schemas and snowflakes
Experience working with Epic and Peoplesoft
Rewrite and correct existing inefficient or poorly performing queries and stored procedures/T-SQL to run more efficiently and to ensure stronger performance
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
Prior experience working with healthcare financial and revenue cycle systems is strongly preferred
ADDITIONAL KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED:
Excellent Written and Oral Communication Skills
Delegate technical tasks to resources
Must be able to identify, triage, action plan, and resolve or dispatch issues
Must be able to build and manage relationships with all involved, managing expectations at all levels
Must be capable of working independently with limited to no supervision
Demonstrates potential for technical proficiency, creativity, collaboration with others and independent thought
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.
Internal Number: 2021-23697
About Dana-Farber Cancer Institute
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 under-served members of our community; and we work with amazing partners, including other Harvard Medical School-affiliated hospitals.