Business Intelligence Developer - OnSite/Hybrid

Job Details

Job Location Madison - Madison, WIPosition Type Full TimeTravel Percentage Non-DrivingJob Shift AMJob Category Business Development

Description

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!

 

Hours Monday-Friday 8:00am-5:00pm Hybrid 2-3 days in office 

 

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.
  • Create visualizations and assist business partners in their efforts garner data insights.
  • Support the data needs and reporting for the annual operating plan reports out.
  • Support data decision-making by providing ThoughtSpot expertise.
  • Support the data needs for regulatory and other reporting.
• Business improvement initiatives
  • Gather requirements from end users and translate them to technical objectives.
  • Support the success of the Snowflake enterprise data warehouse through business dimensional model design and user acceptance testing.
  • Analyze and present data in a way that facilitates meaningful interpretation by customers, including value-added observations and recommendations.
  • Collaborate with members of the BI, IT, and EHR teams on project work allocation and prioritization.
  • Identify and incorporate opportunities for greater efficiency and effectiveness within the BI team.
•  Other Duties
  • Participate in internal work groups, meetings, and committees relative to position responsibilities.

YOU BRING (EXPERIENCE & QUALIFICATIONS)

• Associate’s degree in IT, Computer Science, Math or business related field; or equivalent combination of education and work experience
• Advance analytical skills and experience
• Proficiency in one or more programming languages

• Experience with containerization (e.g., Docker) and cloud platforms (e.g., AWS, Azure)
• Knowledge of API management tools
• Familiarity with data governance principles and practices
• Experience with reporting and visualization tools
• Creative, data-driven problem solver
• Experience with data warehouse environments
• Strong attention to detail, as well as ability to view the bigger picture
• Ability to work effectively and cooperatively with others
• Ability to communicate effectively verbally and in writing with all levels of the organization
• Ability to be flexible in time and task to meet organizational needs
• Ability to maintain confidentiality about patients, families, caregivers, staff, donors, and organizational intellectual property.
• Ability to use proper body mechanics and standard precautions

 

Don’t meet these qualifications as written? We would still love to talk about roles at Agrace: Join Here!

 

 

At Agrace we are strengthened by the unique experiences, cultures and traditions of our staff, patients, and clients.

Together, we pursue a vision in which every Agrace staff member is treated fairly, and every patient and client experiences the respectful, individualized care they need and deserve.

We foster a culture of belonging that celebrates people’s uniqueness and leads to meaningful, empathetic connections.

 

Agrace HospiceCare is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.