Data Analyst

Medical Service Company•Cleveland, OH

About The Position

At MSC, we are dedicated to enhancing patient comfort and quality of life with over 75 years of experience and accredited by the Accreditation Commission for Health Care (ACHC). MSC is a 13 -Time recipient of the prestigious NorthCoast 99 Award as a Top Workplace to work! MSC is a two-time recipient of the prestigious National HME Excellence Award for Best Home Medical Equipment company in the US. In addition, MSC is very proud to announce its debut on the Inc. 5000 list in 2024, marking a significant milestone in our company's growth and success! Apply today to become a part of our dynamic team! Competitive Pay, C ommissions, Auto & Mileage Reimbursement Advancement Opportunities Medical, Dental & Vision Insurance HSA Account w/Company Contribution Pet Insurance Company provided Life and AD&D insurance Short-Term and Long-Term Disability Tuition Reimbursement Program Employee Assistance Program (EAP) Employee Referral Bonus Program Social Recognition Program Employee Engagement Opportunities CALM App 401k (with a matching program) / Roth IRA Company Discounts Payactiv/On-Demand Pay Paid vacation, Sick Days, YOU (Mental Health) Days and Holidays The Data Analyst works as an integral member of the IT and data teams. The Data Analyst supports MSC’s growing reporting, data analysis, and data visualization efforts, expanding our existing reporting, Business Intelligence (BI), and data mining capabilities. The Data Analyst will help to strengthen MSC’s capacity to make data-driven decisions. The Data Analyst will support projects and partnerships across the organization to identify and address existing and new reporting and data analysis and data modeling needs.

Requirements

Undergraduate degree in data science, information systems, quantitative field (mathematics, statistics, engineering) or equivalent certification or experience.
Proficient with Power BI to create dashboards and data visualizations.
Proficient with Microsoft Excel to perform reporting and advanced analysis.
Ability to work with data in a variety of formats (JSON, XML, SQL, HTML, Text).
Proficient at SQL and able to automate, extract, and analyze data from relational databases.
Knowledge of data warehousing concepts and business intelligence best practices.
Track-record of problem solving and ability to work both independently and with a team.
Excellent communication, writing, and presentation skills.
Strong understanding of statistical and mathematical concepts.

Responsibilities

Use Microsoft Power BI and Microsoft Excel to extract, prepare, and send key data to business stakeholders.
Create scorecards and dashboards to evaluate company performance.
Support the organization’s efforts to expand capabilities and utilization of data analysis and BI tools.
Develop analysis and data visualizations to support organizational analytical needs using all available data sources.
Work with key stakeholders to understand business problems or questions. Translating them into analysis, reports, and visualizations which are actionable and understandable.
Prepare ad-hoc data requests as requested by team members.
Miscellaneous assignments/projects as needed.