VCN Healthcare Jobs

Virtual Career Network Healthcare mobile logo

Job Information

The Mount Sinai Health System Healthcare SQL Analyst - Scientific Computing in New York, New York

Strength Through Diversity

Ground breaking science. Advancing medicine. Healing made personal.

Roles & Responsibilities:

The Healthcare SQL Analyst will collaborate with clinical informaticists and researchers to define and develop appropriate solutions for various reporting needs.

These solutions typically involve extracting data from Mount Sinai’s various relational databases, data cleansing, and reformatting into analytic data sets. Solutions may also involve the design, testing, implementation, and ongoing maintenance of data marts.

Primary Duties

  • Assist with translating end-user data requests into technical specifications and specific data elements required for data set, report, or data mart development.

  • Assist with requirements elicitation for new reporting and data requests by interacting with end users.

  • SQL programming, testing, and performance tuning to fulfill data requests.

  • Manage and version control SQL scripts for re-usability.

  • Develop custom ETL jobs and/or packages to extract data from various sources and load them into the Mount Sinai Data Warehouse or data marts.

  • Design and develop custom database schemas within the Data Warehouse, as needed.

  • Test reports and data extracts, and perform volume testing in live environments. Ensure that customers are satisfied with data provided to them.

  • Monitor ETL executions and data-load processes as part of routine Data Warehousing operations. Troubleshoot and resolve ETL job failures. On-call support is sometimes required.

  • Design, implement, test, deploy, and manage data marts that align with the Data Warehouse architecture and enterprise data strategy.

  • Perform related duties as assigned or requested.

Requirements:

Bachelor degree in Computer Science or a related discipline; advanced degree preferred.

  • Minimum of 5 years’ experience working with electronic health record (EHR) and/or healthcare claims data; experience with Epic’s Clarity & Caboodle databases is strongly preferred.

  • Prior experience working with healthcare terminologies and code sets (e.g., ICD-10, RxNorm, LOINC, CPT), and building or using value sets for specific reporting use cases.

  • Ability to articulate technical and organizational approaches to meeting clinical data needs.

  • Team player with experience leading and collaborating cross-team to ensure successful delivery of solutions.

  • Fast learner with the ability to work both independently and in a team environment.

  • Highly proficient with SQL programming, and professional experience with multiple SQL dialects (e.g., Microsoft Transact-SQL, Oracle PL/SQL, PostgreSQL PL/pgSQL). Ability to write complex SQL queries, scripts, and stored procedures.

  • Ability to assess query performance (e.g., query execution plans) and recommend improvements (e.g., query refactoring, indexing, table partitioning).

  • Experience with Microsoft SQL Server. Experience with other relational databases (Oracle, PostgreSQL) is a strong plus.

  • Strong understanding of the principles of relational and dimensional data modeling.

  • Experience with software development best practices, including all phases of the Software Development Life Cycle (SDLC) and rigorous code version control with tools like Git or SVN.

  • Prior experience working in a research environment and/or knowledge of research Common Data Models (e.g., OMOP, i2b2, PCORnet, ACT) is a plus; experience with the OMOP Common Data Model is strongly preferred.

Strength Through Diversity

The Mount Sinai Health System believes that diversity, equity and inclusion are drivers for excellence. We share a common devotion to delivering exceptional patient care. Yet we’re as diverse as the city we call home- culturally, ethically, in outlook and lifestyle. When you join us, you become a part of Mount Sinai’s unrivaled record of achievement, education, and advancement as we revolutionize medicine together and participate actively as a leader within the Mount Sinai Health System by:

  • Serving as the primary resource management representative of the Mount Sinai leadership teams, committees, etc., and acting as the primary executive leader interface between Mount Sinai and key executives from the health systems’ vendors and partners.

  • Engaging with relevant thought leaders and policy-makers at the federal and state levels, and representing the Health System as assigned.

  • Using a lens of equity in all aspects of patient care delivery, education, and research to promote policies and practices to allow opportunities for all to thrive and reach their potential.

  • Serving as a role model confronting racist, sexist, or other inappropriate actions by speaking up, challenging exclusionary organizational practices, and standing side-by-side in support of colleagues who experience discrimination.

  • Inspiring and fostering an environment of anti-racist behaviors among and between departments and co-workers.

We work hard to acquire and retain the best people, and to create a welcoming, nurturing work environment where you can develop professionally. We share the belief that all employees, regardless of job title or expertise, can make an impact on quality patient care.

Explore more about this opportunity and how you can help us write a new chapter in our history!

Who We Are

Over 42,000 employees strong, the mission of the Mount Sinai Health System is to provide compassionate patient care with seamless coordination and to advance medicine through unrivaled education, research, and outreach in the many diverse communities we serve.

Formed in September 2013, The Mount Sinai Health System combines the excellence of the Icahn School of Medicine at Mount Sinai with seven premier hospital campuses, including Mount Sinai Beth Israel, Mount Sinai Beth Israel Brooklyn, The Mount Sinai Hospital, Mount Sinai Queens, Mount Sinai West (formerly Mount Sinai Roosevelt), Mount Sinai Morningside (formerly Mount Sinai St. Luke’s), and New York Eye and Ear Infirmary of Mount Sinai.

The Mount Sinai Health System (MSHS) provides equal employment opportunity to all its employees and applicants for employment without unlawful discrimination on the basis of their actual or perceived race, creed, color, religion, national origin, sex, gender, gender expression, gender identity, age, disability, marital or parental status, sexual orientation, veteran, immigration, citizenship, or other protected status.

EOE including Veterans and Disabled

DirectEmployers