Overview:
Medxcel is here to lead the transformation of healthcare facilities management by incorporating a new approach to providing services. Created by healthcare, for healthcare, we have a dedicated focus on our people and customers, as well as providing tools, processes, support resources, data analytics and insource strategies that drive results.
Business Intelligence Analyst I works with various stakeholders to understand business issues and recommend approaches to ensure business questions are answered properly while working out of the Central Office - Indianapolis, IN. This position will use data manipulation tools to analyze data and identify trends; update and maintain the data warehouse structure and integrity. The position plays a key role in the standardization of data integrity and the use of data to drive decision-making for continuous improvement of operational performance. Proactively participates in and makes recommendations for system refinements within the finance function of the organization.
Responsibilities:
- Assist with the curating enterprise BI governance materials.
-
Provide technical support as needed within the team and amongst users.
-
Manage daily/weekly/monthly analytics reporting to enable the business to operate transparently and efficiently while capitalizing on insights to track revenue and expense and provide.
-
Support the preparation of weekly, monthly and quarterly reports for the business, including consolidating KPIs and metrics across our business.
-
Help design executive dashboards for data-informed decision making.
-
Identify business trends utilizing real-time data, compile analysis reports that are delivered to users and then follow up on results.
-
Customize views for commonly queried data sets and other applications for utilization and quick data retrieval.
-
Look for trends in reported issues and create long-term solutions vs. short-term fixes.
-
Perform Intermediate level data mining and data modeling by combining multiple data sources from various systems and databases using BI tools.
-
Manage and execute small analytics projects and project tasks.
-
End to end execution of metric and dashboard creation.
-
Must be comfortable working with large amounts of data.
-
Ability to work individually and in a team-oriented, collaborative environment.
-
Strong skills in Microsoft Office programs.
-
Strong verbal and written communication skills.
-
Ability to work on multiple projects simultaneously and translate data into digestible information to improve corporate processes.
-
Write SQL queries and stored procedures for reports and dashboard development.
-
Proficiency SQL (DML, DDL, DCL, commands), Dashboards and Business Intelligence Tools(Tableau, Power BI, etc) and Excel (pivot tables, charts, advanced formulas, data imports, etc.).
-
Understanding of relational databases and familiarity with statistics.
-
Understanding of Financial data and KPIs to help provide reports to drive answers.
-
Ability to communicate effectively with both business and technical teams.
-
Inquisitive mindset, with exceptional problem-solving ability along with a passion for big data.
-
Ability to quickly adapt to changing priorities and generate innovative solutions in a fast-paced environment.
-
Experience running projects to analyze business issues or challenges.
Qualifications:
Education:
-
Bachelor's degree in Business, IT, Applied Statistics, Data Science, Data Analytics or related field required.
-
Master's degree in Business Administration, Data Science or Data Analytics preferred.
Experience:
-
At least three years relevant work experience in Data Science, Business Analytics, Finance, Business Intelligence (BI), or a comparable position handling large, complex data required.
Competencies:
- Problem solving — identifies and resolves problems in a timely manner and gathers and analyses information skillfully.
-
Planning/organizing —prioritizes and plans work activities, uses time efficiently and develops realistic action plans.
-
Ability to Adapt –adapt quickly to changes in scope or direction and be flexible to adopting changes quickly.
-
Excellent communication and interpersonal skills with ability to communicate and present to all levels of the organization, on the topics of technology, tools, and processes.
-
Ability to deal effectively with diverse roles, backgrounds, and expectations.
-
Project management skills including coordination, communication and adherence to budget and completion goals, prioritization, and troubleshooting.
-
Flexible and adaptable; able to work in ambiguous situations.
#MFMCORP