Report Developer II

Role Overview

• Analyze, develop, monitor, and update reporting specifications, as required to ensure compliance with changes in State, Federal, contractual and/or IEHP program requirements.
• Develop and oversee auditing reports for business unit configuration.
• Track and trend department applicable data and identify opportunities to maximize automated processes.
• Provide management with reporting and an analysis of trends.
• Develop and support break-fixes and change requests for ad-hoc and standard periodic reports using Microsoft SQL Server and other reporting tools.
• Prepare regulatory and compliance audits and requests by reviewing and providing data, and completing related research, analysis, and validation of the data.
• Utilize intermediate/advanced SQL programming skillset and/or other reporting tools to contribute to the development and documentation of reporting through: a. Coordinating and conducting unit sessions for collecting and documenting reporting requirements from customer work sessions. b. Identification of custom or ad hoc reports to include detailed technical requirements. c. Translating business requirements into specifications that will be used to implement the required reports. d. Design, development, and testing of custom reports to meet business requirements. e. Modification of baseline reports. f. Defining, documenting, and executing unit test cases to confirm requirements are met. g. Support system and user acceptance testing activities, including issue resolution.
• Use LEAN methodology to develop and implement system improvements idea to facilitate continuous improvement of current processes.
• Follow applicable unit standards and protocols for completing break-fixes, troubleshooting, and SQL query optimization for existing reports and development of new requests.
• Aid in identification and enforcement of new standards.
• Create or enhance existing department guideline documents as it pertains to personal tasks.
• Exercise efficient data mining techniques and develop new, or modify existing, methodologies to perform comprehensive data analysis.
• Perform batch adjustments of department data and analyze data results.
• Develop and perform core system release testing cases.
• Remain proficient with best practices and common processes for developing solutions with various reporting tools utilized in role.
• Promote teamwork and maintain effective working relationships with others throughout the organization.
• Perform any other duties as required to ensure Health Plan operations and department business needs are successful.

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, spread sheet 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.