Senior Data Analyst - Rochester, United States - Rochester Regional Health

Description

Position Overview

Expert with healthcare data transformation, analysis, and interpretation. Ownership and support in the creation of detailed analytic models. Perform quantitative and qualitative methods to identify patterns and relationships in large data sets. Report creation and maintenance to empower product teams and guide business decisions.

Job Description

Following is a summary of the essential functions for the Senior Data Analyst. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

Create, maintain, document, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirement
Test coded program routines and makes revisions to eliminate errors
Analyze and document how the business requirements fit into existing systems
Create reports to support business needs using T-SQL and SSRS
Develop technical specifications to resolve business client questions, problems, and to address enhancement needs
Translate detail program specifications for complex problems into coded computer instructions
Interface with all IT and business teams to determine/communicate impacts
Troubleshoot production issues, identifying root cause and implement sound technical resolutions in a timely manner
Plan, develop, test and install solutions
Integrate, query, and validate data from external sources for input into SQL based databases for client-facing business intelligence tools and internal analysis
Lead the business on EMR data collection, processing, archiving, and distribution
Maintain internal data warehouse and monitor input/output procedures

Senior Role Responsibilities

Work with IT management team on project priorities and deliverable timelines
Research, recommend, and develop new methods and procedures for accomplishing tasks and projects
Analyze issues independently, use judgement to make decisions, and take necessary action
Mentor and cross-train team members on IT processes, ensuring supportability across the team.
Provide work direction to less experienced team members
Review work of other team members for accuracy, adherence to standards, optimization

Minimum Skills And Competencies

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Healthcare Data Experience & Knowledge (5+ years)
ICD10 Codes, Diagnosis Codes, CPT Codes
Healthcare Claims and Membership Data
Risk adjustment experience preferred
Data Analysis for Ad-Hoc Reporting based on above data
ETL & Reporting using SSIS/SSRS
Bachelor Degree or in-lieu of degree equivalent education, training and work-related experience
5+ years of experience in the development of SSIS packages
Proficiency in SQL, T-SQL. Proficiency in PostgresSQL PL/pgSQL desired.
Strong Knowledge of relational databases
Demonstrate strong knowledge of data warehouse concepts (data normalization, star schema, etc.)
Demonstrate proficiency in all phases of Software Development Lifecycle
Excellent interpersonal skills with the ability to establish working relationships with individuals at varying levels within the organization
Must perform well in high-energy, dynamic and team-oriented environments
Demonstrates attention to detail, organization, and timeliness in order to meet customer expectations
Demonstrates effective problem solving skills
Effective organization and time management skills with the ability to work under pressure and adhere to project deadlines
Work independently with little supervision
Perform tasks within predefined guidelines and procedures
Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint)

Desired Skills

Vast understanding of data modeling
Healthcare insurance and/or risk adjustment knowledge
Healthcare data experience
Experience with BI Tools
Project leadership experience

If interested, please forward your cover letter and resume to

EQUAL OPPORTUNITY EMPLOYER.

Greater Rochester Independent Practice Association, INC., and

Cognisight, LLC is an Equal Opportunity Employer and does not discriminate against any person because of race, creed, color, religion, national origin, age, sex, sexual orientation, gender identity, genetic information, protected veteran status, or disability.

Education

BS (Required)

Physical Requirements

LICENSES /


CERTIFICATIONS:

S - Sedentary Work - Exerting up to 10 pounds of force occasionally Sedentary work involves sitting most of the time, but may involve walking or standing for brief periods of time.

Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

For disease specific care programs refer to the program specific requirements of the department for further specifications on experience and educational expectations, including continuing education requirements.

Any physical requirements reported by a prospective employee and/or employee's physician or delegate will be considered for accommodations.

Pay Range

$59, $110,000.00

City

Rochester

Postal Code

14617

The listed base pay range is a good faith representation of current potential base pay for a successful full time applicant.

It may be modified in the future and eligible for additional pay components. Pay is determined by factors including experience, relevant qualifications, specialty, internal equity, location, and contracts.

Rochester Regional Health is an Equal Opportunity/Affirmative Action Employer.

Minority/Female/Disability/Veterans by a prospective employee and/or employee's Physician or delegate will be considered for accommodations.
#J-18808-Ljbffr