Business Intelligence Developer

Spectrum Health requires all team members to receive the COVID-19 vaccinations subject to certain exclusions based on the team member’s job category. Spectrum Health is committed to granting reasonable accommodations in accordance with applicable laws. Who We Are Formed from two leading health systems in Michigan (Beaumont Health and Spectrum Health), BHSH System is a not-for-profit health system that provides care and coverage with an exceptional team of 64,000 dedicated people—including more than 11,500 physicians and advanced practice providers and more than 15,000 nurses offering services in 22 hospitals, 300 outpatient locations and several post-acute facilities—and Priority Health, a provider-sponsored health plan serving over 1.2 million members across the state of Michigan. Through experience, innovation and collaboration, we are building a system designed to meet the needs of the people we serve through care and coverage that is accessible, affordable, equitable and exceptional. Our system brings together three outstanding care delivery organizations and an award-winning health plan: BHSH Beaumont Health, BHSH Spectrum Health Lakeland, BHSH Spectrum Health West Michigan and Priority Health. Each division brings its own nationally recognized teams and storied legacy, and each contributes to our culture. Together, we are creating a health system designed for the people we serve and transforming health For Michigan, By Michigan™. Spectrum Health and Beaumont Health officially launched as the new organization temporarily known as BHSH System on Feb. 1, 2022. BHSH System is locally owned and operated, with corporate offices in Grand Rapids and Southfield, Michigan, and additional offices throughout Michigan. Job Summary Partners with the business to turn data into critical information and knowledge. Possesses a fundamental understanding of healthcare and/or data and analytics. Develops reporting and analytic solutions with knowledge of the primary source data (i.e., electronic health record, claims) and workflows. Develops relationships with users for direct consumption or integration with other systems. BI Developers promote data literacy by educating and training customers to use the data as an analytical tool, displaying the information for the purpose of analysis and exploration. Under minimal supervision, designs, codes, configures, tests, debugs, deploys, documents, and maintains programs. Uses a variety of software development tools, programming languages and testing/verification applications. Their work adheres to development best practices and quality standards. Gathers business requirements and translates the information into detailed technical specifications from which programs will be written or configured, and to validate that the proposed applications align with both the architectural design and business needs. Works closely with other BIDs, Data Engineers, Data Scientists, and internal/external customers. Essential Functions Designs, codes, configures, tests, debugs, deploys, documents, and maintains self-service reporting assets and Extract, Transform and Load (ETL) for the purpose of populating data warehouse assets and sending data outside of data warehouse assets. Translates and documents business program needs into a technical solution using visuals and creating data sources, metrics and automation. Visuals, data sources and automation will be created from electronic health record (EHR) reporting tools and databases, (ie Clarity, Caboodle, Epic Registries, Epic Extract Framework, Custom Radar SQL metrics, Data Links, and Predictive Model configuration), cloud reporting systems (ie Snowflake), and other EHR agnostic tools (ie SSIS, GoAnywhere, Tableau, PowerBI, etc) Provides analytics that can turn data into critical information in understanding a business problem Independently able to provide troubleshooting, maintenance, support, oversight and technical guidance Possesses knowledge of workflows in multiple business areas to support data development, analytics and quality improvement activities Performs job-related duties in conformance with IS standards and may initiate new/improved standards Participates in Agile ceremonies determining the nature and scope of project activities and processes to be developed or modified, working across teams to communicate development dependencies to accomplish final solution Works with data architects as the architect designs relational and dimensional data models to verify that the model meets the use cases and aligns with strategic direction Qualifications Required Bachelor's Degree or equivalent in business, liberal arts, computer science, application programming, software development, information systems, database administration, mathematics, engineering, or other related field 2 years of relevant experience Required 6 months of relevant experience EPIC Cogito Certification within 6 months Required Primary Location SITE - 25 Ottawa Ave SW - Grand Rapids Department Name Data and Analytics - QSE Employment Type Full time Shift Day (United States of America) Weekly Scheduled Hours 40 Hours of Work 8:00am - 5:00pm Days Worked Monday - Friday Weekend Frequency N/A CURRENT SPECTRUM HEALTH TEAM MEMBERS – Please apply through Find Jobs from your Workday team member account. This career site is for Non-Spectrum Health team members only. Spectrum Health is committed to providing a safe environment for our team members, patients, visitors and community. That is why we require a drug-free workplace and various vaccinations as a requirement for employment. Spectrum Health grants equal employment opportunity to all qualified persons without regard to race, color, national origin, sex, disability, age, religion, genetic information, marital status, height, weight, gender, pregnancy, sexual orientation, gender identity or expression, veteran status, or any other legally protected category. An interconnected, collaborative culture where all are encouraged to bring their whole selves to work, is vital to the health of our organization. As a health system, we advocate for equity as we care for our patients, our communities, and each other. From workshops that develop cultural intelligence, to our inclusion resource groups for people to find community and empowerment at work, we are dedicated to ongoing resources that advance our values of diversity, equity, and inclusion in all that we do. We invite those that share in our commitment to join our team. If you are a qualified individual with a disability, you may request assistance in completing the application process by calling 616.486.7447. We are committed to granting reasonable accommodations in accordance with applicable laws.