ETL Report Developer- Full Time

Summary of Position:

The ETL Report Developer is responsible for data analysis, validation, cleansing, collection and reporting related to healthcare. Extract and analyze data from various sources, including databases, manual files, and external/internal websites. Document reporting requirements and processes and validate data components as required. Develop ad-hoc reports to conduct data and trend analysis, aggregation, and validation. Develops ETL packages to support the building of the ODS and Data Warehouse. Work with business clients and healthcare leaders to analyze business data information requirements and translate solutions in alignment with industry best practices.

Qualifications

Education:

• Bachelor's Degree required, preferably in health, IT, or business field

Experience:

• Data/Reporting Analyst experience required

• T-SQL experience required

• Experience developing, maintaining, and optimizing ETL packages using Microsoft SQL Server Integration Services required

• SSRS, Crystal Reports, Power BI or Business Objects developing reports experience preferred

• ETL experience to create data marts, data warehouse preferred.

• Epic Clarity data model experience preferred

Knowledge/Skills/Abilities:

• Strong proficiency in ETL tools, ideally SSIS

• Proficiency in programming languages (e.g. Java)

• Strong SQL skills

• Understanding of data modeling and database design principles

• Knowledge of data quality and validation techniques

• Strong analytical and problem-solving skills

• Excellent communication and documentation skills

• Proficient in MS Word, Excel, Outlook

Certifications/Licensure:

• Epic Clarity Cogito certification or obtain within 1 year of hire required

• ITIL Foundation certification preferred.

• Microsoft MSCA or MCSE certification in BI preferred.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• While performing the duties of this job, the employee is frequently required to walk, stand, sit, and talk or hear.

• The employee is occasionally required to use hands to finger, handle, feel or operate objects, tools, or controls; and reach with hands and arms.

• The employee is occasionally required to climb or balance; stoop, kneel, crouch, or crawl.

• Specific vision abilities required by this job include close vision, color vision, and the ability to adjust focus.

• The employee must occasionally lift and/or move up to 25 pounds.

Working Conditions

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Normal office environment. The noise level in the work environment is usually quiet to moderate while in the office.

• Occasional travel to various health system locations.

Essential Functions

1. Provides consistently exceptional care at all times.

2. Develops, maintains, and supports ETL packages in SSIS.

3. Develops and maintains reports in SSDT, Business Objects, Crystal Reports, or any other reporting tool in use by the data team.

4. Documents ETL packages to track data lineage.

5. Functions as the reporting/data extract subject matter expert for the healthcare system.

6. Documents, tracks, and utilize department incident management system.

7. Participates in Change Control processes.

8. Documents, tracks, and utilizes third party incident management system, as needed.

9. Provides excellent communication and is responsible for converting business and clinical requirements into clear technical solutions and code.

10. Identifies and resolves issues within the ETL pipeline to ensure smooth operation.

11. Maintains high performance and quality standards for ETL packages.

12. Writes complex SQL queries, including query tuning, to support data operations.

13. Designs and implements complete ETL/SSIS processes for ODS, Staging, and Data Warehousing environments.

14. Creates clear and comprehensive documentation for ETL/SSIS processes, data flows, and system designs.

15. Performs ad-hoc data analysis to respond to immediate business requirements.

16. Facilitates meetings with business users to prioritize requirements, set expectations, and review new functionalities/designs.

17. Provides training, knowledge transfer, and mentorship to peers to enhance team capabilities.

18. Responds to the needs of the department by performing other duties, as necessary.