Ensemble is a leading provider of technology-enabled revenue cycle management solutions for health systems, including hospitals and affiliated physician groups. They offer end-to-end revenue cycle solutions as well as a comprehensive suite of point solutions to clients across the country. Ensemble keeps communities healthy by keeping hospitals healthy, empowering their people to challenge the status quo and deliver exceptional experiences. The Senior Business Intelligence Engineer solves complex business problems using data from internal and external sources to provide insight to decision-makers, working on moderately complex to complex issues requiring in-depth evaluation of variable factors.
Responsibilities
- Manage big data and create solutions for reporting requirements provided by stakeholders
- Solve problems and complete root cause analysis on production bugs
- Follow standard SDLC process and agile practices within a team
- Develop internal and external partnerships to provide opportunity for efficient solutions to various data, system, and application uses
- Serve as a technical resource and mentor to other developers/Engineers and aid in troubleshooting and resolving issues
- Actively review new bugs reported and complete grooming and sprint planning
- Complete bug root cause analysis and work with other teams as needed to resolve issues
- Complete documentation and notification to the bug reporter at least twice per week
- Act as a subject matter expert (SME) of report data modeling, including knowledge of data fields and their appropriate uses for reporting
- Collect, organize, and disseminate significant amounts of information with attention to detail and accuracy through Power BI report development
- Responsible for data mining, manipulation, and delivery to key stakeholders and executives in accordance with priorities and deadlines
- Form key relationships with and deliver professional, customer-focused service to key stakeholders and executives
- Lead the evaluation of current and future data needs and translate needs to stakeholders and product owners to support all lines of business
- Lead high-level discussions with a focus on making recommendations and identifying how data can support key business decisions
- Identify report requirements and determine how the desired results can be achieved
- Develop and maintain strategic reports out of multiple databases and systems
- Complete systems validation for client data, identifying discrepancies in data totals or primary keys (PK’s)
- Work with team members as a mentor and provide opportunities for open collaboration to problem-solve or optimize reports
- Complete code review/peer review of completed work by co-developers and provide feedback identifying issues or required report updates to meet requirements ahead of UAT
- Present and/or publish completed reports in accordance with publishing guidelines
Requirements
- 3-5 years experience with relational databases and advanced T-SQL (ability to write complex, highly-optimized queries for data cleansing across large volumes of data)
- 3-5 years experience developing Power BI reports (with M, SQL, DAX language proficiency)
- 5+ years of healthcare revenue cycle experience
- 1+ years of knowledge and/or experience with ETL and Azure data warehouse concepts and processes
- Building and maintaining APIs
- Advanced Vertipaq, Dax Studio, Tabular Editor experience
- Advanced SQL concepts and validation review between data source and report output
- Power Apps integration
- Excellent communication, organizational, planning, problem-solving, analytical, judgment, and research skills
- Ability to own and resolve problems
- Must be inquisitive and demonstrate openness to innovation, including AI, to explore better processes and ways to alleviate friction and improve patient and client experiences
- Must be willing and able to travel to and work onsite at client, temporary, or corporate office locations as business needs require
Nice to have
- Experience with Azure Databricks
Benefits
- Comprehensive benefits package designed to support physical, emotional, and financial health (healthcare, time off, retirement, well-being programs)
- Professional development investment, including earning a professional certification relevant to the field and tuition reimbursement
- Quarterly and annual incentive programs for employees who go beyond expectations
- Work-life flexibility
- Culture rooted in collaboration, growth, and innovation
- Recognition programs for raising the bar
Additional details
- Ensemble’s O.N.E Purpose: Customer Obsession, Embracing New Ideas, Striving for Excellence
- Ensemble Difference Principles and 'Best in KLAS' standards
- Equal employment opportunity employer with non-discrimination and anti-harassment policies
- Provides reasonable accommodations to qualified individuals with disabilities in accordance with the ADA and applicable laws
- Compensation decisions consider factors such as geographic location, knowledge, skills, experience, education, licensure, internal equity, and time in position
- Originally posted on Himalayas
Zobhira
