IEHP is looking to solve the problem of report design and maintenance, ad-hoc and routine reports, and new report development to support business rules and provide technical and analytical guidance for department team members.
Requirements
- 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
- 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)
- Proficient with Select queries with inner/outer joins, Pivots, and advanced text and numeric functions
Responsibilities
- 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
Other
- Bachelor’s degree in Computer Science or Information Systems or other technically relevant degree from an accredited institution required
- Five (5) years of experience in a managed care or health plan setting in a reporting or analytic capacity in any relevant field
- Ability to multi-task. Adhere to IEHP's policies and procedures
- 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
