newance
Business Intelligence Analyst Job at newance in Milwaukee
newance, Milwaukee, WI, United States
Healthfuse is a financial services and technology company that serves hospitals and health systems nationwide. We help healthcare executives protect and strengthen their bottom-line so they can focus on creating healthier patient communities. We do this by helping them better source and manage their vendors, and revenue cycle strategy, to reduce cost, improve performance, enhance transparency, and correct issues.
What You'll Love About Working at Healthfuse
•Future 50 Wisconsin growth company
•Mission-driven and strong company culture that strives to positively impact our employees, clients, company, industry, and community
•Fast-paced, innovative, ever-learning, and adapting organization
•Multiple professional development and advancement opportunities
•Interact with c-suite executives - within Healthfuse and hospitals nationally
•High-growth and recession-proof industry
•Disruptive solution provider driving improvement in the healthcare market
•Great benefits; competitive salary and bonus, medical, dental, vision, and 401k with company match, generous paid time off, and flex-time schedules
JOB SUMMARY
The Business Intelligence Analyst assists in streamlining internal and client processes through automation and data visualization. The BI Analyst uses Healthfuse systems and software to analyze industry and client-specific data for the purpose of making business process improvements, and contract negotiation recommendations to internal resources and external clients, as well as demonstrating engagement value and vendor performance.
CORE RESPONSIBILITIES
o Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)
o Write Complex SQL queries on multiple tables using complex joins
o Prepare technical specifications and documentation for Alteryx workflows supporting BI reports
o Perform end to end Data validation
o Identification and development of hospital client's baseline revenue cycle vendor performance
o Customization and development of Healthfuse's client reporting packages
o Research and analysis of the quantitative and qualitative performance of healthcare revenue cycle vendors throughout the industry
o Creating monthly inventory reconciliation reporting package
o Lead the organization's efforts with regards to vendor profiling, analysis, and new client sourcing needs
Required Qualifications
o Bachelor's Degree is preferred. Work Experience will be considered in lieu of a degree
o Strong analytical, problem-solving, and troubleshooting abilities
o High data analytics and strong problem-solving skills
o Advanced Microsoft Excel skills
o Knowledge of MSSQL, Azure
o Knowledge of Alteryx
o Knowledge of Tableau or PowerBI
Desired Qualifications
o 1+ years of experience using MSSQL, Azure
o 1+ years of related experience with Alteryx
o 1+ years of experience using BI tools such as Tableau or PowerBI
o Healthcare and Revenue Cycle Management experience preferred
o Action-oriented, independent, and self-motivated
o Ability to work in a high activity/fast paced environment
o Project management skills, ability to define and manage processes and projects, making recommendations for improvement when necessary
o Possesses excellent organizational skills and ability to work independently and with a team.
o Strong business analytics acumen
o Strong written communication skills, including the ability to facilitate meetings and effectively lead
discussions.
o Ability to build and maintain effective working relationships with all levels of management & staff.
o Ability to problem solve, iteratively & incrementally improving products and processes
o Considers data quality, accuracy, and truth in reporting fundamental and critical for success
o Passionate about data and problem-solving and driven to achieve great results for customers
o Aspires to present data research in compelling and insightful ways
o Ability to analyze large volumes of raw data, package the data for further consumption, draw conclusions, and develop actionable recommendations
o Self-starter, well organized, extremely detail-oriented, and a highly collaborative team member
What You'll Love About Working at Healthfuse
•Future 50 Wisconsin growth company
•Mission-driven and strong company culture that strives to positively impact our employees, clients, company, industry, and community
•Fast-paced, innovative, ever-learning, and adapting organization
•Multiple professional development and advancement opportunities
•Interact with c-suite executives - within Healthfuse and hospitals nationally
•High-growth and recession-proof industry
•Disruptive solution provider driving improvement in the healthcare market
•Great benefits; competitive salary and bonus, medical, dental, vision, and 401k with company match, generous paid time off, and flex-time schedules
JOB SUMMARY
The Business Intelligence Analyst assists in streamlining internal and client processes through automation and data visualization. The BI Analyst uses Healthfuse systems and software to analyze industry and client-specific data for the purpose of making business process improvements, and contract negotiation recommendations to internal resources and external clients, as well as demonstrating engagement value and vendor performance.
CORE RESPONSIBILITIES
o Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)
o Write Complex SQL queries on multiple tables using complex joins
o Prepare technical specifications and documentation for Alteryx workflows supporting BI reports
o Perform end to end Data validation
o Identification and development of hospital client's baseline revenue cycle vendor performance
o Customization and development of Healthfuse's client reporting packages
o Research and analysis of the quantitative and qualitative performance of healthcare revenue cycle vendors throughout the industry
o Creating monthly inventory reconciliation reporting package
o Lead the organization's efforts with regards to vendor profiling, analysis, and new client sourcing needs
Required Qualifications
o Bachelor's Degree is preferred. Work Experience will be considered in lieu of a degree
o Strong analytical, problem-solving, and troubleshooting abilities
o High data analytics and strong problem-solving skills
o Advanced Microsoft Excel skills
o Knowledge of MSSQL, Azure
o Knowledge of Alteryx
o Knowledge of Tableau or PowerBI
Desired Qualifications
o 1+ years of experience using MSSQL, Azure
o 1+ years of related experience with Alteryx
o 1+ years of experience using BI tools such as Tableau or PowerBI
o Healthcare and Revenue Cycle Management experience preferred
o Action-oriented, independent, and self-motivated
o Ability to work in a high activity/fast paced environment
o Project management skills, ability to define and manage processes and projects, making recommendations for improvement when necessary
o Possesses excellent organizational skills and ability to work independently and with a team.
o Strong business analytics acumen
o Strong written communication skills, including the ability to facilitate meetings and effectively lead
discussions.
o Ability to build and maintain effective working relationships with all levels of management & staff.
o Ability to problem solve, iteratively & incrementally improving products and processes
o Considers data quality, accuracy, and truth in reporting fundamental and critical for success
o Passionate about data and problem-solving and driven to achieve great results for customers
o Aspires to present data research in compelling and insightful ways
o Ability to analyze large volumes of raw data, package the data for further consumption, draw conclusions, and develop actionable recommendations
o Self-starter, well organized, extremely detail-oriented, and a highly collaborative team member