The Senior Clarity and Caboodle ETL Administrator designs, develops, tests, tunes, and maintains Extract, Transform, and Load (ETL) processes within the Epic Clarity and Caboodle database environment, and custom data stores and marts. The Senior Clarity and Caboodle ETL Administrator also performs modifications, full upgrades, patches, and SUs on all Epic Clarity and Caboodle environments. Also performs production support and maintenance operations, participates in on-call support rotation, and actively resolves incidents and restores services in a continuous improvement environment. Is assigned projects associated with expanding Caboodle data models, building custom Caboodle data models and ETL processes, fulfills requests to acquire additional data in Clarity and Caboodle, and provides excellent partnership, collaboration, and consulting with other IT members and business customers.
Participates in the development, documentation, and solution design of logical and physical data models. Additionally, technical expertise is applied to the design, development, and support of processing data of multiple databases and formats involving both internal and external sources and targets.
Designs, develops, and tests ETL processes for error handling, operations logging and alerting, scheduling and job control. Develops, tests, and deploys quality ETL processes with minimal post-production incidents and performance and tuning excellence. Performs data analysis and data profiling.
Performs production support to enhance stability and maintainability of solutions and continuous improvement. Actively resolves incidents and restores services in a continuous improvement environment. A strong proactive posture minimizes user outages and help desk incidents.
Troubleshoots incidents surrounding supported solutions, including after-hours escalations of major incidents.
Troubleshoot, perform root cause analysis, solution production support incidents, and apply permanent improvements.
Effectively balances and prioritizes workloads among project work development, support maintenance and operations (including on-call rotation), innovation and creativity, and initiative in a proactive, continuous improvement environment.
Completes complex work assignments independently, takes initiative to flush out gaps in requirements or hopeful business outcomes, documents and confirms key understandings, and produces products with extremely low production support footprints.
Performs consistently as a team player who shares knowledge, maintains effective working relationships, and puts yourself in service to othersmaintaining extremely high customer service levels.
Contributes to the development of team process and technical standards, including the creation of reusable objects, highly efficient batch performance, and service management excellence.
Translate business requirements into technical solutions, dealing well with ambiguity, and concluding how deliverables meet business goals.
Bachelors Degree in related field or an equivalent combination of education and related experience.
5+ years of experience performing as a Clarity ETL Administrator
5+ years of experience performing as a Caboodle ETL Administrator
5+ years of experience performing Clarity / Caboodle upgrades and SUs
5+ years of experience delivering DataLink and Smart Data Element solutions
5+ years of experience with Caboodle data models and development
5+ years of experience delivering data quality outcomes, working with relational databases and a multitude of file formats.
5+ years of experience with logical and physical data modelling.
5+ years of experience with data warehouse design and methodologies, including change data capture, star schemas, snowflakes, cubes and dimensional modeling.
Demonstrated excellence using logical, analytical, and creative problem-solving skills.
Excellent influence skills, using written and oral communication skills--including the ability to communicate ideas in both technical and business terms.
Proven ability to conduct root cause analysis and research into systems and data issues.
High levels of data quality and delivery excellence, effective and proactive verbal and written communication, excellence in customer service and partnerships, persistence, initiative, and teamwork are minimum success factors for this senior role.
Epic Clarity Administration experience or certification
Epic Caboodle Administration experience or certification
Epic Caboodle Developer experience or certification
Bachelors Degree in related field
5+ years of ETL and SQL development experience, preferably Data Stage or SSIS.
5+ years of experience with a combination working with Clarity on Oracle and Clarity on SQL Server
3+ experience as an Oracle or SQL Server Database Administrator
Together with the University of Minnesota and University of Minnesota Physicians we have created M Health Fairview. M Health Fairview is the newly expanded collaboration among the University of Minnesota, University of Minnesota Physicians, and Fairview Health Services. The healthcare system combines the best of academic and community medicine — expanding access to world-class, breakthrough care through our 10 hospitals and 60 clinics.Fairview Health Services (fairview.org) is an award-winning, nonprofit health system providing exceptional care across the full spectrum of health care services. Fairview is one of the most comprehensive and geographically accessible systems in the state, with 10 hospitals—including an academic medical center and long-term care hospital—serving the greater Twin Cities metro area.Its broad continuum also includes 60 primary care clinics, specialty clinics, senior living communities, retail and specialty pharmacies, pharmacy benefit management services, rehabilitation centers, counseling and home health care services, medical transportation, an integrated provider network and health insurer PreferredOne. In partnership with the University of Minnesota, ...Fairview’s 32,000 employees and 2,400 affiliated providers embrace innovation to drive a healthier future through healing, discovery and education.