Remote BI Developer II - IS Analytic Services - Remote - FT/Days
About the position Kettering Health is a not-for-profit system of 13 medical centers and more than 120 outpatient facilities serving southwest Ohio. We are committed to transforming the health care experience with high-quality care for every stage of life. Our service-oriented mission is in action every day, whether it's by providing care in our facilities, training the next generation of health care professionals, or serving others through international outreach.
Responsibilities
- Receive requests for new data sets (cubes, views, etc), reports, dashboards, report changes and incidents through the help desk ticketing system.
- Work with customers to understand business decisions and resulting outcomes, defining requirements for data integration, reporting, analysis and/or data mart development.
- Meet with department/unit leaders and end-users to collect business requirements for data.
- Determine whether existing reports or dashboards can fulfill requests, if modifications to existing reports or data sets are needed, or new reports, data sets or visualizations need to be developed.
- Build/modify data sets, reports and dashboards for requests based on collected requirements.
- Generate standard or custom reports for clinical, quality, business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
- Conduct end-user validation of data and visualizations to ensure they fulfill established requirements.
- Collaborate with departments/units to determine the appropriate users to run and view reports.
- Assist in the development of role-based reporting security groups and assign reports to the appropriate security group.
- Work with the Security team on user provisioning to ensure users are assigned to the appropriate reporting security groups.
- Develop BI deliverables using Microsoft SQL Server Reporting Services and self service BI tools.
- Develop and maintain standard BI cubes from data warehouse data sets.
- Evaluate, maintain or update business intelligence tools, databases, dashboards, systems, or methods as appropriate.
- Maintain library of model documents, templates, or other reusable knowledge assets.
- Create business intelligence tools or systems, including design of related databases, cubes, spreadsheets, or outputs.
- Work with technical infrastructure team to ensure integrity of data.
- Create or review technical design documentation to ensure the accurate development of reporting solutions.
- Obtain data from multiple sources to create integrated Business Intelligence deliverables that can be used to drive decision making.
- Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs.
- Training and coaching of customers on utilization of reporting and business intelligence tools.
- Assist in coaching and mentoring team members on report development processes and standards and BI report development skills.
- Participate in on-call rotations to provide off-hours support.
- Work with vendors and internal resources to understand and develop data extract requirements, such as Explorys interfaces, Press Ganey interfaces, etc.
- Work as a key member of the Analytics team to bring product, best practice and development expertise to future initiatives.
Requirements
- Associates degree or equivalent combination of education, certification, and experience.
- Minimum of 2 years of experience in data analysis, report creation and visualization.
- Epic Certification (Clarity, EDW) or obtained within 6 months.
Nice-to-haves
- Experience with self-service BI tools (PowerPivot, Power View, Tableau, Qlikview, etc.)
- Knowledge of data warehouse concepts including: data modeling, data quality, ETL and data mining.
- Microsoft SQL Server BI tools: SQL Server, SSIS, SSAS, SSRS.
- SQL and Stored Procedures expertise in relational databases.
Apply tot his job Apply To this Job