Jobs
>
Chicago

    Team Leader Database - Chicago, United States - Northwestern University

    Northwestern University
    Northwestern University Chicago, United States

    2 weeks ago

    Default job background
    Description

    Department:
    MED-Central IT


    Salary/Grade:
    ITS/83


    Job Summary:


    The Team Leader/Research Analytics is a Data Engineer/Data Scientist who is responsible for the day-to-day management of the research efforts of the Northwestern Medicine Enterprise Data Warehouse Research Analytics team.

    The NMEDW is a highly integrated, massively-scaled, highly secure centralized database repository containing clinical, financial, operational and regulatory data on over 10 million patients who receive their care from the Northwestern Medicine family of healthcare providers.

    The person in this role should have a thorough understanding of research processes, hospital data systems, reporting, and infrastructure.

    The position requires a bachelor's degree in a related field and five to seven years of experience, with at least 5 years of experience in data warehousing and healthcare delivery, research and advanced analytics.


    This position will be responsible for the research arm of the NMEDW team and will supervise data scientists, data analysts and data engineers.

    The team leader will also supervise the recharge operation of the NMEDW and percent effort allocations.

    Please Note:
    This role may include working during off or extended hours.


    Specific Responsibilities:

    Staff Development, Mentoring, and Coaching:

    • Motivate and coach the NMEDW Research Analytics Staff to ensure an appropriate mix of leadership and technical skills is available to meet the NMEDW needs. Ensure effective deployment of skills and other resources are being utilized to enhance agility, flexibility, and cost effectiveness in response to NU and clinical research needs. Define and promote best practices and standards for each NMEDW role (i.e. architecture, analysts, developers, etc.) Provide leadership, encouragement, motivation, coaching and mentoring for the development of a strong pool of promotable and internally mobile team members with high functional capabilities.

    Information Architecture:

    • Provide analysis, design, training, maintenance, tuning, documentation, and implementation of enterprise class logical data models and physical database objects. Create maintainable, scalable "Extract, Transform, and Load" (ETL) code to load and manipulate data in the data warehouse. Has experience working within cloud environments and has implemented or utilized ML/AI related solutions. Works collaboratively with clinical program analytical and data management teams to develop analytical tools to manage/measure care processes, models, and clinical guidelines.

    Quality Assurance:

    • Oversees system enhancements that will improve the reliability and performance of the system. Ensure design reviews are completed for all new development.

    Oversee Advanced Analytics Development:

    • Make recommendations for purchases and capital equipment. Ensure the Research Analytics team has the software and tooling needed for advanced analytic functions such as ML/AI and NLP. Manage the development of all data science solutions for EDW in response to the needs of the campus.

    Customer Service:

    • Engage new and existing customers (Departments, Centers, and Institutes) to ensure needs are met. Prepare and deliver presentations, educational sessions, and workshops related to NMEDW Research Analytics services. Prepare reports and documentation for NMEDW Research Analytics Director and FSM-IT leadership.

    Leadership:

    • Advise NMEDW Research Analytics Director on direction of NMEDW in terms of Clinical Analytics and Operations. Advise on staff allocation, budgets, and NMEDW scalability. Perform project management for respective team members to ensure timelines and deliverables are met and meet expectations. Represent the NMEDW to senior leadership around campus. Works together with campus leadership to meet the complex delivery schedule inherit to a matrixed organization.
    Miscellaneous

    Performs other duties as assigned.


    Minimum Qualifications:

    • A Bachelor's degree in computer science or equivalent with five to seven years in a senior database analyst or architect position, or the equivalent combination of education, training, and experience from which comparable skills and abilities may be acquired.
    • Minimum of 5 years' experience in data warehousing or hands-on, sophisticated data analysis.
    • Minimum of 5 years' experience in healthcare delivery and research.
    • Understanding and experience in applying project management principles and best practices for development or procurement projects.
    • Familiar with the design and operation of very large (>10Tbytes) relational database management systems.
    • Experience with CloudOps solutions and API management and coordination.

    Minimum Competencies:
    (Skills, knowledge, and abilities.)


    • Exceptional interpersonal skills, communication skills, and comfortable and confident facilitating team or other group meetings.
    • Knowledge of Python, SQL, DML, and DDL programming; underlying server and storage hardware architectures; statistical data analysis; software programming as it relates to database access and manipulation; role-based access control; database indexing strategies; system performance monitoring, metrics, and trend analysis; metadata management; controlled medical vocabularies such as SNOMED, LOINC, ICD, CPT, NDC, and DICOM; HIPAA and IRB issues related to data management; natural language processing and text analysis; and quantitative and qualitative data analysis.
    • Possess a thorough understanding of: Business Intelligence/ query and reporting tools and technologies, Structured Query Language (SQL), Procedural programming fundamentals.

    Preferred Qualifications:

    • Experience with Healthcare Data Warehousing.
    • Experience with Microsoft SQL Server/Microsoft Azure.
    • Possess knowledge of quality improvement principles, theory, study design and statistical modeling/analysis.
    • Possess an understanding of healthcare delivery and its associated administrative processes.
    • Experience with current Extraction Transformation and Loading (ETL) tools and technologies.
    Target hiring range for this position will be between $121,573 -$170,962 per year.

    Offered salary will be determined by the applicant's education, experience, knowledge, skills and abilities, as well as internal equity and alignment with market data.


    Benefits:


    At Northwestern, we are proud to provide meaningful, competitive, high-quality health care plans, retirement benefits, tuition discounts and more Visit us at to learn more.


    Work-Life and Wellness:


    Northwestern offers comprehensive programs and services to help you and your family navigate life's challenges and opportunities, and adopt and maintain healthy lifestyles.


    We support flexible work arrangements where possible and programs to help you locate and pay for quality, affordable childcare and senior/adult care.

    Visit us at to learn more.


    Professional Growth & Development:
    Northwestern supports employee career development in all circumstances whether your workspace is on campus or at home.

    If you're interested in developing your professional potential or continuing your formal education, we offer a variety of tools and resources.

    Visit us at to learn more.


    Northwestern strongly recommends COVID-19 vaccinations and boosters for people who can obtain them as a critical tool for minimizing severe illness.

    More information can be found on the COVID-19 and Campus Updates webpage.


    The Northwestern campus sits on the traditional homelands of the people of the Council of Three Fires, the Ojibwe, Potawatomi, and Odawa as well as the Menominee, Miami and Ho-Chunk nations.

    We acknowledge and honor the original people of the land upon which Northwestern University stands, and the Native people who remain on this land today.

    Northwestern University is an Equal Opportunity, Affirmative Action Employer of all protected classes, including veterans and individuals with disabilities. Women, racial and ethnic minorities, individuals with disabilities, and veterans are encouraged to apply. Click for information on EEO is the Law.

    #LI-ER1
  • Na Oiwi Kane

    Database Administrator

    1 week ago

    Na Oiwi Kane Chicago, United States

    **JOB DESCRIPTION** · **Position Title**:Database Administrator · **Location**:80% Remote, 20% Chicago, IL · **Introduction**: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board ( ...

  • Alliance Physical Therapy Partners

    Fitness & Wellness Specialist- Work-fit

    2 weeks ago

    Alliance Physical Therapy Partners Chicago, United States

    **Status: Full-time** · **Shift: Monday-Thursday 4-10 Schedule · - 6am-4pm** · **Location: Chicago, IL** · **Position Description**:A Work-Fit Fitness & Wellness Specialist is responsible for supporting current Work-Fit customers to exceed customer expectations by collaborating o ...

  • SEIU LOCAL 73

    Field Organizer

    1 week ago

    SEIU LOCAL 73 Chicago, United States

    Based in Chicago Illinois · Are you looking for a job with a growing, fighting, diverse and dynamic, member driven union? If so, a · career with SEIU Local 73 may be for you · **ABOUT SEIU Local 73**: · With nearly 30,000 members, SEIU Local 73 has a proud history of raising stan ...

  • Southside Together Organizing for Power

    Housing Organizer

    2 weeks ago

    Southside Together Organizing for Power Chicago, United States

    Southside Together Organizing for Power is a community organization that builds the power of low-income and working Black residents in Woodlawn, Greater Grand Crossing and surrounding neighborhoods on the south side of Chicago to impact the decisions and forces that affect our li ...

  • Northern Trust Corp.

    Principal, Arch Solutions

    1 week ago

    Northern Trust Corp. Chicago, United States

    About Northern Trust: · Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889. · Northern Trust is proud to provide innovative financial services and guidance to the world's most succe ...

  • USI Holdings Corporation

    Benefits Administrator

    2 weeks ago

    USI Holdings Corporation Chicago, United States

    **General Description**: Provide administrative support to Team Leaders and service team. Ensure new business, renewals, and broker of record letters meet the requirements of the writing carrier. Act as a liaison between the insurance carrier and internal staff. · **Responsibilit ...

  • Start Early

    Associate, Individual Giving

    1 day ago

    Start Early Chicago, United States

    Start Early (formerly known as the Ounce) is an energized, future-focused organization devoted to providing quality early learning and care across the country. · Our desire to close the opportunity gap and build more equitable early learning experiences for our youngest learners ...

  • ARCHDIOCESE OF CHICAGO

    Child and Family Ministry Support Coordinator

    6 days ago

    ARCHDIOCESE OF CHICAGO Chicago, United States

    The Archdiocese of Chicago, the third largest in the United States, serves more than 2.2 million Catholics in 216 parishes in Cook County and Lake County, a geographic area of 1,411 square miles. The Archdiocese, pastored by Cardinal Blase J. Cupich, has more than 13,000 employee ...

  • Gateway Foundation Inc

    Development/ Fundraising Associate

    6 days ago

    Gateway Foundation Inc Chicago, United States

    Are you looking to find personal and professional fulfillment, and align your career with your values? · At Gateway Foundation, our employees have an opportunity to make a difference every day by helping people with substance abuse issues gain control of their lives. · Gateway Fo ...

  • United Way

    Fundraising Ambassador

    6 days ago

    United Way Chicago, United States

    POSITION: Fundraising** **Ambassador (Temporary) · DEPARTMENT: Human Resources · REPORTS TO: Director, Training and Development · STATUS: Temporary (July 16 - Nov 26), 30-35 hours/week, hybrid position · PAY RATE: $20.00/hour · **ABOUT UNITED WAY OF METRO CHICAGO** · United Way o ...

  • EFC International

    Customer Service Representative

    2 weeks ago

    EFC International Chicago, United States

    **Company Overview**: EFC International is a globally recognized leader in providing engineered fastener solutions and industrial components to a wide range of industries. With over four decades of experience, we have established ourselves as a trusted partner for businesses seek ...

  • Northwestern Memorial Healthcare

    Education Coordinator-allergy Full Time Days

    5 days ago

    Northwestern Memorial Healthcare Chicago, United States Full time

    **Company Description** · At Northwestern Medicine, every patient interaction makes a difference in cultivating a positive workplace. This patient-first approach is what sets us apart as a leader in the healthcare industry. As an integral part of our team, you'll have the opportu ...

  • Civitas Education Partners

    Director of Human Resources

    2 days ago

    Civitas Education Partners Chicago, United States

    Director of Human Resources · **Reports To**: Chief Operating Officer (COO) · **Overview** · As a leading education management organization, Civitas Education Partners is committed to transforming the lives of students in culturally and linguistically diverse communities by provi ...

  • State Farm Mutual Automobile Insurance Company

    Litigation Paralegal

    4 days ago

    State Farm Mutual Automobile Insurance Company Chicago, United States

    Bloomington, Illinois; Chicago, Illinois · - Legal, Compliance, and Risk Management · - Regular Full Time · - 37274 · **Job Description**: · **Overview** · We are not just offering a job but a meaningful career Come join our passionate team · As a Fortune 50 company, we hire the ...

  • HUB International

    Director, Data Engineering

    1 day ago

    HUB International Chicago, United States

    Join a Winning Team at HUB International · When you join the team at HUB International, you become part of the 5th largest global insurance broker, providing a broad array of property, casualty, risk management, life and health, employee benefits, investment and wealth management ...

  • Super Micro Computer

    Service Logistics Specialist

    2 weeks ago

    Super Micro Computer Chicago, United States

    Service Logistics Specialist · **Date**:May 6, 2024 · **Location**: Chicago, Illinois, United States · **Company**:Super Micro Computer · **Job Req ID: 24447** · **About Supermicro**: · - Supermicro is a Top Tier provider of advanced server, storage, and networking solutions for ...

  • Northwestern Memorial Healthcare

    Data Integrity Coordinator

    5 days ago

    Northwestern Memorial Healthcare Chicago, United States

    **Company Description** · At Northwestern Medicine, every patient interaction makes a difference in cultivating a positive workplace. This patient-first approach is what sets us apart as a leader in the healthcare industry. As an integral part of our team, you'll have the opportu ...

  • Spencer Stuart

    Analyst, Industrial

    1 week ago

    Spencer Stuart Chicago, United States

    Spencer Stuart seeks to recruit an Analyst for our Industrial Practice. This Analyst will be based in New York City, Washington DC, or Chicago. Analysts play a critical and visible role on the team. Working closely with Associates, Senior Associates, and Consultants, Analysts ope ...

  • GardaWorld Security Security Services US

    Regional Sales Executive

    6 days ago

    GardaWorld Security Security Services US Chicago, United States

    **Regional Sales Executive - Mid West** · Compensation: $65,000 - $75,000 base + car allowance + unlimited tiered commission · **ECAM summary**: · - ECAM SECURE (a GardaWorld Company) is the pioneer and industry leader in the manufacture of outdoor video surveillance equipment an ...

  • Abbott Laboratories

    Manager, Logistics

    2 weeks ago

    Abbott Laboratories North Chicago, United States

    Abbott is a global healthcare leader that helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and products in diagnostics, medical devices, nutritionals and branded generic medic ...