Epic Caboodle Data Warehouse Analyst

William Backus Hospital Farmington , CT 06030

Posted 3 months ago

Work where every moment matters.

Every day, almost 25,000 Hartford HealthCare employees come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut's most comprehensive healthcare network.

The creation of the HHC System Support Office recognizes the work of a large and growing group of employees whose responsibilities are continually evolving so that we and our departments now work on behalf of the system as a whole, rather than a single member organization.

With the creation of our new umbrella organization we now have our own identity with a unique payroll, benefits, performance management system, service recognition programs and other common practices across the system.

SECTION 1: DESCRIPTION

This position will be responsible for maintaining, improving upon, and developing the Epic Caboodle Data Warehouse. This person will also help report writers, dashboard developers, and data scientists understand Caboodle and its capabilities. The person will also have an opportunity to recommend changes to Caboodle to increase its usability.

SECTION 2: POSITION SUMMARY

  • Reports to the Director, Enterprise Data Intelligence, with day-to-day activities directed by the Application Architect, Epic Analytics Systems

  • This position will work with Business Users and Technical Team to develop maintain Caboodle services and improve upon them.

SECTION 3: KEY ACCOUNTABILITIES

  • Develop Standard Work around regular Caboodle ETL processes

  • Monitor the Caboodle ETL's and recover the runs when necessary

  • Make recommendations for improvement in the process

  • Analyze, query and manipulate data according to defined business rules and procedures.

  • Develop and maintain relationships with Enterprise Data Consumers, HHC's Analytics Department, Epic consultants, and Consulting Partners

  • Provide customer response and updates according to current policies and procedures.

  • Maintain the confidentiality of data, and report any observed non-compliance to security policy.

  • Participate actively in "How Hartford Healthcare Works" (H3W), Hartford Healthcare's Quality Improvement program, and in LEAN

  • Utilize HHC's Processes in Daily Work - ITS Solution Center, BMC Work Orders, LEAN methodology, Change Management, etc.

  • Perform other duties as assigned.

SECTION 4: DIMENSIONS

  • Ability to lift 20 lbs.

  • Gross motor function; both hand, both feet

  • Fine motor function; both hands

  • Ability to bend, squat, reach, lift, carry, push, pull

  • Ability to operate various office machines including printers and computers #HHC

QUALIFICATIONS

Education and Experience

  • Bachelor's degree in Computer Science, Management Information Systems or related field and one to three (1 - 3) years of related experience.

  • Work experience may substitute for minimum education requirement.

Technical Skills

  • SQL Querying skills on databases systems required

  • Ability to interpret and utilize Data Models to develop solutions required

  • Data Analysis, Data Quality Investigation, Data Trends evaluation skills preferred

  • Demonstrated ability to adapt and learn new technologies and techniques required

  • 2 years of hands-on development experience in large ETL/Data warehousing project strongly preferred

  • Experience with SQL Server and Oracle data bases preferred

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Remote Cloud & Data Center Hosting Associate Director

Apex Systems

Posted 2 days ago

VIEW JOBS 1/20/2020 12:00:00 AM 2020-04-19T00:00 Job Description Job #: 1007019 We're seeking a Cloud & Data Center Hosting Associate Director, that can sit REMOTE, who's ready to help us deliver on our commitments today, plan our strategy for the future and leave their fingerprints on the organization for years to come. The successful candidate will serve as an infrastructure leader, working directly with other Digital Technology leaders to develop and implement the company's cloud and hosting transformational strategies, allowing our client to stand on its own as an independent company. The role calls for a highly motivated individual to lead a global team of Digital Technology managers and application owners to assess, plan and execute the migration of infrastructure and applications from current legacy states to fully managed cloud platforms residing in Microsoft Azure and private and shared data centers * Essential Responsibilities * Architects transition plans to "lift and shift" critical applications and servers to robust cloud environments * Leverages new and existing tools to identify and remediate risk and increase efficiency of systems and services to users * Leads the client cloud and infrastructure hosting strategy post transition * Oversees management and monitoring of the global cloud, data center and regional hub platforms * Oversees MIM calls related to relevant cloud infrastructure and participates in the major incident resolution process * Education/Certifications * A bachelor's degree in computer science or a related discipline and/or ten-plus years of relevant leadership experience * Basic Qualifications * Work with a variety of Azure Cloud services, primarily on the Platform services * Infrastructure focused background with hands-on experience using Azure DevOps (VSTS) * Scripting/Automation using common offering such as PowerShell, Terraform, Kubernetes, Ansible, Helm * Excellent with Azure IaaS offering including storage, networking, and management tools * Ten-plus years of cloud and server architecture, strategy and project management experience with an emphasis on digital transformation and transition programs * Strong knowledge of ITIL process management and experience with the Service Now ITSM platform * Experience with program and project management methodologies and functional experience migrating large-scale, complex infrastructure to the cloud * Experience with Microsoft Azure SaaS, IaaS and PaaS architecture and deployment methodologies * A strong background in data center architecture and management strategy * Leadership experience managing and directing transformation programs on a global level, leveraging both onshore and offshore teams to accomplish a goal * A strong sense of urgency * A demonstrated understanding of the nature of core-critical application stability * Experience working in a highly matrixed environment * Extensive knowledge of LAN/WAN topologies, MPLS, iWAN, SDWAN and other global connectivity options * Practical administration experience of the entire network stack including, but not limited to, security, transport (LAN switches), routing, connectivity, servers, storage and the Microsoft stack (Active Directory) [ Link Removed ] EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [ Phone number blocked ] . Apex Systems Farmington CT

Epic Caboodle Data Warehouse Analyst

William Backus Hospital