Jobs
>
New York City

    Lead Healthcare Data Warehouse Architect - New York, United States - mountsinai

    mountsinai
    mountsinai New York, United States

    1 week ago

    Default job background
    Description

    **Lead Healthcare Data Warehouse Architect - Scientific Computing**

    CAROUSEL_PARAGRAPH

    New York, New York

    Information Technology

    Icahn School of Medicine at Mount Sinai ** Share Job**

    mail_outlineGet future jobs matching this search

    or ** Job Description**

    ***Strength Through Diversity***

    ***Ground breaking science. Advancing medicine. Healing made personal.***

    **Roles & Responsibilities** :

    The Scientific Computing and Data group at the Icahn School of Medicine at Mount Sinai partners with scientists to accelerate scientific discovery. To achieve these aims, we provide a cutting-edge high-performance computing and data ecosystem along with MD/PhD-level support for researchers and clinicians. The group is composed of a high-performance computing team, the research clinical data warehouse team and a research data services team.

    The Lead Healthcare Data Warehouse Architect designs and oversees the implementation and testing of a scalable, high-availability, high-performance data warehouse. The Mount Sinai Data Warehouse (MSDW) contains electronic health record data for over 11 million patients in the Mount Sinai Health System. The 30 terabyte data warehouse is situated in a high-performance computing cluster (>25,000 cores, and 30 petabytes usage storage) and data commons, with the overarching goal of accelerating translational research and improving clinical care. This position enables the maximal sharing of data within Sinai and beyond with NIH-funded national research projects such as N3C and INSIGHT. The MSDW is in the early stages of being linked to images, genomic, EKGs and other research data sets. The incumbent leverages extensive experience and understanding of data warehouse technologies, tools and best practices. This position reports to the Director of Research Data Warehouse in the Scientific Computing group. Specific responsibilities are listed below.

    Designs and oversees the implementation of Mount Sinais research-oriented clinical data warehouse for researchers and clinicians.

    Oversees the ongoing operations, maintenance and upgrades for data pipelines and ETL jobs for the integration of data from the Epic Caboodle into an Observational Medical Outcomes Partnership (OMOP) common data model database.

    Ensures that MSDW data is provided to on-premise self-service query tools such as Leaf, ATLAS, TriNetX, MS Power BI, and to national research projects such as INSIGHT and N3C.

    Maintains the confidentiality, privacy, and integrity of all healthcare data. Comply with all applicable laws, policies, and procedures, including those of the Institutional Review Board (IRB), Compliance, HIPAA and New York State laws, and IT Security.

    Develops the standards, automated procedures and documentation for database and ETL design, including management, monitoring, upgrades, quality control and quality assurance and maintenance. Conduct peer code reviews. Creates documentation.

    Establishes the strategy for optimized database performance stored procedures, ETL jobs, and related scripts in coordination with the DBA.

    Serves as technical mentor to team members. Acts as a technical project leader. Work effectively with others Mount Sinai and beyond.

    Performs related duties as assigned or requested.

    ***Requirements:***

    Bachelor degree in Computer Science or a related discipline

    Eight years minimum experience in the design and administration of relational databases and ETL processes in diverse technological environments.

    Knowledge and experience of ETL development best practices: explicit source-to-target mappings; pattern-based and parameter-driven development; and rigorous version control. Strong knowledge of relational and dimensional data modeling principles and best practices. Experience with Microsoft SSIS, Visual Studio.

    Knowledge of database administration experience: database design and configuration; DDL and DML performance tuning using indexes, partitioning, materialized views, and other methods for improving query performance.

    Strong SQL development skills: stored procedures, functions, triggers, sequences, queries with advanced SQL. Microsoft T-SQL experience is required; hands-on experience with Oracle PL/SQL and/or PostgreSQL PL/pgSQL is a strong plus.Experience working with healthcare data (electronic health records, medical and pharmacy claims, healthcare cost accounting systems). Experience with Epic Systems Corporations Clarity and Caboodle reporting databases is strongly preferred.

    Excellent critical thinking, problem-solving, multi-tasking, and collaboration skills.

    Strong communication skills (verbal and written) to effectively interact with researchers, clinicians, hospital administrators, and other IT personnel.

    Microsoft SQL Server Reporting Services (SSRS), Power BI, and/or Tableau is a plus.

    **Strength Through Diversity**

    The Mount Sinai Health System believes that diversity is a driver for excellence. We share a common devotion to delivering exceptional patient care. Yet were as diverse as the city we call home- culturally, ethically, in outlook and lifestyle. When you join us, you become a part of Mount Sinais unrivaled record of achievement, education and advancement as we revolutionize medicine together.

    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 story

    **Who We Are**

    Over 38,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, Mount Sinai Morningside, and New York Eye and Ear Infirmary of Mount Sinai.

    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.

    **EOE Minorities/Women/Disabled/Veterans**

  • TribolaTech Inc

    Data Warehouse Architect

    1 day ago

    TribolaTech Inc New York, United States

    Minimum Qualifications: · 15+ years of BI/DW and data architecture experience. · 10+ years' experience in data warehousing · Experience of Cloud implementations on Azure · Knowledge of Data Warehousing, Analytics, ETL and BI architectures, concepts and frameworks · Capable of fac ...

  • mountsinai

    Lead Data Warehouse Architect

    2 weeks ago

    mountsinai New York, United States

    **Lead Data Warehouse Architect - Scientific Computing** · CAROUSEL_PARAGRAPH · New York, New York · Information Technology · Icahn School of Medicine at Mount Sinai ** Share Job** · mail_outlineGet future jobs matching this search · or ** Job Description** · ***Strength T ...

  • Pros2Plan, a division of Spinnaker SCA

    Blue Yonder Warehouse Management Implementation Architect

    2 weeks ago

    Pros2Plan, a division of Spinnaker SCA New York, United States

    SpinnakerSCA has an immediate opening for a Blue Yonder Warehouse Management Implementation Architect · Duration: Full-Time · Location: US, with travel potential · Responsibilities: · Serve as our technical expert and provide high level support to a project team during the techn ...

  • Epsilon Solutions

    Technical Advisor with Gcp and Data Center

    1 day ago

    Epsilon Solutions New York, United States

    **Job Role: Technical Advisor With GCP** · **Location: New York, NY** · **Duration: Long Term Contract** · **Qualifications**: · - **Bachelor's degree in Computer Science, Engineering, or related field.**: · - **Experience in Infrastructure, Data Center Migration Onprem To cloud ...

  • Alger

    Information Research Scientist

    1 week ago

    Alger New York, United States

    **Job Title**:Information Research Scientist · **Location**: New York, New York · **Reporting To**:VP, Senior Solutions Architect · **Duties and Responsibilities**: · - Consulting with stakeholders to determine needs/weaknesses · - Designing experiments to test and improve system ...

  • Underwriting Solutions

    Property & Casualty Insurance - Data Scientist

    4 days ago

    Underwriting Solutions Jersey City, United States

    **Company Description** · We help the world see new possibilities and inspire change for better tomorrows. Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable. · The Analytical Data Oper ...

  • UOVO

    Art Handler

    1 week ago

    UOVO Brooklyn, United States

    **Description**: · **ABOUT UOVO** · Are you ready to embark on a journey where your passion for art, fashion, culture, and excellence converge? Welcome to UOVO—the epitome of sophistication in storage, management, and logistics of valuable art, fashion, and wine. We invite all vo ...

  • Signs and Decal

    Shop Cleaner

    1 day ago

    Signs and Decal Brooklyn, United States

    **We are looking SHOP MAINTENANCE (CLEANER) / SHOP HELPERS who have experience in metal work - minimum 3 years in a similar position** · - CLEANING OF SHOP - TAKING OUT TRASH / CLEANING BATHROOMS · - USING FORKLIFT TO OFFLOAD MATERIALS & ORGANIZE · - DRIVING WILL BE NEEDED OCCASI ...

  • Trade Supply Group

    Warehouse Associate

    1 week ago

    Trade Supply Group Long Island City, United States

    **Manhattan Laminates** is one of the largest distributors of woodworking supplies in the New York metro area. Conveniently located showrooms and warehouses in Queens and Long Island, offering a huge selection of quality laminates, adhesives, hardware, coatings, and woodworking a ...

  • SCHNELLER INC

    Inventory Associate

    3 days ago

    SCHNELLER INC Long Island City, United States

    **Benefits**: · - 401(k) · - Competitive salary · - Dental insurance · - Health insurance · - Opportunity for advancement · - Paid time off · - Parental leave · - Vision insurance · **SCHNELLER COMPANY DESCRIPTION** · As a 140-year-old high-end custom furniture and curtain workro ...

  • UOVO

    Art Handler/driver

    1 week ago

    UOVO Long Island City, United States

    **Description**: · **ABOUT UOVO** · Are you ready to embark on a journey where your passion for art, fashion, culture, and excellence converge? Welcome to UOVO—the epitome of sophistication in storage, management, and logistics of valuable art, fashion, and wine. We invite all vo ...

  • Volazi LLC

    Delivery Coordinator

    4 days ago

    Volazi LLC Queens, United States

    Show your skills in the field of delivery at Volazi LLC · Are you fascinated by the intricacies of logistics? Are you experiencing an adrenaline rush organizing uninterrupted deliveries? · If you are ready to rethink coordination as an art form, Volazi LLC invites you · **Who Are ...

  • Whitehall Resources

    SAP EWM Architect

    2 weeks ago

    Whitehall Resources New York, United States

    SAP EWM Architect · An exciting SAP opportunity has arisen for an SAP EWM Architect to join our client, a globally recognised end user organisation. · As the SAP EWM Architect you will be responsible for the design, implementation, delivery and support of the SAP solutions whic ...

  • Pierce Technology Corporation

    Solutions Data Architect

    4 days ago

    Pierce Technology Corporation New York, United States

    Solutions/data architect who understands data, can create a data model and design a new solution for an enterprise data warehouse. · Legacy system is limited in documentation, no real data model or map, and no user interface. Internal clients are looking for easier, better, and ...

  • C4 Technical Services

    D365 Functional Data Architect

    4 days ago

    C4 Technical Services New York, United States

    D365 Functional Data Architect · Location: Remote (up to 25% travel) · Job Description · The Functional Dara Architect will work closely with the Data Migration and Technical Teams supporting the design and implementing the data strategy as needed by the Reliable organization ac ...

  • identifi Global Resources

    Application Engineer

    3 days ago

    identifi Global Resources New York, United States

    Applications Engineer (Warehouse Automation / Intralogistics) up to $85,000 + Benefits - Michigan US (Hybrid working) · About the role: · Market leading provider of Intralogistics / Warehouse Automation solutions with a global presence now seeks to recruit experienced Applicatio ...

  • Stellar Consulting Solutions, LLC

    Informatica Developer/Admin

    1 week ago

    Stellar Consulting Solutions, LLC New York, United States

    ROLE LOCATION(S) - Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS. · ROLE RESPONSIBILITIES · Develop new ...

  • Publicis Sapient

    Snowflake Data Architect

    1 week ago

    Publicis Sapient New York, United States

    Job Description · Data Architect, Manager · Publicis Sapient is seeking a skilled Cloud Architect to join our team. In this role, you will play a hands-on part in driving the architecture, design, and implementation of Snowflake for our clients. Additionally, you will utilize you ...

  • Tata Consultancy Services

    Enterprise Architect

    2 weeks ago

    Tata Consultancy Services New York, United States

    Job Description: · Our Enterprise Architect role is remote and open in our nearest hubs (New York/ New Jersey, Dallas, Charlotte, Chicago). · This role will augment TCS BFSI Technology Advisory Group consulting and architecture team. You will lead architecture team for Complex ...

  • Alvarez & Marsal

    Senior Data Architect

    1 week ago

    Alvarez & Marsal New York, United States

    Alvarez & Marsal is looking to hire a Data Architect to join our corporate IT team. You will help us expand and design our internal data warehouse and business intelligence function in support of over 18 different business lines. You will design, build, and enhance within our SQL ...