Senior Data Analyst – Data Discovery & Reporting Assessment

Data Analyst

Location: Reynoldsburg, OH - Hybrid

Duration: Contract

Job Description:

Required skills/experience:

Microsoft SQL Server - 6 years experience

MySQL/MariaDB - 6 years experience

PostgreSQL - 6 years experience

Snowflake environments - 6 years experience

Data Analyst needs to have experience with outcome-driven phases focused on discovery, validation, and actionable recommendations using the above technologies —without emphasizing formal documentation.

Phase I: Data Landscape Discovery and Assessment

Focus: Understand what data exists, where it lives, and its condition.

Conduct stakeholder interviews and working sessions to surface both formal systems (SQL Server, MySQL/MariaDB, PostgreSQL, Snowflake) and informal data sources (spreadsheets, Airtable, SharePoint, etc.).

Conduct an in-depth analysis of the database. Look at the database schemas and data stored in those databases to understand what data is available to work with.

Compile a practical inventory of structured and non-standard data assets, emphasizing how they are used.

Identify overlap, duplication, and conflicting data across systems; clarify likely systems of record versus derivative copies.

Capture key data quality concerns, schema inconsistencies, and implementation nuances that impact reporting and downstream use.

Deliver a concise, working-level summary of findings and observations, suitable for internal translation to executive stakeholders ( not a formal report , but a clear synthesis of insights and risks).

Phase II: Reporting Portfolio Validation and Rationalization

Focus: Evaluate how data is being used and optimize the reporting environment.

Validate and refine the existing report inventory through stakeholder engagement and usage data.

Assess report effectiveness (e.g., actively used, redundant, underutilized, or confusing).

Develop clear disposition recommendations for each report (Keep, Retire, Consolidate, Modify), with practical rationale.

Identify opportunities to consolidate overly specific or duplicative reports into more strategic, multi-use outputs.

Surface gaps, including unanswered business questions and unmet reporting needs.

Document inconsistencies in definitions, metrics, and terminology across teams.

Deliver a concise summary of insights, recommendations, and prioritization guidance to support executive-level decision-making.

In addition to evaluating existing reports, also identify anything that is missing from the list that the client has.

Phase II is based on interviews, working sessions, and actionable summaries—again client does not want a heavy written deliverable but still needs structured, defensible outcomes.

For both Phases, the client does need a comprehensive report on the data - just don't need it to be packaged into a nice format that would typically be presented to an exec team. They want the executive summary, but also want the underlying analysis and results so they can look through the supporting documentation to plan their next steps.