Analyst, Data and Reporting

Living the vision of Advancing the business of healthcare today for a better tomorrow Medical Group Management Association (MGMA) works to perpetuate success throughout the healthcare industry as the premier association for professionals who lead medical practices. Since 1926 through data people insights and advocacy MGMA empowers medical group practices to innovate and create meaningful change in healthcare. We believe the future is what you make it and were here to support the people who are ready to make the world a better place. Tomorrow will be remarkable because MGMA is here to help.

The Medical Group Management Association (MGMA is looking for an Analyst Data and Reporting to join our Denver/hybrid team.

The ideal candidate will have expertise in data visualization and a strong background in Marketing and Sales analytics and reporting with a passion for transforming data into actionable insights that drive business performance. You will work closely with stakeholders across Marketing Sales and Product to develop dashboards reports and analytical solutions that support decision-making and optimize business outcomes.

Essential Functions

• Design develop and maintain internal dashboards and reports for various business functions with a primary focus on Marketing and Sales. Create technical and business documentation along with report development.
• Translate business requirements into data models dashboards and KPIs that align with strategic goals.
• Prototype and wireframe potential visualization options while refining requirements with business partners.
• Analyze large datasets from multiple sources (CRM systems digital marketing platforms transactional systems) to generate actionable insights.
• Assist in Data Governance and Management activities such as performing data profiling to inform data quality rules assessing existing documentation and designing systems to remediate gaps or short-comings.
• Write test cases and perform test procedures to ensure requirements are met and high quality data is being delivered to our business stakeholders.
• Collaborate with Marketing and Sales teams to measure campaign performance lead conversion customer acquisition and sales pipeline health.
• Conduct exploratory data analysis to identify trends patterns and opportunities.
• Ensure data accuracy consistency and quality across all reports and dashboards.
• Monitor reporting usage and implement fixes as needed.
• Provide ad hoc reporting and analysis support as needed.

Supervisory duties

• None

Knowledge skills and abilities

• Ability to consistently promote support work and act in a manner in support of MGMAs mission vision and values.
• Strong experience building reports and visualizations Microsoft PowerBI experience a plus.
• Strong SQL experience to perform ad-hoc data analysis and data profiling.
• Ability to refine user requirements and guide business users to next-level requirements moving the needle from Descriptive analytics to Diagnostic and Prescriptive analytics.
• Knowledge of typical Sales and Marketing reporting needs such as Full Funnel Analytics Sales Pipeline Health Web Analytics User Activity and Behavior etc.
• Understanding of relational databases.
• Experience in data management and reporting.
• Working knowledge of Customer Relationship Management and Marketing Automation platforms such as Dynamics 365 and Marketo.
• Additional Microsoft stack applications (PowerApps Azure SQL Server) knowledge a plus.
• Strong experience with using agile life-cycle methodologies.
• Ability to communicate effectively both verbally and in writing as well as able to communicate quantitative information in a clear and informative manner.
• Attention to detail and possess the ability to work on multiple initiatives simultaneously.
• Strong operational background excellent customer support and project management skills and proven ability to contribute to a team.
• Ability to work with a dynamic staff and work collaboratively in a fast-paced environment.
• Ability to think analytically and evaluate user needs to create the highest quality solutions and resources.
• Commitment to top quality completion of tasks in a team and independent environment.
• Excellent problem solving and decision-making skills.

Education

• Bachelors Degree in Computer Science Information Systems or related field required.

Experience

• Two (2) or more years of experience developing business intelligence reports using SSRS and PowerBI a plus.
• Two (2) or more years of data analysis experience using SQL.
• Two (2) or more years of experience in marketing and sales analytics role a plus.

An equivalent combination of education and experience may be substituted on a year for year basis.

Additional Requirements/Licenses/Certifications

• Must have reliable transportation.
• Must have a valid drivers license.

Working environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Work is generally performed in an indoor professional office environment.
• May need to travel on occasion on behalf of the organization to attend meetings conferences and learning opportunities.
• This role routinely uses standard office equipment such as computers phones photocopiers fax machines and scanners.
• Regular predictable attendance is required.

Physical Activities

The physical demands described here are representative of those that must be met by employees in this role to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job employee is regularly required to successfully interact and accurately exchange information using the following suite of verbal and non-verbal communication skills critical to expressing oneself and conducting professional interactions on behalf of the business:

• Ability to read write edit
• Ability to converse discuss convey
• Also includes interactive engagement with software applications computer graphics and the ability to conduct internet research.

While performing the duties of this job employee is regularly required to successfully navigate scenarios requiring the following observational abilities:

• Ability to perceive identify recognize
• Ability to detect determine discern judge
• Ability to assess estimate compare

This is a largely sedentary role so employee must be able to remain in a sedentary position while focusing for extended periods of time throughout the workday. Position also requires occasional movement inside the office to access file cabinets printers etc. This role may require setting up moving and configuring IT equipment including computers servers networking devices and peripherals.
While performing the duties of this job employee is regularly required to successfully navigate scenarios requiring the following operational abilities:

• Ability to operate PC/keyboard and other office productivity equipment
• Ability to position self to traverse/navigate around typical office setting
• Able to lift carry and move IT equipment and hardware up to 50 lbs occasionally.
• Able to reach bend kneel and work in various positions when installing or troubleshooting equipment
• Able to pull/push lift open/close grasp/manipulate and transport materials
• Ability to use hand and power tools for equipment installation and cable management

Why Work for Us

MGMA prides itself on providing team members from all walks of life with an inclusive work environment and comprehensive benefits package including medical dental and vision coverage life insurance and both short- and long-term disability. We invest in our employees growth with a 401(k) plan featuring company match profit-sharing and professional development opportunities. We prioritize work-life balance through a hybrid work schedule an employee assistance program and a generous time off package which includes three weeks of vacation 80 hours of sick time and 11 paid holidays. From a flexible spending account and on-site fitness center to volunteer opportunities and tuition assistance MGMA is committed to giving employees a well-rounded and gratifying employment experience.

We are an equal opportunity employer. All applicants shall be considered according to their individual qualifications abilities experience and other employment standards. There will be no discrimination due to gender or gender identity race religion color national origin ancestry age disability sexual orientation veteran/military status or any other basis protected by applicable law.

MGMA does not engage in immigration sponsorship or relation assistance.

The application deadline is November 24 2025. This may be extended in the event additional time is necessary to receive a sufficient number of qualified candidates. The approximate salary range for this position is $65000 - $80000 depending on the skills education and experience of the candidate.

#ZR

#LI-DNI