Analyst, Reporting

MissionOne Media; Kansas City, Denver, Chicago, New York (MO, CO, IL, NY); Hybrid; USD 65,000 - 90,000; Full time

Job summary

MissionOne Media is seeking a detail-oriented Analyst to design, build, and maintain interactive dashboards for clients and internal teams. You will ensure data accuracy and performance while translating complex data into clear visuals.

Responsibilities include creating production-grade dashboards, collaborating with stakeholders on KPI definitions, and supporting data quality and documentation efforts across projects.

Qualifications

• 0-2 years in data analytics, BI, or reporting roles.
• Strong record of academic and/or professional achievement.
• Sharp attention to UI/UX formatting, alignment, color consistency, and readability across dashboards.
• Data analysis experience including Excel and SQL platforms.
• Effectiveness in managing multiple projects across multiple clients and stakeholders.
• Understands user personas to design dashboards that non-technical users find intuitive.
• Familiarity with relational databases or cloud data warehouses.

Responsibilities

• Design, build, and optimize interactive, production-grade dashboards and reports using BI tools Tableau, PowerBI and Looker.
• Collaborate with cross-functional stakeholders to define KPI metrics and reporting requirements.
• Partner with growth, sales, and account teams to design mockups, POC dashboards, and data visual stories for new client pitches.
• Deliver fast-turnaround visual concepts that convey complex capabilities into clear value propositions for external buyers.
• Maintain dashboard data models, automated refresh schedules, and row-level security for executive and operational dashboards.
• Support QA to identify data anomalies and collaborate with Data Engineering to remediate source issues.
• Build and maintain a centralized data dictionary, KPI definitions log, and technical documentation for all business reports.
• Support standardized guidelines for dashboard design, naming conventions, and data validation rules.

Skills

Data analytics

SQL

Excel

Dashboard design

UI/UX attention

Tools

Tableau

Power BI

Looker

Job description

Kansas City, MO; Denver, CO; Chicago, IL; New York, NY; Remote

We are looking for a detail-orientedAnalyst, reporting to design, build, and maintain interactive client and internal dashboards while ensuring the underlying data meets strict accuracy and performance standards. In this role, you will bridge the gap between complex raw data and visual insights, performing end-to-end data quality assurance, developing automated reports, and translating business requirements into clear analytical visuals.

Key Responsibilities:

• Design, build, andoptimizeinteractive, production-grade dashboards and reports using BI tools Tableau,PowerBIandLooker.
• Collaborate with cross-functional stakeholders to define KPI metrics and reporting requirements.
• Partner with growth, sales, and account teams to design compelling mockups, proof-of-concept (POC) dashboards, and data visual stories for new client pitches.
• Deliver fast-turnaround visual concepts that turn complex capabilities into easy-to-understand value propositions for external buyers.
• Maintaindashboard data models, automated refresh schedules, and row-level security for executiveand operational dashboards.
• Support QA toidentifydata anomalies and collaborate with Data Engineering toremediate underlying source issues.
• Build andmaintaina centralized data dictionary, KPI definition log, and technical documentation for all business reports.
• Supportstandardizedguidelines for dashboard design, naming conventions, and data validation rules.

Qualifications:

• 0-2 years in data analytics, business intelligence, or reporting roles.
• Strong record of academic and/or professional achievement
• Sharp attention to UI/UX formatting, alignment, color consistency, and readability across dashboards.
• Dataanalysis experience including spreadsheet (Excel) and SQL platforms
• Effectiveness in managing multiple projects across multiple clients and stakeholders
• Understands user personas to design dashboards that non-technical users find intuitive and easy to adopt
• Familiarity with relational databases or cloud data warehouses

As set forth in MissionOne Media’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.