Informatics Analyst I/II/III/IV

Excellus Health Plan Inc.; City of Rochester (NY); Hybrid; USD 62,000 - 142,000; Full time

Job summary

Excellus Health Plan Inc. is seeking an Informatics Analyst to extract and develop complex reports and analyses, providing summaries and recommendations to Health Informatics leadership.

You will measure healthcare trends, outcomes, and business processes using data mining and BI tools including SAS and Cognos. Level I–IV responsibilities emphasize delivering timely data, identifying trends, mentoring others, and developing predictive analytics.

Qualifications

• Bachelor's degree plus two years' experience in data analysis and reporting.
• Moderate knowledge of relational databases and data extraction.
• One year of SAS, VBA or SQL experience.
• Proficiency with Microsoft Office and data visualization tools.

Responsibilities

• Develops complex reports and analyses with findings and recommendations.
• Monitors healthcare trends, outcomes and business processes with data mining.
• Supports management with statistical information to inform decisions.
• Collaborates on projects, providing data-driven insights.

Skills

Excel

Access

COGNOS

SAS

Data mining

BI tools

Education

Bachelor's degree in Mathematics, Statistics, Medical Informatics, Economics, or related field

Tools

SAS

Cognos

SPSS

Job description

Job Description

Under the direction of Health Informatics leadership, the Informatics Analyst has the responsibility for the extraction and development of complex reports and/or analysis with summaries and recommendations on findings. Monitors and measures health care trends, outcomes and business processes using data mining techniques, statistical techniques, (i.e., control charting) and additional business intelligence technologies.

At the higher levels, the position supplies management with (1) the statistical information needed to make informed decisions, (2) the identification of trends, and (3) the use of data mining techniques and development of advanced predictive models.

Essential Accountabilities

Level I:

• Understands analytic processes and tools such as Excel, Access, COGNOS and SAS. Develops on-going knowledge of Health Plan's varied data sources and structures to independently take in business requirements, design and execute on requests.


• Understands and describes the provision of health care and identifies adverse trends and unusual practice patterns.


• Participates in work teams with other staff in the Health Informatics Department, prepares, develops, analyzes utilization, quality and medical expense data. Ensures that all data are accurate and that the results are provided in a timely manner.


• Participates in problem-solving and investigation, analyses, special projects and research projects as requested.


• Using SAS Software or other appropriate analytic tools and established SAS/SQL programming practices and methodology, defines and develops reporting and analytic solutions including routine reports and analyses, data mining, predictive analytics, stored processes, macros, cubes, dashboards, etc. to support customer requirements and Health Plan business strategies.


• Participates in reviewing and evaluating emerging trends in healthcare and considers/recommends appropriate Health Informatics applications and process changes.


• Assists in identifying cost containment and quality improvement opportunities and makes recommendations to customers for further analysis opportunities.


• Organizes and prioritizes tasks, proposes work assignments so as to successfully complete projects in a timely manner.


• Manages multiple projects with competing deadlines to successful completion.


• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies' mission and values, adhering to the Corporate Code of Conduct and leading to the Lifetime Way values and beliefs.


• Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.


• Regular and reliable attendance is expected and required.


• Performs other functions as assigned by management.

Level II (in addition to Level I Accountabilities)

• Trains and mentors fellow analysts as directed by management.


• Participates on departmental and Health Plan project teams and recommends and/or develops comprehensive data strategies for optimal SAS/BI Tool utilization and connectivity with other BI tools.


• Handles more complex requests (e.g. evaluating new provider payment arrangement or care management activities) and provides more in-depth analytic results and recommendations to customers.


• Integrates visual analytic techniques into reporting to enhance end users understanding of information.


• Collects/analyzes and presents data as information (tell a story) and makes concise recommendations to customers involving simple and complex problems.


• Devises strategy for producing deliverables, selecting and utilizing the most appropriate analytic tool, as well as, to begin to build process efficiencies.

Level III (in addition to Level II Accountabilities)

• Reviews and evaluates emerging trends in healthcare and considers/recommends appropriate Health Informatics applications changes.


• Recommends innovative program designs to support Health Informatics operational processes and customer needs.


• Contributes to innovative quantitative models that reduce costs and/or improve growth/profitability of the organization.


• Acts in a consultative capacity for the business to help business units define analytics that drive business improvements.


• Serves as member of advanced analytic workgroup to prepare data sets for mining and predictive modeling activities.


• Provides expertise in relational database concepts to Informatics areas, as well as customers.


• Seeks out opportunities to train and mentor fellow analysts within the framework of the department.


• Demonstrates keen judgment on involved and complex assignments; devises methods and procedures to meet unusual conditions and makes original contributions to the solution of very difficult problems. Problem solving is complex and involves critical issues.


• Explores data and performs advanced programming and statistical analysis/support for ad hoc requests.


