Lead Data Architect - Enterprise Data Warehouse & Research

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

Benefits offered by this job

Health, dental, vision

Tuition benefits

Retirement plan

Paid time off

Job summary

Northwestern University in Evanston, IL, seeks a Team Leader/Research Analytics Data Architect to manage day-to-day EDW research efforts. You will supervise architects and data analysts and oversee the recharge operations for the EDW, ensuring secure, scalable data delivery to NU's healthcare providers.

The role requires a bachelor’s degree in a related field and 5–7 years of experience in data warehousing and healthcare research.

Qualifications

• Bachelor's degree in computer science or equivalent.
• Five to seven years in a senior database analyst or architect position.
• Minimum of 5 years’ experience in data warehousing and healthcare delivery and research.
• Experience applying project management principles for development or procurement projects.
• Familiar with very large relational database systems (>10Tbytes).

Responsibilities

• Provide analysis/design/training/maintenance of enterprise data models and physical database objects.
• Create ETL code to load and manipulate data in the data warehouse.
• Collaborate with clinical analytics and data management teams to develop analytical tools.
• Oversee system enhancements to improve reliability and performance.
• Manage software development for EDW and ensure services for 15k NU employees.
• Engage departments and institutes with EDW services and prepare reports.
• Advise EDW director on direction, staff allocation, budgets, and scalability.

Skills

SQL

DML

DDL

Data warehousing

Healthcare data

NLP / text analysis

Metadata management

HIPAA / IRB knowledge

SNOMED/LOINC

DICOM

BI tools

Education

Bachelor's degree in Computer Science or equivalent

Tools

Microsoft SQL Server

ETL tools

Job description

Northwestern University in Evanston, IL, seeks a Team Leader/Research Analytics Data Architect to manage day-to-day EDW research efforts. You will supervise architects and data analysts and oversee the recharge operations for the EDW, ensuring secure, scalable data delivery to NU's healthcare providers.

The role requires a bachelor’s degree in a related field and 5–7 years of experience in data warehousing and healthcare research.