Senior Data Architect

NorthShore University HealthSystem - Skokie, IL

Full-time - Senior

Skokie, IL

10,001+ employees

Hospitals

About the position

The Senior Data Architect at NorthShore University HealthSystem is responsible for leading the design and implementation of the Enterprise Data Warehouse (EDW) to support the organization's data needs. This role involves collaborating with stakeholders to translate business requirements into technical designs, creating data models, and ensuring best practices in data warehousing are followed. The position requires a strong understanding of data architecture, data modeling, and experience with various data technologies, particularly in a healthcare context.

Responsibilities

• Interact and lead discussions with stakeholders to understand and document the scope and business requirements.
• Translate business needs into feasible and acceptable data-centric semantic layer designs.
• Create conceptual, logical, and physical data models using frameworks like Kimball and Inmon.
• Drive and document the source to target mapping with ETL developers.
• Design highly performant and secure data structures such as staging areas, data marts, and operational data stores.
• Suggest, document, and enforce data warehousing best practices.
• Estimate and communicate work effort to EDW management and stakeholders, owning deliverables from inception to signoff.
• Review and enhance existing models for compliance with best practices around master data management.
• Act independently under general direction and provide technical consulting on complex projects.
• Suggest improvements to data quality through frameworks and processes.

Requirements

• 4 year college degree in computer science/data processing or equivalent work experience.
• 6+ years supporting and developing software applications.
• 4+ years of experience as a Data Architect or Data Modeler with data warehouse experience.
• Strong dimensional modeling and star schema design skills.
• Ability to translate business needs into technical design.
• 2+ years of experience with any Data Modeling tool (Erwin preferred).
• 1+ years of architecture experience with Microsoft Azure, specifically with data analytics services.
• Subject matter expert in at least three technical areas such as Azure Synapse, Data Factory, or Data pipelines.
• Experience with Informatica PowerCenter is a plus.
• Experience with reporting tools such as Cognos/Tableau is a plus.
• Familiarity with the Healthcare industry is a plus.
• Strong verbal and written communication, presentation, and customer service skills.

Nice-to-haves

• Experience with Epic Clarity and Caboodle databases is a plus.
• Programming skills and the ability to maintain and understand complex applications.

Benefits

• Career Pathways to Promote Professional Growth and Development
• Various Medical, Dental, Pet and Vision options
• Tuition Reimbursement
• Free Parking
• Wellness Program Savings Plan
• Health Savings Account Options
• Retirement Options with Company Match
• Paid Time Off and Holiday Pay
• Community Involvement Opportunities