Logo
Exact Medicare

Data Analyst

Exact Medicare, Westerville, Ohio, United States, 43082

Save Job

About Exact Medicare

Company Overview At Exact Medicare, we are committed to creating a superior client experience by understanding and caring for our customers so well that they would never think about leaving us-and want to tell everyone about us! Our team members are empowered by our core values, which drive everything we do.

Our Core Values

Extreme Ownership:

We take ownership of our actions and responsibilities, delivering the best possible results for our clients. Above Reproach:

We uphold the highest standards of integrity and ethics in all interactions and decisions. Culture of Candor:

We foster a culture of open and honest communication, valuing ideas and feedback to continuously improve. Atomic Growth:

We are committed to continuous personal and organizational growth to better serve our clients and community. Position Overview

We're seeking a

Data Analyst

to join our growing Data Analytics and Reporting team. This newly created role will support key 2026 data initiatives, including enhanced reporting on commission audits, B2B setup, and other strategic data projects. The ideal candidate will be skilled at designing and implementing data-driven solutions that support decision-making across the organization.

You'll play a critical role in building and maintaining data pipelines, developing automated reporting, and uncovering insights that drive process improvements. This position offers the opportunity to help shape new analytics frameworks and optimize existing systems during an exciting phase of data transformation.

Key Responsibilities

Design, develop, and implement data pipelines for processing and analyzing Medicare insurance commissions data, ensuring data accuracy and efficiency. Work closely with Sales, Finance, and Commissions teams to understand business requirements and deliver data solutions that meet those needs. Develop and automate

ETL (Extract, Transform, Load)

processes to ensure seamless data integration from multiple sources (e.g., CRM systems, billing systems, spreadsheets). Conduct data analysis to identify trends, discrepancies, or issues related to payouts, calculations, and performance metrics. Build and maintain

Power BI dashboards and reports

to visualize metrics, performance, and trends. Provide actionable insights and recommendations for improving data processes, identifying areas for optimization, and aligning with business goals. Collaborate with cross-functional teams to ensure data consistency, accuracy, and compliance. Perform ad hoc analyses to address business queries and provide insights into commission-related patterns. Create and maintain documentation for all data processes, models, and systems used. Skills and Qualifications

Bachelor's degree

in Data Science, Computer Science, Business Analytics, or a related field. 2+ years of experience

as a Data Analyst , preferably within the insurance industry or a Medicare-related environment. Proficiency in

SQL

and database management (e.g., MySQL, PostgreSQL, or similar). Experience with

ETL processes

and managing large, complex datasets. Strong proficiency in

Power BI

or other visualization tools. Experience with

Python

(or R) for data analysis, automation, and process optimization. Familiarity with

cloud-based data environments

such as AWS, Azure, or Google Cloud. Excellent analytical and problem-solving skills with strong attention to detail. Strong communication skills, with the ability to translate complex data insights into clear, actionable business recommendations. Demonstrated ability to work collaboratively across departments to support evolving data needs.

Work Environment

This is a

full-time, hybrid position

, offering flexibility to work remotely while maintaining regular collaboration with in-office team members.

About the Role

This is an exciting opportunity for an analytical thinker who thrives in a dynamic environment. You'll contribute directly to shaping how our organization captures, processes, and leverages data to drive success. As we continue to enhance and integrate new systems, your work will help streamline reporting processes and ensure our teams have the insights they need to make informed decisions.