Business Intelligence Developer - OnSite/Hybrid

Agrace is a nonprofit, community health care organization that is nationally recognized as a leader in the hospice industry. Well known for end-of-life care, Agrace also serves people across southern Wisconsin who are aging, seriously ill or grieving. 

Agrace has a strong culture of employee engagement. In 2023, Agrace was named the #1 Top Workplace by the Wisconsin State Journal and Energage, and #79 of the top 100 companies in the country among those with an employee base of 500 to 999 workers!

WHO YOU'LL WORK WITH (AND WHAT THEY HAVE TO SAY)

The Business Intelligence Developer/Analyst works on a collaborative team including Business Intelligence Developers, and the Director of Data Operations. 

"The organization is transparent and does things the right way" - Agrace IT Employee

HOW YOU’LL MAKE A DIFFERENCE IN THIS ROLE (ESSENTIAL FUNCTIONS)

The Business Intelligence (BI) Developer, as part of Agrace’s BI team, supports data architecture and builds solutions to support the growth of the organization. This role uses their understanding of data flows between systems, databases, and data warehouses to perform reporting and analysis, streamline processes, and support ad hoc data related needs. The BI Developer works with end users to understand requirements, formulate use cases, and translate needs into effective technical terms and solutions. This developer is also responsible for interacting with multiple business units and cross functional teams to drive consistency, standardization, and governance across the organization.

• Data governance 
  • Perform routine regression testing to ensure continued integrity of historical data and ETL.
  • Manage the user acceptance testing (UAT) process for new development projects, ensuring the test plan is a comprehensive validation of the new project ETL, coordinating and executing test scenarios to validate the system, managing, and resolving issues, facilitating the team UAT review and signoff and meet project deadlines.
  • Design, develop, and maintain APIs using RESTful architecture and modern programming languages (e.g., Java, Python)
  • Ensure the systematic management and timely updates of essential data documentation, including data dictionary, dashboard documentation, and workflow documentation.
  • Support the Epic upgrade process by identifying impacts to the Snowflake cloud data warehouse and working with the BI and EHR teams to identify and implement any needed resolutions.
  • Ensure API security, scalability, and performance. Write comprehensive documentation and API specifications.
  • Promote data governance through collaboration with other teams and participation in various initiatives; educate and support business partners in alignment with data governance strategy.
  • Maintain data glossary, data purging, and verification.
  • Collaborate with members of the BI, IT, EHR, and operational teams to drive data governance.
  • Participate in guideline and process reviews.
  • Stay up-to-date with industry trends and emerging technologies.
• Reporting 
  • Create both periodic and ad hoc reports.