Advocate Health · 6 hours ago

IT Enterprise Data Architect

Allenton, WI

Full-time

Remote

Mid, Senior Level

7+ years exp

Maximize your interview chances

Health Care

Insider Connection @Advocate Health

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Develops and maintains data schema for the data warehouse and data marts required to support and maintain data, process models, and data marts.

Develops and maintains a data model and dictionary defining the key data elements that will be abstracted from the production systems to support both ad hoc and strategic reporting. Collaborates with data warehouse teams to execute against these designs.

Partners with the information technology database teams to establish agreed data feeds and refresh rates for this data.

In collaboration with information technology security and the Advocate Aurora Health Compliance group, establishes and implements data security and privacy rules for the data warehouse including the use of both identifiable and de-identified patient data.

Provides data modeling support to the data warehouse teams developing additional views and data marts as needed

Provides consulting support to information technology and business staff on the data requirements and quality assurance required to support both internal and external reporting.

Works with the database teams to optimize database performance.

Supports the strategic move to an expanded use of user driven ad hoc query and reporting.

Ensures the implementation of required auditing of access to Personal Health Information and other HIPAA requirements.

Establishes data retention requirements for the data warehouse and implements purge processes to remove expired data.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data warehousingSQLData modelingDatabase designDatabase architectureProject management

Required

Bachelor's Degree (or equivalent knowledge) in Information Technology.

Typically requires 7 years of experience in information technology working as a database administrator or data analyst responsible for large, complex mission critical database environments in a large complex information technology environment.

Proficient in SQL and data warehousing technologies.

Strong knowledge of data modeling and database design.

Detailed technical understanding of database architecture and design as applied to large complex mission critical database environments.

Proven project management experience.

Delivery focused and tenacious.

Ability to work through the challenges associated with large complex projects, with focus on the key project objectives.

Detailed oriented with the ability to handle project complexity and detail.

Ability to identify key elements, and is able to define detailed project work-break-down structures and incorporate them into project plans.

Exceptional analytical, conceptual, and problem-solving abilities.

Strong analytical thinker able to break down complex problems and issues into their key components.

Strong communication skills.

Strong presentation and interpersonal skills.