POSITION SUMMARY:
The Finance Business Intelligence Developer develops dashboards, reports, and metrics for BMC Finance and Operations. This position is vital in helping hospital leadership understand the financial health of the hospital via intelligent, interactive reporting. The Finance Business Intelligence Developer will help overhaul existing Excel reports and recreate them in business intelligence software. This position will be responsible for planning, designing, coordinating and developing highly interactive dashboards with built-in guided analytics for various lines of business using shared data infrastructure.
Position: Finance Business Intelligence Developer
Department: BMC Finance Support
Schedule: Full Time
ESSENTIAL RESPONSIBILITIES / DUTIES:
Manage the life cycle of advanced reporting and business intelligence analytics dashboards, including business requirements gathering, functional specification write-up, prototyping, development, quality testing, user acceptance testing, roll-out and post-launch enhancements implementation
Understand (and reverse-engineer as necessary) existing excel reports and then create reliable, validated reporting solutions in Tableau that enable users to obtain actionable insights quickly and efficiently.
Develop reporting solutions consistent with overall data governance principles that establish Finance analytics as a source of truth within the BMCHS.
Develop reporting solutions that integrate “drill to details,” validation logic checks, and data definitions into the visual reporting, enabling subject matter experts to assist in troubleshooting of visual reporting and substantiate reported summary data.
Define and document key terms within reports; translate report language to users where applicable
Use design best practices in data visualization that promote user friendly and high-quality products
Incorporate features such as KPIs, Heat Maps, Scatterplots, Bar Charts, Slicers, Drill down, Drill up, etc.
Create interactive filters, parameters, and calculations
Follow consistent design principles to create reporting solutions across multiple requests from different stakeholders
Provides report creation/debug assistance when required
Identify and define system errors and/or deficiencies
Use experience with SQL to identify sources of data inconsistencies, troubleshoot problems to root cause, and resolve issues when possible
Assist Performance Management department in defining and developing new Key Performance Indicators (KPIs) and dashboards
Evaluate new technologies for potential implementation including development of business justification and project implementation planning, when appropriate
Build and publish interactive dashboards on Tableau Server. Manage and follow consistent analytics development lifecycle: dev/test/prod.
Work cross-functionally with Finance teams, IT Services, and System Analytics to collaborate on reporting solutions that involve clinical, performance, quality, and other operational data.
Adhere to all of BMC’s RESPECT behavioral standards
(The above statements in this job description are intended to depict the general nature and level of work assigned to the employee(s) in this job. The above is not intended to represent an exhaustive list of accountable duties and responsibilities required).
JOB REQUIREMENTS
EDUCATION:
Bachelor's degree required; Data Science-related degree preferred
CERTIFICATES, LICENSES, REGISTRATIONS REQUIRED:
None required
Epic Certification (Caboodle, Clarity, Revenue Data Models) preferred
Tableau certification preferred
EXPERIENCE:
At least 3 years of experience working with large, complex data sets required
PL/SQL and TSQL programming knowledge required; experience writing SQL queries on large relational databases with multiple joins and using basic SQL to troubleshoot and validate data sources
Hands on experience with Tableau Desktop (dashboard creation, report authoring and troubleshooting, data source management) preferred
Experience with healthcare finance; understanding of key financial concepts and their relation to healthcare.
Experience with healthcare operations and basic familiarity with health data informatics, e.g. CPT, DRG codes, etc.
Experience in using Data Analytical & Visualization Tools (Tableau preferred)
KNOWLEDGE, SKILLS & ABILITIES (KSAs):
Advanced MS Excel and PL/TSQL skills required; ability to convert existing queries and move them between environments
Demonstrated ability to turn raw data into actionable reporting and analysis
Demonstrated ability to work with members of management
Good understanding of DataMart/Data warehouse concepts
Excellent knowledge of calculated fields, parameter controls, hierarchy, groups, sets, dashboard actions, filters, annotations etc.
Good knowledge of Enterprise Data Warehousing (EDW), dimensional modelling and design, Analytics, Enterprise Dashboard, Key performance Indicators (KPIs), Data Quality, Master Data Management and Data governance best practices
Required interpersonal skills to deal effectively with all levels of management
Able to communicate with ITS on our various data/server needs
Ability to build strong relationships across the organization and collaborate effectively with other departments both inside and outside Finance
Excellent written and verbal communication skills
Detail-oriented and ability to learn and work independently as well as in a team environment
Equal Opportunity Employer/Disabled/Veterans
According to the FTC, there has been a rise in employment offer scams. Our current job openings are listed on our website and applications are received only through our website. We do not ask or require downloads of any applications, or “apps” job offers are not extended over text messages or social media platforms. We do not ask individuals to purchase equipment for or prior to employment.
Similar Jobs
What We Do
Boston Medical Center, located in Boston’s historic South End, is a private, not-for-profit, 567-bed, academic medical center and the primary teaching affiliate for Boston University School of Medicine. Recognized for its high-quality, nationally ranked and comprehensive medical care for the entire family, patients have access to the most current treatment and advancements at BMC. BMC physicians lead the way in pioneering new therapies that impact the care of patients locally and worldwide. In 2013, BMC made the decision to invest in a four-year campus redesign that includes additions to buildings, upgrades to existing structures, and an expansion of the Emergency Department. Once completed, the redesign will provide clinical workspaces with state-of-the-art facilities and equipment to solve BMC's most pressing care delivery needs. Already complete, the hospital’s Shapiro Center is Boston’s newest outpatient care facility and features a quarter-million square feet of clinic space, key support services, one of the region’s most technologically advanced pharmacies, and a bright, spacious café. Housed in a facility that provides world-class, patient-centered care at every visit, BMC doctors are among the best in their field. Many are recognized annually as “Top Doctors” in their medical and surgical specialties by publications such as U.S. News & World Report and Boston magazine. Boston Medical Center is also the largest safety net hospital in New England and extends into the community as a founding partner of Boston HealthNet, a network of 15 community health centers throughout Boston serving more than a quarter million people annually. No matter whom you meet at BMC, all are committed to providing every patient and family member with the highest quality of care, respect, warmth and compassion.
