Bus Intelligence Architect
Job ID:
R144514
Shift:
Various
Full/Part Time:
Full_time
Pay Range:
$62.15 – $93.25
Location:
Oak Brook Support Center – 2025 Windsor Dr
Oak Brook, IL 60523
Benefits Eligible:
Yes
Hours Per Week:
40
Our Commitment to You:
Advocate Health offers a comprehensive suite of Total Rewards: benefits and well-being programs, competitive compensation, generous retirement offerings, programs that invest in your career development and so much more – so you can live fully at and away from work, including:
Compensation
- Base compensation within the position’s pay range based on factors such as qualifications, skills, relevant experience, and/or training
- Premium pay such as shift, on call, and more based on a teammate’s job
- Incentive pay for select positions
- Opportunity for annual increases based on performance
Benefits and more
- Paid Time Off programs
- Health and welfare benefits such as medical, dental, vision, life, and Short- and Long-Term Disability
- Flexible Spending Accounts for eligible health care and dependent care expenses
- Family benefits such as adoption assistance and paid parental leave
- Defined contribution retirement plans with employer match and other financial wellness programs
- Educational Assistance Program
Schedule Details/Additional Information:
N/A
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 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.
MINIMUM EDUCATION AND EXPERIENCE REQUIRED
Level of Education: Bachelor's degree in information technology or related field.
Years of Experience: 7 years 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.
MINIMUM KNOWLEDGE, SKILLS AND ABILITIES (KSA)
- 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 can define detailed project work-break-down structures and incorporate them into project plans.
- Exceptional analytical, conceptual, and problem-solving abilities. Excellent presentation and writing skills.
- 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.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Natural leader who can adapt their style to match the needs of the project and team. Ability to both lead and serve on a wide variety of teams comprised of diverse players.
PHYSICAL REQUIREMENTS AND WORKING CONDITIONS
- This position requires travel, therefore, will be exposed to weather and road conditions.
- Operates all equipment necessary to perform the job.
- Exposed to a normal office environment.
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
Information Technology at Advocate Aurora
Advocate Health Care is the largest health system in Illinois and a national leader in clinical innovation, health outcomes, consumer experience and value-based care. One of the state’s largest private employers, the system serves patients across 11 hospital locations, including two children’s campuses, and more than 250 sites of care. Advocate Health Care, in addition to Aurora Health Care in Wisconsin and Atrium Health in the Carolinas, Georgia and Alabama, is now a part of Advocate Health, the third-largest nonprofit, integrated health system in the United States. Committed to providing equitable care for all, Advocate Health provides nearly $5 billion in annual community benefits.
