ITS Bus Intelligence Dev III - Tableau / IS Reporting

Description

Job Schedule: Full Time

Standard Hours: 40

Job Shift: Shift 1

Shift Details:

Work where every moment matters.

Every day, approximately 38,000 Hartford HealthCare colleagues 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.

Position Summary:

The HHC BI Analytic Developer/Analyst works under the direction of the ITS Analytics Enablement Manager and is responsible for the design, build, testing, implementation, training, and support of operational and analytical solutions based on detailed specifications.

The BI Analytic Developer/Analyst is a key member of the Analytics Enablement team and is responsible for the creation, documentation, and support of visualizations and other analytic solutions of high complexity. They work closely with customers to gather report requirements and ensure proper testing/validation. They document specifications for visualizations that are created and modified.

They utilize knowledge of database design, data structure, and modeling to deliver system initiatives, regulatory reporting, and clinical and operational solutions. Attention to detail is a critical skill for this position.

Successful candidates enjoy helping other users learn and adopt the usage of the application. They will work closely with system vendors, consultants, and technical services of any given affiliate to ensure development, testing, and implementation meet user specifications and operational needs.

Responsibilities include but, are not limited to the following:

Development:

Ø Meeting with decision makers, system owners, and end users to define data requirements & goals

Ø Lead discussions with business partners to identify functional requirements resulting in the development of system specifications and Tableau applications

Ø Develop dashboard wireframes and design requirements based on discussion with an understanding of technical and visual design considerations

Ø Develop, implement, and maintain Tableau or other analytical dashboards to support business and IT groups across the Digital organization

Ø Write and optimize SQL queries

Ø Developing rich interactive visualizations integrating various reporting components from multiple data sources

Ø Coordinating and performing in-depth tests, including end-user reviews, for modified and new processes and other post-implementation support.

Ø Debug, monitor, and troubleshoot issues during the test and post-implementation phases.

Data & Governance:

Ø Provide recommendations on the data mart structures that support analytical applications

Ø Communicating data structure changes, enhancements, and modifications verbally or through written documentation to the data governance team for implementation

Ø Perform data modeling based on multiple data sources

Ø Aware and able to use data preparation tools for profiling and data transformations.

Ø Understanding common data sources and data available on the systems available for projects and self-service power users.

Ø Understanding the data governance process and integration with the data governance domain.

Business:

Ø Transforming business needs into actionable visualizations in analytic solutions for use by internal and external stakeholders

Ø Understanding of healthcare terms and processes and Epic applications.

Best Practices:

Ø Provide best practices and industry standards to guide BI strategy development

Ø Ensure a consistent design and approach for analytics across the business areas

Ø Understanding of visual design principles

Ø Create or update design documentation according to team and standards

Ø Effectively communicates with team members and business stakeholders

Ø Optimize solutions with a focus on usability, performance, flexibility, testability, and standardization

Server Site Admin:

Ø Partner with colleagues to develop standards for hosting Tableau services/application

Ø Ensure application stability and performance by monitoring existing production systems to ensure they are working correctly and that they reconcile with the system of record

Ø Publish dashboards and data sources to Tableau Server managing access, user security, refreshing of Tableau extracts

Ø Create and manage the site's users and groups

Ø Assign permissions to allow users (groups) to access the content.

Ø Promote and certify content and measure the use of analytics within their site.

Ø Review daily the production environment for failed jobs and correct them.

Ø Apply good developer habits by cleaning up or archiving TEST server content.

Skill Level:

Ø Provide expertise on how to use Tableau and other analytic tools in performing statistical Analysis

Ø Show Intermediate to Advanced Development use of features

Ø Leverage advanced functionality (parameters, actions, tooltip modifications, API, ) to create meaningful and industry-appropriate analytical dashboards

Ø Understanding and use of Healthcare data or experience with Epic reporting capabilities (Workbench, Radar, Slicer Dicer etc)

Ø Understand and provide business statistical metrics and calculations

Ø Understand cloud-based platforms like Google and use Data Prep and BigQuery

User Community:

Ø Provide technical support in defining a business partner approach to self-service

Ø Mentoring the business users on process procedures and best practices

Ø Participate in User Community events or present and create content for User community events

Ø Provide end-user training

Ø Create content for the use of repeatable processes or training for end users.

Support:

Ø Support production environments (Tableau, Google, etc)

Ø Handle tickets promptly and according to team SLA

Ø Communicate often with Customer to provide updates, ensure understanding, and to set expectations

Ø Document all activity related to tickets that include blockers and next steps

Ø Provide ad-hoc data analysis and support to business functions

Qualifications

Education:

• Bachelor's Degree in Management Information Systems (MIS), Analytics, or related discipline

Experience:

• 4 - 6 years of relevant experience developing and training in and using Tableau (Desktop, Prep Builder, Tableau Server) in a large healthcare system developing operational and analytical dashboards in a complex healthcare environment.

• Demonstrated proficiency in SQL; Oracle PL/SQL required for Epic Clarity and T-SQL for Epic Caboodle and internal SQL databases.

• Experience with other analytic tools and platforms (ie Tableau Cloud, Google Bigquery, Google Data Prep, Looker Data Studio, Informatica EDC, and Axon) a plus.

. Experience with developing Python and Tableau's suite of APIs a plus.

We take great care of careers.

With locations around the state, Hartford HealthCare offers exciting opportunities for career development and growth. Here, you are part of an organization on the cutting edge - helping to bring new technologies, breakthrough treatments and community education to countless men, women and children.

We know that a thriving organization starts with thriving employees-- we provide a competitive benefits program designed to ensure work/life balance. Every moment matters. And this is your moment.