Team Leader Database - FSM

Northwestern University; Evanston (IL); On-site; USD 125,000 - 180,000; Full time

Benefits offered by this job

Health insurance

Dental & vision coverage

Paid vacation & holidays

Tuition benefits

Retirement savings options

Wellness programs

Job summary

Northwestern University in Evanston, IL seeks a Team Leader/Research Analytics to manage the Enterprise Data Warehouse (EDW) research efforts. You will supervise architects and data analysts, oversee recharge operations, and guide data architectures for clinical, financial, and regulatory data.

The role requires a bachelor’s degree in a related field and 5–7 years of data warehousing and healthcare experience, with potential off-hours work as needed.

Qualifications

• Bachelor's degree in computer science or equivalent with several years in senior data roles.
• 5+ years in data warehousing and healthcare delivery/research.
• Experience with large relational databases (>10 TB).

Responsibilities

• Provide staff development, mentoring, and coaching for EDW team.
• Design and maintain enterprise data models and ETL processes for the EDW.
• Oversee quality assurance and system enhancements for reliability and performance.
• Lead software development for EDW, including budgeting and resource planning.
• Engage with departments to present EDW services and prepare documentation.

Skills

SQL / DML / DDL

Data modeling

Leadership & mentoring

Analytics & BI

Enterprise data warehousing

Education

Bachelor's degree in computer science or equivalent

Tools

Microsoft SQL Server

ETL tools

SNOMED/LOINC/ICD knowledge

Job description

Job ID: 54447

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 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. 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 (>10Tbytes) 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; 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.
• 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.

Benefits: At Northwestern, we are proud to provide meaningful and competitive benefits. The available benefits package for this position will include health, dental, vision, disability, and life insurance; paid vacation and holidays; paid medical/sick and parental leave; tuition benefits for the employee and dependents; pre-tax and flex spending accounts for commuting and dependent care; generous retirement savings options; and wellness programs. For a comprehensive overview of available benefits, including eligibility details, visit us at https://www.northwestern.edu/hr/benefits/index.html 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 https://www.northwestern.edu/hr/benefits/work-life/index.html 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 https://www.northwestern.edu/hr/learning/index.html to learn more.

Northwestern University is an Equal Opportunity Employer and does not discriminate on the basis of protected characteristics, including disability and veteran status. View Northwestern's non-discrimination statement. Job applicants who wish to request an accommodation in the application or hiring process should contact the Office of Civil Rights and Title IX Compliance. View additional information on the accommodations process.

Target hiring range for this position will be between $125,220 to $179,515 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.