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

Information Technology
0050698 Requisition #
Share this Job

The Business Intelligence 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 Business Intelligence 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.

 Required Qualifications:
  • A minimum of 5 years of experience, including 3 years of healthcare analytics experience.
  • Bachelor's Degree in Healthcare Management, Engineering, Statistics, Computer Science, or Business.
  • Minimum of 3 years IT experience in business intelligence development across a variety of applications (OLTP, OLAP and DSS).
  • Minimum of 3 years of experience developing, designing and supporting relational databases (i.e. SQL Server).
  • Minimum of 3 years of experience with report writing and data visualization tools such as:  Tableau, Crystal Reports, Xcelsius, SSRS, etc.
  • Minimum of 3 years of experience in all areas of software development including analysis, design, development and support with particular emphasis on structured programming. 
  • Knowledge of web services and tools in a Windows environment.
  • Strong relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures. 
  • Understanding of data warehouse and business intelligence design principles and industry practices including relational and dimensional modeling, OLAP, ETL methods and data visualization. 
  • Experience working with a variety of data warehousing models and design fundamentals (i.e. Kimball, Inman)
Preferred Qualifications:
  • Master Degree in Information Management, Healthcare Informatics, Computer Science, Business Administration, Statistics or related field.
  • Working knowledge of SqlServer DBMS, SSIS, SSAS and XML data sources.
  • Experience developing data warehouses in a Healthcare environment

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions
Please try again.


Either there was a problem on our end with the action you just performed, or we are currently having technical difficulties with our system. Please try again later.

Connect with NM on Social Media

Northwestern Medicine is an affirmative action/equal opportunity employer and does not discriminate in hiring or employment on the basis of age, sex, race, color, religion, national origin, gender identity, veteran status, disability or sexual orientation.

Access to NMHC resources through this system is subject to the terms of the NORTHWESTERN MEMORIAL HEALTHCARE INFORMATION ACCESS AND CONFIDENTIALITY AGREEMENT. This system may be accessed and used by authorized personnel only. Authorized users may only perform authorized activities and may not exceed the limits of such authorization. Disclosure of information found in this system for any unauthorized use is strictly prohibited. All activities on this system are subject to monitoring.