Senior Engineer, Business Intelligence

About the role

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, emphasizing that every touch should be meaningful and that people are the most important part of who they are.

Essential Job Functions

• Manage big data and create solutions for reporting requirements provided by stakeholders.
• Solve complex business problems and issues using data from internal and external sources to provide insight to decision-makers.
• Perform root cause analysis on production bugs and follow standard SDLC processes and agile practices within a team.
• Develop internal and external partnerships to provide efficient solutions for various data, system, and application uses.
• Serve as a technical resource and mentor to other developers/engineers, aiding in troubleshooting and resolving issues.
• Review new bugs reported, complete grooming and sprint planning, and perform root cause analysis, documenting and notifying bug reporters at least twice per week.
• Act as a subject matter expert (SME) of report data modeling, understanding each field’s use and determining appropriate data field applications for reporting.
• Demonstrate advanced knowledge and skills with secondary tools such as Microsoft Azure, SQL data warehouse, Visual Studio, etc.
• Possess advanced programming and optimizing skills in DAX, DAX Studio, Performance Analyzer, Vertipaq, SQL, and M languages.
• 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, translating them to stakeholders and product owners to support all lines of business.
• Lead high-level discussions focused on making recommendations and identifying how data can support key business decisions.
• Identify report requirements and determine how desired results can be achieved.
• Develop and maintain strategic reports from multiple databases and systems.
• Complete systems validation for client data, identifying discrepancies in data totals or primary keys.
• Mentor team members and provide opportunities for open collaboration to problem-solve or optimize reports.
• Apply practical experience with DAX Studio and Performance Analyzer to optimize reporting based on analysis findings.
• Conduct code reviews/peer reviews of completed work by co-developers, providing feedback to identify issues or required report updates before moving to UAT.
• Present and/or publish completed reports in accordance with publishing guidelines.

Required Experience

• 3–5 years of experience with relational databases and advanced T-SQL, including the ability to write complex, highly-optimized queries for data cleansing across large volumes of data.
• 3–5 years of experience developing Power BI reports with proficiency in M, SQL, and DAX languages.
• 5+ years of healthcare revenue cycle experience required.
• 1+ years of knowledge and/or experience with ETL and Azure data warehouse concepts and processes (experience with Azure Databricks is a plus).
• Experience building and maintaining APIs.
• Advanced Vertipaq, DAX Studio, and Tabular Editor experience.
• Advanced SQL concepts and validation review between data source and report output.
• Power Apps integration experience.
• Excellent communication, organizational, planning, problem-solving, analytical, judgment, and research skills.
• Ability to own and resolve problems; inquisitive and open to innovation, including AI, to explore better processes and improve patient and client experiences.
• Willingness and ability to travel to and work onsite at client, temporary, or corporate office locations as business needs require.

Pay

This position pays between $91,400 and $175,200 based on experience.