The Business Intelligence Developer (BID) will analyze, provide specifications for, and write individual reports and data extracts for various applications across the organization. The incumbent is responsible for validating model/foundation reports and identifying advanced reporting needs for the organization, will create technical specifications and outputs for new requests, and will build using the appropriate methodology in the business intelligence stack.

1. Develop complex SQL queries against various data models. Collaborate with Business Intelligence Analysts to apply these solutions within the Epic Cogito framework and Power BI tool to deliver metrics and metric drill through for end users.
2. Validate Foundation System reports and identify advanced analytics needs with report consumers.
3. Determine data needs through collaboration with application analysts and requestors to understand their data needs.
4. Create design specifications for new reports.
5. Identify and validate appropriate technological solutions for various reporting needs.
6. Create new reports using a third-party report writing tool (such as Power BI). Modify existing reports as necessary.
7. Review peer reports for validity.
8. Test report build in a specified testing environment and volume testing in live environments.
9. Review upgrade documentation related to Clarity and Caboodle features and other released reporting content and determine how to implement the changes.
10. BIDs are also responsible for building including but not limited to Universes, SSAS Cubes, extracts, SlicerDicer, and reports to query the Caboodle Data Warehouse

QUALIFICATIONS:
Must possess and maintain Epic certification in all applications in their area and other related areas within 3 months of training.

EDUCATION:
Bachelor’s degree in computer sciences, math or information systems required. Four or more years of relevant experience above the minimum required may be substituted for the degree requirement at the discretion of the Assistant Vice President, Digital Transformation.

EXPERIENCE:
Minimum five years of applicable experience required, to include at least one year of experience writing and troubleshooting SQL queries.