Business Intelligence Developer II
Summary
Designs and maintains ETL pipelines and reports for a healthcare data warehouse, using tools like Crystal Reports and Epic Clarity to deliver analytics to leadership.
Responsible for designing, implementing, and modifying ETL (extract, transform, load) jobs and processes for the organizational data warehouse. Possesses a well-rounded understanding of data modeling, analytical skills, the ability to identify solutions to data problems, and to communicate the solutions effectively to the team leadership. Helps interpret business and technical requirements like mapping documents to support the ETL development process, and the execution of ETL jobs.
Principal Accountabilities:
1. Reviews Foundation System reports and identifies advanced analytics needs with report consumers.
2. Creates design specifications for new reports and modifies existing reports as necessary.
3. Identifies and reviews the appropriate technological solutions for various reporting needs.
4. Creates new reports, using a third-party report writing tools such as Crystal reports, to display Clarity data.
5. Performs Crystal integration and distributes Clarity reports to report consumers using Epic.
6. Tests report builds in a specified testing environment, and volume tests in live environments.
7. Reviews upgrade documentation related to Clarity features and released Crystal reporting content and determines the implementation of the changes.
8. Performs other related duties as assigned.
Required:
1. Bachelor's degree in Healthcare Administration, Public Health, Mathematics, Healthcare Informatics, Computer Science or related field.
2. 3 years of experience within Information Technology, Health Care or relevant area.
Preferred:
1. Epic reporting certification.
Principal Accountabilities:
1. Reviews Foundation System reports and identifies advanced analytics needs with report consumers.
2. Creates design specifications for new reports and modifies existing reports as necessary.
3. Identifies and reviews the appropriate technological solutions for various reporting needs.
4. Creates new reports, using a third-party report writing tools such as Crystal reports, to display Clarity data.
5. Performs Crystal integration and distributes Clarity reports to report consumers using Epic.
6. Tests report builds in a specified testing environment, and volume tests in live environments.
7. Reviews upgrade documentation related to Clarity features and released Crystal reporting content and determines the implementation of the changes.
8. Performs other related duties as assigned.
Required:
1. Bachelor's degree in Healthcare Administration, Public Health, Mathematics, Healthcare Informatics, Computer Science or related field.
2. 3 years of experience within Information Technology, Health Care or relevant area.
Preferred:
1. Epic reporting certification.