Business Intelligence Developer II

The Business Intelligence Developer II works under general supervision and is responsible for activities related to developing reports, extracts, dashboards and other business intelligence tools for financial, operational or clinical information systems supporting the activities of Bronson Healthcare Group., * Uses knowledge and understanding of business operations and key performance indicators in order to provide recommendations on BI solutions.

• G uides customers to define business reporting requirements and preferences and ensure data consistency and quality.
• Generates reports and designs dashboards for internal and external customers for business performance monitoring and business decision making.
• Summarizes and analyzes data to provide insight and identify key learnings to facilitate decision making to improve service delivery, increase revenue and reduce costs.
• Performs data validation to ensure accuracy and appropriateness of underlying data and analytic models.
• Produces technical documentation to support data delivery development.
• Works in Agile environment participating in daily team huddles.

• Collaborates with other IT staff and business stakeholders reviewing, testing and piloting new Business Intelligence solutions.

• Corrects routine and non-routine reporting issues or works with other IT staff, Department Users, System Coordinators and Vendors to correct individual problem situations and restore service.
• Develops and maintains collegial relationships and regular communication with all Department Users, System Coordinators, IT staff and Vendors as relates to analytics in area of responsibility.
• Supports and participates in the research, planning, installation, configuration, testing, troubleshooting, maintenance and upgrade of applicable systems. Analyze and evaluate present or proposed business procedures or problems to define data needs.
• Understands the choices involved in application specifications
• Investigates and analyzes customer preferences and business operations while making data analysis decisions
• Analyze new reporting and business intelligence functionality in releases to determine how it could be used
• Develop and document internal procedures to use in conjunction with business intelligence and analytics
• Work with application builders to ensure that the application has the necessary data.
• Keeps abreast of developments in business intelligence and data visualization fields and evaluates developments for applicability or incorporation into existing applications.
• Evaluates systems, processing, and development needs and recommends additional equipment or new systems.
• Resolves or ensures proper escalation during outages or periods of degraded system performance.
• Serves as subject matter expert and mentor for level I analysts.
• When appropriate, lead or co-lead system activities as assigned.
• Participate in the planning, development, implementation, maintenance, and evaluation of financial, operational or clinical information systems as it pertains to reporting and business intelligence. Maintain a current understanding of the processes involved in these activities.
• Collaborate with information technology, customer and vendor teams in the evaluation of development efforts, in planning the pilot and full implementation of new systems and/or new features, and in processing user feedback and requests.
• Maintain a detailed understanding and working knowledge of the current financial, operational or clinical information systems, their functions, reporting capabilities and their relationship to other Bronson information systems.
• Participate in the process of revising and implementing changes in both the automated and manual components of the financial, operational or clinical information systems as related to reporting and data extraction.
• Provide proactive customer support for reports, dashboards and other business intelligence related to the financial, operational or clinical information systems, working with the System Coordinators, key stakeholders, and Bronson leadership.
• Participate in systems analysis and research related to financial, operational or clinical information systems.

Education typically acquired through completion of a Bachelor’s degree (required) or an equivalent combination of education and experience, and at least three years of successful progressive experience writing reports and SQL queries as well as developing dashboards and data models for financial, operational or clinical information system applications required. Strong data visualization skills required. Experience with Crystal Reports preferred. Working knowledge of healthcare operations is required. Experience with data cubes, data universes, and data warehouses preferred .

-Current clinical licensing and/or certification (or progress toward certification completion) if applicable.

-Applicable Epic data model certification (e.g. Inpatient, Ambulatory, etc.) required or must complete certification within 6 months of hire.

• Demonstrated proficiency in Microsoft Office Suite

• Three or more years of progressive experience writing or supporting reports and dashboards from relational databases, cubes, universes and data warehouses for financial, operational or clinical information systems

• Ability to work with end users to determine reporting and dashboard specifications, and translating data into usable information for the end user.

• Ability to create system documentation, project plans, test scripts and education materials

• Familiarity of end user business practices, concepts, terminology sufficient to develop and support business intelligence in a healthcare delivery environment

• Detailed working knowledge of business intelligence analysis, design, build, deployment, modification, enhancement, support as well as troubleshooting techniques.

• Working knowledge of project management methodology, change control, quality and system performance methods and metrics.

• Ability to lead small projects to completion with positive success metrics.

Work which produces very high levels of mental/visual fatigue, e.g. CRT work between 70 and 90 percent of the time, and work involving extremely close tolerances and considerable hand/eye coordination for sustained periods of time. The job produces some physical demands. Typical of jobs that include regular walking, standing, stooping, bending, sitting, and some lifting of light weight objects.

Strong customer service skills with the ability to communicate both orally and in writing. Must be able to interact with customers, individually and in small groups, to gather the information necessary to design useful reports , dashboards, and data models. The employee must consistently negotiate timeframes and act on deliverables with stakeholders (customers, peers, etc.), take ownership of issues, and respond to issues within expected timeframes. Expected to demonstrate general leadership skills.