Shire Jobs

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 alexandra.coykendall@rochesterregional.org

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: 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.

PAY RANGE: $59,000.00 - $110,000.00

The listed base pay range is a good faith representation of current potential base pay for successful applicants. It may be modified in the future. 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/Veteran

Minimum Salary: 59000.00 Maximum Salary: 110000.00 Salary Unit: Yearly