Job Summary
This position specifically supports the IT Data and Analytics team with a focus on ETL design and data warehousing. Knowledge of core business intelligence/data warehousing technologies including Microsoft SQL Server Integration Services, database administration.
Under general direction, the Data Administrator II is responsible for the support, analysis, design, configuration, implementation, and workflow documentation of the Enterprise Data Warehouse and/or Epic’s Data Warehouse/Analytics suite, in alignment with organization’s policies, procedures, and business operations.
Readily displays the ability to diagnose issues, identify appropriate resources and escalations, and propose creative solutions to complex problems.
Understands the functions and processes of key customer departments and can coordinate and communicate effectively with a variety of stakeholder groups.
Works with the objective of delivering elegant solutions that are intuitive, empowering, efficient, scalable, sustainable, systems focused, and foundation based.
Uses analytics to drive workflow changes and process decisions. Develops measurements and tools for monitoring value and success of system changes. Facilitates a handoff of monitoring value and success to operations. We strive to maintain a 90% Epic enhancement adoption rate.
Responsibilities
General
*Plans and organizes time effectively.
*Meet with end users to gather requirements and understand their workflow for data needs.
*Using Microsoft DevOps GIT to manage code base.
*Perform root cause analysis of ETL issues and present to senior level administrators
*Create/maintain SQL Server stored procedures, views, functions with performance and efficiency in mind.
*Create and maintain documentation for existing and new ETLs and standard work processes
*Extend existing Caboodle data models using Clarity/Epic EMR data.
*Integrate 3rd party, non-Epic data, into existing or new Caboodle data models
*Manage and maintain Servers keeping them up to date and patched.
*Troubleshoot hardware and software performance issues by reviewing server and application event logs
*Review upgrade documentation related to Epic’s Data Warehouse/Analytics suite and assist with the planning and monitoring of implementing the changes.
*Use Tableau to present data to internal and external stakeholders.
*Assist with the support of Multidimensional and Tabular Model cubes using SSAS.
*Complies with department processes for change management and risk mitigation.
*Communicates with team, stakeholders, and vendors to discuss the status of issues, trends, deliverables, end-user concerns, and anticipated milestones. Provides feedback to vendors on existing functionality and desired new / modified functionality to enhance overall system capabilities.
*Maintains and reviews the status of projects and escalates issues and risks on an ongoing basis with leadership.
*Follows standard work for documentation of all solutions ensuring consistent deliverable and reusable solutions
*Actively reviews and responds to vendor, enterprise, and team correspondence.
*Makes use of IT and enterprise problem/request tracking tools. Keeps current documentation on all assigned tasks. Completes work status and time allocation documentation as required.
*Work with training staff to ensure documentation and training materials are in line with delivered solutions.
*Makes formal and informal presentations to leadership and end users both orally and in writing.
*Other duties as assigned.
Provide primary support to End-Users
*Break/fix support – provides troubleshooting and data validation when data integrity issues arise with existing ETLs and data platforms.
Service Requests/Projects
*Follow established processes to complete service requests.
*Participates in the evaluation, solution analysis, prioritization, and delivery of changes to existing data platforms and ETLs. Evaluates and presents feasibility, effort and timelines required to complete customer requests.
*Maintains regular communication with project team members and leadership as role dictates
Knowledge, Skills & Abilities
Location
Conversion
Shift
Days
Work Type
Full time
Salary:
$93,000.00 – $139,600.00/yr
All job applicants for safety-sensitive positions must pass a pre-employment drug test, once a conditional offer of employment has been made.
Denver Health is an integrated, high-quality academic health care system considered a model for the nation that includes a Level I Trauma Center, a 555-bed acute care medical center, Denver’s 911 emergency medical response system, 10 family health centers, 18 school-based health centers, Rocky Mountain Poison and Safety, a Public Health department, an HMO and The Denver Health Foundation.
As Colorado’s primary, and essential, safety-net institution, Denver Health is a mission-driven organization that has provided billions in uncompensated care for the uninsured. Denver Health is viewed as an Anchor Institution for the community, focusing on hiring and purchasing locally as applicable, serving as a pillar for community needs, and caring for more than 185,000 individuals and 67,000 children a year.
Located near downtown Denver, Denver Health is just minutes away from many of the cultural and recreational activities Denver has to offer.
We strongly support diversity in the workforce and Denver Health is an equal opportunity employer (EOE).
Denver Health is committed to provide equal treatment and equal employment opportunities to all applicants and employees. As an EOE, Denver Health does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.
“Denver Health is committed to provide equal treatment and equal employment opportunities to all applicants and employees. Denver Health is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.”
Your Mission, The Global Analytics & Data Products Team is building a best-in-class analytics team supporting Stellantis’ new Software Group....
Apply For This JobJob Description Overview At The US Oncology Network, we believe that local cancer care is better care. Our Network is...
Apply For This JobJob Description Home Preservation SpecialistSenior Process AssociateIndianapolis, IN In the role of senior process associate, you will execute transactions as...
Apply For This JobJob Description Radiology Technologist – MRI Arlington, VA MUST: Experienced Radiology Technologist – MRI 2+ years of professional experience as...
Apply For This JobJob Description The Silicon Valley office of Morgan Lewis seeks to hire a 1L IP Fellow for our 2024 Summer...
Apply For This JobJob Description Job ID 256392 Location Atlanta, Georgia Full/Part Time Full-Time Regular/Temporary Regular Job Summary Reporting into the IT Service...
Apply For This Job