Sales Reporting Analyst

Medical Mutual employees must submit their applications through MySource.

Note:
This is a hybrid role requiring 3 days per week on-site in our Brooklyn, Ohio office.

Founded in 1934, Medical Mutual is the oldest and one of the largest health insurance companies based in Ohio. We provide peace of mind to more than 1.2 million members through our high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement, and individual plans.

Key contributor to the design and development of sales reporting for sales leadership and executive management to monitor performance, understand the current state of our business and the results of our sales efforts.

• Assists in the design and build of interactive dashboards and reports in Power BI or other reporting tools for sales leadership and executive management. Assists in maintaining data integrity and performing data quality checks to ensure accurate reporting.
• Prepares monthly reporting and performs analytical review of completed reports and assumes responsibility for overall accuracy.
• Assists in extracting and reporting information on data from various sources in support of sales division needs. Writes basic queries to obtain data for reporting or ad hoc requests.
• Collaborates with all sales teams to understand their data and reporting needs and contributes to the delivery of relevant reporting solutions.
• Documents reporting processes, methodologies, and data sources to ensure consistency and transparency.
• Learns and utilizes business intelligence tools and technologies for reporting. Participates in team meetings and training sessions to enhance technical skills.
• Performs other duties as assigned.
• Designs and builds basic interactive dashboards and reports in Power BI or other reporting tools for sales leadership and executive management. Maintains data integrity and perform data quality checks to ensure accurate reporting.
• Prepares monthly reporting and perform analytical review of completed reports to assure reasonableness and accuracy.
• Extracts and reports on data from various sources in support of sales division needs. Writes queries to obtain data for reporting or ad hoc requests.
• Contributes and collaborates with all sales teams to understand their data and reporting needs and contributes to the delivery of relevant reporting solutions.
• Continuously improves reporting processes and tools to enhance efficiency and effectiveness.
• Documents reporting processes, methodologies, and data sources to ensure consistency and transparency
• Performs other duties as assigned.
• Designs, builds, and maintains complex, interactive dashboards and reports in Power BI or other reporting tools, that provide clear and actionable insights. Maintains data integrity and performs data quality checks to ensure accurate reporting.
• Utilizes advanced data analytics techniques to extract meaningful insights from complex datasets, guiding strategic decision-making across the organization. Establishes and monitors key performance indicators (KPIs) to track Sales performance and identify areas for improvement.
• Creates data models that support reporting and analytics needs while ensuring data integrity and accuracy.
• Stays at the forefront of industry best practices and emerging trends in business intelligence, reporting tools, and data analytics, driving innovation within the team.
• Generates regular and ad-hoc sales reports, dashboards, and presentations for senior management.
• Provides leadership and mentorship to a team of Sales reporting analysts fostering a culture of innovation and excellence.
• Performs other duties as assigned.