• Provides statistical guidance and alignment in developing Health Plan strategic initiatives.


• Provides oversight and guidance of reporting and data collection methodology and processes.

Level IV (in addition to Level III Accountabilities)

• Recommends to leadership advanced analytic models and/or research that financially (potentially sizably) impact pricing, cost containment, quality, marketing and risk management functions.


• Develops large, complex advanced analytic models and performs data mining functions to identify trends in the data and/or opportunities for improved outcomes.


• Improves visual analytics throughout the organization.


• Interacts with Health Plan leadership to interpret model output and make business inferences that address strategic needs.


• May work on multiple predictive models simultaneously.


• Assesses need and opportunity for upgrades to existing or new analytic products (i.e. SAS or Cognos products).


• Prepares and submits studies for journal publication or presentation at national meetings.

Minimum Qualifications

NOTE: We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it also provides guideposts for employee development and promotional opportunities.

All Levels:

• Bachelor's degree in Mathematics, Statistics, Medical Informatics, Economics, or related field with a minimum of two years' experience in data or information analysis and reporting.


• Moderate knowledge of relational DBs and extracting information from them (i.e. using SAS, Cognos, SPSS, or similar tool).


• One year of SAS, VBA or SQL experience required.


• Intermediate level of the Microsoft suite.


• Knowledge of basic statistical concepts and have strong analytical and problem-solving skills with attention to detail.


• Demonstrates intermediate understanding of healthcare products and operational business knowledge.


• Demonstrated analytic abilities combined with capabilities for completing projects with minimum degree of supervision.


• Knowledge of the health care system and experience working with physician or hospital claims data preferred.


• Excellent oral and written communication skills with aptitude for communicating to a variety of audiences.


• High degree of initiative, proactive attitude and commitment to teamwork.


• Demonstrated ability to effectively interact with internal and external customers. Adaptable to constant industry change and rapidly changing priorities.


• Willingness to solicit and respond to customer feedback.

Level II (in addition to Level I Qualifications)

• A minimum of three years' analytic experience in healthcare industry. Master's degree preferred.


• Knowledge of advance statistical concepts and has strong analytical and problem-solving skills.


• Demonstrated ability to effectively interact with internal and external customers with particular strength translating user information needs into requirements and delivering high quality results.


• Must have the ability to work with large datasets (2TB or greater) and integrate large data across multiple sources (structured and unstructured).


• Strong PC/programming skills including Microsoft Excel, Access, Word, PowerPoint, VBA, SQL, Power Play and Impromptu and moderate proficiency in SAS required.


• Strong analytical, diagnostic, and problem-solving abilities with attention to detail.


• Ability to quickly develop expertise in new application domains and analytic tools.


• Consistently demonstrated high quality and accuracy of work.


• Good self-motivation, initiative, and an ability to perform under pressure with little supervision.

Level III (in addition to Level II Qualifications)

• A minimum of five years' experience using statistical concepts and tools. Master's Degree with at least two years of statistical analysis preferred.


• Demonstrated expertise in relational database concepts.


• Demonstrates advanced statistical capabilities, data mining, forecasting and predictive modeling skills, and/or actuarial techniques.


• Demonstrated skills in quality principles especially root cause analysis and problem solving.


• Demonstrated business and technical problem-solving skills.


• Extensive experience in analytic tools required (i.e. SAS, Cognos, SPSS, or others).

Level IV (in addition to Level III Qualifications)

• A minimum of three years' health care specific predictive modeling experience or seven years of experience in health informatics.


• MS or MA in Statistics, Economics or related discipline preferred.


• Ability to create, develop/validate models independently.


• SAS Base Certification required within 12 months of hire or promotion into position. SAS Advanced Certification preferred or similar Analytic Software certification.


• Project Management/Process Improvement knowledge preferred.


• Continued professional growth in analytic software tools (i.e. SAS competency as evidenced by successful passing of Advanced Certification Exam and/or Certified Predictive Modeler Exam).


• Project Management (PMP, Six Sigma) experience desired.


• Advanced analytic software programming proficiency required (i.e. experience with SAS EBI suite - Information Maps, Stored Processes, Web Report Studio, Information Delivery Portal).

Physical Requirements

• Ability to travel across regions as needed.

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Compensation Range(s)

• Grade E1: Minimum $62,400 - Maximum $84,000


• Grade E3: Minimum $62,400 - Maximum $106,929


• Grade E5: Minimum $71,880 - Maximum $129,384


• Grade E6: Minimum $79,068 - Maximum $142,322

The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including, but not limited to, budget available, prior experience, knowledge, skill and education as they relate to the position's minimum qualifications, in addition to internal equity. The posted salary range reflects just one component of our total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance, retirement plan, wellness program, paid time away from work, and paid holidays.

Please note: There may be opportunity for remote work within all jobs posted by the Excellus Talent Acquisition team. This decision is made on a case‑by‑case basis.