Lead Data Engineer - Mount Sinai Health Partners

Summary

Mount Sinai is one of the largest non-profit health systems in the U.S. with a strong reputation for quality of care (18th ranked academic medical center) and research/education (22nd ranked medical school). Our health system has ~40,000 employees working together to provide billions of dollars in high-quality care for millions of patients each year.

We are accelerating a transition to a business model focused on population health management – our goal is to keep entire communities healthy and out of the hospital. Mount Sinai Health Partners (MSHP) is the team driving this transformation within Mount Sinai. The team includes 400+ employees with clinical, contracting, finance, IT, analytics, operations, and product development expertise.

MSHP is a fast growing business unit within Mount Sinai and is looking for team members who:

• Are comfortable “playing up” and “playing down” as needed to accomplish business objectives

• Work productively amidst ambiguity

• Thrive in fast-paced work environments

• Seek to improve the status quo

Mount Sinai Health Partners is realizing this new objective in two ways. First, we engage in value-based contracts with health plans. Using analytical insights, we deploy our clinical programs to improve the health of attributed populations and maximize customer value. Second, we have created a team to assemble our clinical and population health assets into product offerings (e.g., care bundles, worksite health centers, insurance products in partnership with health plans), and sell them to individuals and employers via multiple channels. Each of these new product offerings will have important population health features including: (1) value-based pricing (2) a curated network of high-value physicians (3) optimized care pathways and related programs, and (4) an enhanced patient experience. The goal of each product is to increase the value for employers and their employees, mitigating the effects of the affordability crisis.

Role Summary

MSHP seeks a Lead Data Engineer.

Mount Sinai Health Partners, the population health division of the Mount Sinai Health System and the Icahn School of Medicine at Mount Sinai, located in the New York Metropolitan area and ranked 5th in FastCompany’s “Top 10 Most Innovative Companies in Big Data” is searching for a highly qualified Data Engineer. In this role, you will design, develop and provision highly curated marts of data in an Oracle data warehouse and Big Data platform. These data marts fuel analysis and create insights and BI (Business Intelligence) solutions that contribute to sound strategic planning, decision-making, goal setting, and effective performance measurement.

This role would report directly to the Manager of Data Engineer.

In this role, you will be responsible for data management and engineering in support of the Actuarial Informatics team of data scientists who deliver reporting, statistical modeling and advanced analytics for each of the diverse MSHP business areas. The role will be architecting, supporting, enhancing and enriching a new Commercialization data model for supporting the data scientist team with various projects and stakeholders.

Responsibilities

• Architect and develop a comprehensive and flexible data model to handle the needs of the Commercialization Department stakeholder that meets the needs of existing and future projects.
• Guide team Data Engineers on data needs and development for project needs as well as provide insight into workflow improvement.
• Effectively collaborate and communicate with your stakeholders and customers to understand their needs and ensure all data management requests are properly triaged, recorded and tracked.
• Work hand in hand with data scientists and operational business and product resources to build a comprehensive, scalable, and integrated data model for the Commercialization business that includes consumer data, employer data, health center data and claims data.
• Work with consumer data (call, chat, other CRM, etc.), billing, clinical, enrollment, eligibility, medical claims, pharmacy claims, financial, administrative, and other corporate or third-party data from raw, modeled, and disparate internal and external sources.
  • Work with departmental staff to identify business requirements for data intake, reporting and / or business intelligence tools.
  • Ensure all data intake leverages approved enterprise methods for data exchange and transfer, including setup and utilization of secure FTP.
  • Identify necessary data, data sources and methodologies to meet the business need.
  • Work with IT or independently to collect, organize, integrate, profile and curate data, in both our Oracle RDMS, Amazon AWS and/or Microsoft Azure Hadoop.
  • Collaborate with additional teams and resources for data interoperability between various Data & IT systems.
  • Identify and address expected and unforeseen data complexities to mitigate their impact on the analytic outcome and associated business decisions. Clearly communicate data issues to the recipients and work to improve data quality where possible within the data marts you create.
  • Feed data quality issues back to IT or identified data stewards (inside and outside the team) to assist in our quest for the highest quality data.
  • Assist in building reports or dashboards that profile or express the quality of data to your stakeholders.
• Design and build complex Extract, Transform & Load (ETL) routines to ensure that data intake is consistently processed and integrated in accordance with approved business logic.
• Design and build data marts to specification to enhance efficiency of standard reporting and analyses being built by data science analysts.
• Leverage new and existing APIs to build efficient pipelines for data exchange with internal and external parties.
• Execute production programs on daily, weekly, monthly and quarterly schedule for standardized reporting and other data processes that have been built by data science analysts.
• Adhere to corporate standards for performance metrics, data collection, data integrity, query design, and reporting format to ensure high quality, meaningful analytic output.
• Work closely with IT on the ongoing improvement of Mount Sinai’s integrated data warehouse, driven by strategic and business needs, and designed to ensure data and reporting consistency throughout the organization.
• Develop and maintain project work plans, including critical tasks, milestones, timelines, interdependencies and contingencies. Track and report progress. Keep stakeholders apprised of project status and implications for completion.
• Prepare clear, well-organized project-specific documentation, including, at a minimum, data dictionaries, analytic methods used, key decision points and caveats, with sufficient detail to support comprehension and replication.
• Ability to coordinate with offshore development resources on various requests and projects.
• Share development and process knowledge with other staff to assure redundancy and continuously build a core of technical strength within the organization.
• Demonstrate proficiency with the principles and methodologies of process improvement. Apply these in the execution of responsibilities in support of a process focused approach.
• Perform other data management duties as necessary or assigned.

