newance
Business Intelligence Analyst
newance, Milwaukee, Wisconsin, United States, 53244
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 joinso Prepare technical specifications and documentation for Alteryx workflows supporting BI reportso Perform end to end Data validationo Identification and development of hospital client's baseline revenue cycle vendor performanceo Customization and development of Healthfuse's client reporting packageso Research and analysis of the quantitative and qualitative performance of healthcare revenue cycle vendors throughout the industryo Creating monthly inventory reconciliation reporting packageo Lead the organization's efforts with regards to vendor profiling, analysis, and new client sourcing needs
Required Qualificationso Bachelor's Degree is preferred. Work Experience will be considered in lieu of a degreeo Strong analytical, problem-solving, and troubleshooting abilitieso High data analytics and strong problem-solving skillso Advanced Microsoft Excel skillso Knowledge of MSSQL, Azureo Knowledge of Alteryxo Knowledge of Tableau or PowerBI
Desired Qualificationso 1+ years of experience using MSSQL, Azureo 1+ years of related experience with Alteryxo 1+ years of experience using BI tools such as Tableau or PowerBIo Healthcare and Revenue Cycle Management experience preferredo Action-oriented, independent, and self-motivatedo Ability to work in a high activity/fast paced environmento Project management skills, ability to define and manage processes and projects, making recommendations for improvement when necessaryo Possesses excellent organizational skills and ability to work independently and with a team.o Strong business analytics acumeno Strong written communication skills, including the ability to facilitate meetings and effectively leaddiscussions.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 processeso Considers data quality, accuracy, and truth in reporting fundamental and critical for successo Passionate about data and problem-solving and driven to achieve great results for customerso Aspires to present data research in compelling and insightful wayso 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
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 joinso Prepare technical specifications and documentation for Alteryx workflows supporting BI reportso Perform end to end Data validationo Identification and development of hospital client's baseline revenue cycle vendor performanceo Customization and development of Healthfuse's client reporting packageso Research and analysis of the quantitative and qualitative performance of healthcare revenue cycle vendors throughout the industryo Creating monthly inventory reconciliation reporting packageo Lead the organization's efforts with regards to vendor profiling, analysis, and new client sourcing needs
Required Qualificationso Bachelor's Degree is preferred. Work Experience will be considered in lieu of a degreeo Strong analytical, problem-solving, and troubleshooting abilitieso High data analytics and strong problem-solving skillso Advanced Microsoft Excel skillso Knowledge of MSSQL, Azureo Knowledge of Alteryxo Knowledge of Tableau or PowerBI
Desired Qualificationso 1+ years of experience using MSSQL, Azureo 1+ years of related experience with Alteryxo 1+ years of experience using BI tools such as Tableau or PowerBIo Healthcare and Revenue Cycle Management experience preferredo Action-oriented, independent, and self-motivatedo Ability to work in a high activity/fast paced environmento Project management skills, ability to define and manage processes and projects, making recommendations for improvement when necessaryo Possesses excellent organizational skills and ability to work independently and with a team.o Strong business analytics acumeno Strong written communication skills, including the ability to facilitate meetings and effectively leaddiscussions.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 processeso Considers data quality, accuracy, and truth in reporting fundamental and critical for successo Passionate about data and problem-solving and driven to achieve great results for customerso Aspires to present data research in compelling and insightful wayso 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