Report Developer II

Role Overview

• Responsible for report design and maintenance of ad-hoc and routine reports, and new report development.
• Providing technical and analytical guidance for applicable department Team Members of all levels and department projects.
• Analyze and interpret applicable system methodologies through reporting capabilities.
• Work with Department Team Members to define requests, requirements, design, and the development of quality reports that meet the business needs for the applicable unit.
• Responsible for development projects in collaboration with other business units throughout the organization.
• Navigate applicable IEHP systems.
• Commitment to incorporate IEHP’s Quality Program goals including, but not limited to, HEDIS, CAHPS, and NCQA Accreditation.

Requirements

• Five (5) years of experience in a managed care or health plan setting in a reporting or analytic capacity in any relevant field.
• Five (5) years of technical experience in Structured Query Language (SQL) system design, development, and production support of large applications/systems – including database management techniques.
• Bachelor’s degree in Computer Science or Information Systems or other technically relevant degree from an accredited institution required.
• Knowledge of data analysis, data presentation, spreadsheet and database capabilities.
• Strong knowledge of department applicable methodologies, including stored procedures.
• A strong understanding of data flow in healthcare domain, interoperability, and data integration is required.
• Strong knowledge of Microsoft SQL Server Reporting Services (SSRS).
• Various data tools separate from Microsoft SQL Server Reporting Services preferred (e.g. PowerBI, ThoughtSpot, GitHub, Kibana Elasticsearch, Crystal Reports, Business objects, and Google Analytics).
• Must have strong analytical skills and can demonstrate strong problem-solving skills.
• Proficient with Select queries with inner/outer joins, Pivots, and advanced text and numeric functions.
• Work independently or with little direction.
• Has strong initiative to meet established deadlines.
• Strong attention to detail.
• Communicate effectively, both verbally and in writing, in order to develop and maintain effective working relationships with all levels of staff and management.
• Work cooperatively and effectively on group projects.
• Ability to multi-task.
• Adhere to IEHP's policies and procedures.

Tech Stack

• ElasticSearch
• MS SQL Server
• SQL

Benefits

• Competitive salary.
• Hybrid schedule.
• State of the art fitness center on-site.
• Medical Insurance with Dental and Vision.
• Life, short-term, and long-term disability options.
• Career advancement opportunities and professional development.
• Wellness programs that promote a healthy work-life balance.
• Flexible Spending Account – Health Care/Childcare.
• CalPERS retirement 457(b) option with a contribution match.
• Paid life insurance for employees.
• Pet care insurance.