Skip to main content

Data Architect - Enterprise Data Warehouse, Full-time, Days

Northwestern Medicine
Occupational fields: 
Employment type: 
Full time
Required degree level: 
Remote Position: 

The Data Architect is responsible for delivering data warehouse and business intelligence solutions by building data models, writing ETL processes and administering systems to facilitate business intelligence tools. This individual works closely with end users and IT development staff to ensure that new and existing data models and databases are consistent with approved data architecture standards. The Data Architect must have expert level knowledge and experience in data modeling and database design.


  • Interviews end-users to understand information needs and develops conceptual and logical data models to support building of the data warehouse and delivery of business intelligence solutions.
  • Assists with ETL design and development including data analysis, source-target mapping, quality profiling, change data capture, program performance.
  • Assists with the design and development of information delivery components including dashboards, reports, and OLAP cubes.
  • Documents all programming changes and design, system modifications and their associated maintenance to all required applications.
  • Reviews, analyzes and modifies programming systems including coding, testing, debugging and installing to support business intelligence applications. Supports or leads installation and integration of software applications. Provides ongoing support and maintenance for programming systems as needed.
  • Works with end-users to ensure business intelligence solutions meet expectations and provide training and support.
  • Communicates effectively with end users, at all levels of the organization. Supports system installations and integration; interacts effectively with vendors and other technical specialists.
  • Collaborates with Business Intelligence members, technical services, Help Desk and other IS/Analytics team members to implement systems solutions.
  • Maintains knowledge of current trends and development in the field. Actively explores emerging technologies.
  • Performs other duties and functions as assigned.

EOE including Disabled and Veterans.

Northwestern Medicine is dedicated to providing the most advanced healthcare to the communities and patients we serve. The Northwestern Medicine clinical and administrative staff, medical and science faculty and medical students come together everyday with a shared commitment to superior quality, academic excellence, scientific discovery and patient safety.

Click the link find out more about Northwestern Medicine