Qualifications

• Minimum of BA/BS degree in a relevant field of study; Master’s degree preferred.
• At least 8 (8) years of data mart or data warehouse development experience for a health provider, health plan or accountable care organization including either:
  • Comprehensive experience in architecting high performing data models for large project’s needs.
  • Understanding of standard practice models such as Star/Snowflake Schemas designs.
  • Strong understanding of health care EMR or claims systems such as Epic/Clarity, eCW, Facets, Amisys, or similar systems.
  • Knowledge of customer data that includes calls, chats and CRM.
  • Experience working in healthcare provider analytics related to revenue modeling, managed care contracting, population management, case management, clinical or financial decision support,
  • PhD, MD or DO program may be substituted for 3 years of experience
• Strong technical skills working with SQL (Oracle’s PL/SQL preferred) developing and trouble-shooting stored procedures and developing ad hoc scripts.
• Strong data mining skills using tools like SQL, R, Python, SAS, Java/MapReduce, Aster, etc.
• Ability to learn Business Intelligence products such as Tableau, Information Builders, Dimensional Insights, SAP/Business Objects, SAS, MicroStrategy, etc.
• Ability and passion to learn data acquisition, orchestration, and provisioning techniques with rapidly evolving technologies like Sqoop, Flume, Impala, Dataiku, etc.
• Strong understanding of ETL tools like Pentaho, SSIS, Data Stage, PowerCenter, etc.
• Ability to exercise critical thinking and logical reasoning, and understand the conceptual framework and database relationships underlying health care data.
• Ability to think creatively; demonstrated excellent problem solving skills.
• Excellent oral and writing skills characterized by the ability to communicate effectively with varying audiences.
• Demonstrated ability to articulate goals, plan, timelines and implement processes to achieve those goals, recognize and assess the implications of confounding variables, anticipate consequences, and meet deadlines.
• Advanced interpersonal (e.g., mediating, mentoring, teaching) skills required to service internal and external clients effectively, and manage relationships and activities that are diverse and complex.
• Self-motivated and resourceful, with a demonstrated ability to think and work independently, and to exercise independent judgment in originating or developing complex techniques or programs in a complex and dynamic environment.
• High level of integrity as demonstrated by 1) appropriate treatment of confidential or protected health information, 2) adherence to policies, procedures, rules, and regulations, 3) professional conduct in dealing with persons internal and external to the organization, and 4) sensitivity to populations served by the organization.

About the Mount Sinai Health System

The Mount Sinai Health System is New York City's largest integrated delivery system, encompassing eight hospitals, a leading medical school, and a vast network of ambulatory practices throughout the greater New York region. Mount Sinai's vision is to produce the safest care, the highest quality, the highest satisfaction, the best access and the best value of any health system in the nation.

The Health System includes approximately 7,480 primary and specialty care physicians; 11 joint-venture ambulatory surgery centers; more than 410 ambulatory practices throughout the five boroughs of New York City, Westchester, Long Island, and Florida; and 31 affiliated community health centers. The Icahn School of Medicine is one of three medical schools that have earned distinction by multiple indicators: ranked in the top 20 by U.S. News & World Report's Best Medical Schools, aligned with a U.S. News & World Report's Honor Roll Hospital, No. 12 in the nation for National Institutes of Health funding, and among the top 10 most innovative research institutions as ranked by the journal Nature in its Nature Innovation Index. This reflects a special level of excellence in education, clinical practice, and research. The Mount Sinai Hospital is ranked No. 18 on U.S. News & World Report's Honor Roll of top U.S. hospitals; it is one of the nation's top 20 hospitals in Cardiology/Heart Surgery, Gastroenterology/GI Surgery, Geriatrics, Nephrology, and Neurology/Neurosurgery, and in the top 50 in six other specialties in the 2018-2019 Best Hospitals issue. Mount Sinai's Kravis Children's Hospital also is ranked nationally in five out of ten pediatric specialties by U.S. News & World Report. The New York Eye and Ear Infirmary of Mount Sinai is ranked 11th nationally for Ophthalmology and 44th for Ear, Nose, and Throat. Mount Sinai Beth Israel, Mount Sinai St. Luke's, Mount Sinai West, and Mount Sinai South Nassau are ranked regionally.

The Mount Sinai Health System is an equal opportunity employer. We promote recognition and respect for individual and cultural differences, and we work to make our employees feel valued and appreciated, whatever their race, gender, background, or sexual orientation.