IT Engineer Applications - Reporting Data Engineer

Role & responsibilities

Must have skills:

• Minimum of 2 years of hands-on experience with SAP BusinessObjects (BO), including report development and design.
• At least 1 year of experience in Oracle PL/SQL development, including writing complex queries, stored procedures, and performance optimization.
• Proficiency in Crystal Reports, including report design, formatting, and integration with data sources

Job Summary

Brief summary in 1-2 paragraphs of the job's purpose, primary focus, sets clear expectations for ideal candidates.

This individual contributor is primarily responsible for translating business requirements and functional specifications into Business Objects, back-end PL/SQL, and other reporting software solutions (such as Epic Reporting WorkBench), maintaining reports and SQL code, assisting with release to production, and taking direction from senior developers located in the USA and India. Opportunity to learn Epic Reporting WorkBench, if the candidate does not already know this tool.

Essential Responsibilities

List primary and specific job duties performed daily in order of importance.

- Works with reporting team located in the USA to keep a mature inventory of Business Objects reports and back-end SQL procedures maintained, as required when the Epic Tapestry AP source system is upgraded, which occurs twice yearly.
- Receives manifest of changes and release notes from Epic, identifies impacted reports and SQL procedures, and works with the reporting team to address gaps and remediate issues introduced by the planned release of the next version of Epic Tapestry AP (twice yearly). - Troubleshoots and maintains back-end Oracle PL/SQL routines which support the report inventory. - Works with the reporting team on performance improvements and enhancements as required. - Completes report development and analytical work assignments by applying relevant SQL-tools knowledge to a very large set of health-care claims data; follows established procedures and policies, applying SQL skills to support projects and initiatives - Adheres to established priorities, deadlines, and expectations while collaborating with the reporting team, other SQL developers, testers and business analysts, often cross-functionally, to solve business problems; communicates progress and relevant information. - Updates report documentation as required to support report testing before production release. - Recommends improvement opportunities and escalates risks and issues appropriately.

Job Qualifications

List of minimum education and minimum years of experience, level of knowledge, skills, abilities, licensures, certifications and other job-related requirements that must be met to be considered for a position. GCC's cannot hire candidate's that do not meet all of the minimum qualifications. Fewer minimum qualifications and more preferred qualifications broadens the applicant pool.

Minimum Qualifications

- Bachelor's degree in Business Administration, Computer Science or related field.
- Minimum three (3) years experience in software development or a related field. - Minimum two (2) years demonstrating Business Objects development. - Minimum one (1) year demonstrating Oracle PL/SQL development.

Additional Requirements

- Independent problem solver
- Understanding of shell scripts and SFTP protocols - Familiarity with Tableau - Familiarity with informatica or other ETL tools - Healthcare data or claims adjudication data experience - Additional equivalent work experience may be substituted for the degree requirement

Licenses and Certifications

Preferred Qualifications

List of nice-to-have skills that are not required, but are desired qualifications that would compliment the job. These include complex skills, unique knowledge, job experience, added education, certifications, or licenses.

Note: If a skill is required, please list it under minimum and basic qualifications.

- Demonstrated experience using the Epic Clarity Data Model
- Experience with Epic Reporting Workbench and Radar - Experience with claims adjudication systems and data, such as Epic Tapestry AP - Epic Cogito Tools Certification - Epic Clarity Data Model Certification - Oracle PL/SQL Certification - SAP BO Certification - MS Power BI