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 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