Team Leader Database - FSM

Job

Location:
Evanston, Illinois

Department: MED Central IT

Salary/Grade: ITS/82

Job Summary: The Team Leader/Research Analytics is a Data Architect who is responsible for the day-to-day management of the research efforts of the Enterprise Data Warehouse. The EDW is a highly integrated, massively-scaled, highly secure centralized database repository containing clinical, financial, operational and regulatory data on over 2 million patients who receive their care from the Northwestern 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 and research.

The position will be responsible for the research arm of the EDW team and will supervise architects and data analysts. The team leader will also supervise the recharge operation of the EDW.

Please note:

This role may include working during off or extended hours.

Specific Responsibilities

Staff Development, Mentoring, and

Coaching:

• Motivate and coach the EDW Research Analytics Staff staff to ensure an appropriate mix of leadership and technical skills is available to meet the EDW 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 EDW role (i.e. architecture, analysts, developers, etc.)
  
  Provide leadership, encouragement, motivation, coaching and mentoring for the development of a strong pool of promo table 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. Work 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 Software Development:

• Make recommendations for purchases and capital equipment. Ensure the EDW and its mission critical services available to all 15k employees on the Northwestern Medicine Campus. Manage the development of all software 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 EDW services. Prepare reports and documentation for EDW Director and EDW leadership.

Leadership:

• Advise EDW director on direction of EDW in terms of Clinical Analytics and Operations. Advise on staff allocation, budgets, and EDW scalability. Perform project management for respective team members to ensure timelines and deliverables are met and meet expectations. Represent the EDW 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 (>10
  
  Tbytes) relational database management systems.

Minimum

Competencies:

(Skills, knowledge, and abilities.)

• Exceptional interpersonal skills, communication skills, and comfortable and confident facilitating team or other group meetings.
• Knowledge of SQL, DML, and DDL programming; underlying server and storage hardware architectures;…