What are the responsibilities and job description for the IT Enterprise Data Architect position at 581 Advocate Aurora Health, Inc.?
Department:
Status:
Benefits Eligible:
Hours Per Week:
Schedule Details/Additional Information:
Remote Work Position
Responsible for defining the data warehouse, data requirements, and developing and maintaining the database schema, data and process models, and data marts required to support them. Ensures the appropriate use of identifiable and de-identifiable patient data and compliance with data security, privacy and HIPAA requirements. Provides data modeling support to the information technology teams, supports the expanded use of end user ad hoc query and reporting and provides consulting support to information technology and business staff on data requirements and quality assurance for both internal and external reporting.
Major 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.
Licensure, Registration, and/or Certification Required:
- None Required.
Education Required:
- Bachelor's Degree (or equivalent knowledge) in Information Technology.
Experience Required:
- 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.
Knowledge, Skills & Abilities Required:
- 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. Strong influencing skills.
- Self-starter comfortable taking the initiative and making decisions on the best available information.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Experience working in a team-oriented, collaborative environment.
- Ability to both lead and serve on a wide variety of teams comprised of diverse players.
- Natural leader who can adapt their style to match the particular needs of the project and team.
- Excellent presentation and writing skills.
Physical Requirements and Working Conditions:
- Position may require travel which may result in exposure to road and weather hazards.
- Exposed to normal office environment.
- Operates all equipment necessary to perform the job.
#Remote
#LI-Remote
This job description indicates the general nature and level of work expected of the incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the incumbent. Incumbent may be required to perform other related duties.
About Advocate Health
Advocate Health is the third-largest nonprofit, integrated health system in the United States, created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names Advocate Health Care in Illinois; Atrium Health in the Carolinas, Georgia and Alabama; and Aurora Health Care in Wisconsin, Advocate Health is a national leader in clinical innovation, health outcomes, consumer experience and value-based care. Headquartered in Charlotte, North Carolina, Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies, with Wake Forest University School of Medicine serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology, neurosciences, oncology, pediatrics and rehabilitation, as well as organ transplants, burn treatments and specialized musculoskeletal programs. Advocate Health employs 155,000 teammates across 69 hospitals and over 1,000 care locations, and offers one of the nation’s largest graduate medical education programs with over 2,000 residents and fellows across more than 200 programs. Committed to providing equitable care for all, Advocate Health provides more than $6 billion in annual community benefits.
Salary : $6
