Data Analyst 2

Public Consulting Group•US OH Remote, OH

10d•$73,000 - $86,500•Hybrid

About The Position

Data Analyst 2 is an individual-contributor role focused on advanced data analysis, business intelligence, reporting, data integration, and stakeholder support. The position combines technical ownership of analytics products with responsibility for reliable, actionable reporting.

Requirements

Advanced proficiency with Power BI, including Power Query, DAX, data modeling, semantic models, interactive report design, publishing, refresh management, security, and performance optimization; advanced proficiency with Excel and Microsoft Office products.
Demonstrated ability to conduct and validate data analysis using SQL and Power BI, including creating complex DAX measures and Power Query transformations; experience with R, SPSS, Python, or comparable technologies is beneficial.
Working knowledge of data warehouse concepts, data integration, ETL processes, data structures, and reporting expectations.
Ability to independently organize and manage multiple analytical deliverables, identify risks, and meet deadlines.
Strong problem-solving skills, including the ability to diagnose data issues, evaluate alternatives, and implement practical solutions.
Ability to translate business questions into analytical requirements and communicate technical concepts to nontechnical audiences.
Excellent written, verbal, presentation, facilitation, and documentation skills.
Ability to collaborate effectively with clients, managers, cross-functional teams, and junior staff while contributing to a culture of quality and exceptional client service.
Ability to recognize improvement opportunities, recommend best practices, and drive positive change.
Ability to travel up to 10% based on team needs.

Nice To Haves

experience with R, SPSS, Python, or comparable technologies is beneficial.

Responsibilities

Owns and maintains data dictionaries, data flow diagrams, transformation logic, validation rules, and reporting definitions for assigned products and services.
Leads defined data analysis, reporting, data integration, and ad hoc ETL activities across projects with limited supervision.
Gathers, maps, cleanses, and integrates data from primary and secondary sources while ensuring the integrity and upkeep of databases and reporting systems.
Analyzes complex quantitative and qualitative datasets to identify trends, patterns, risks, and actionable business insights.
Troubleshoots data-quality issues, coding errors, and reporting discrepancies and drives resolution with moderate independence.
Owns recurring reporting deliverables and ensures accuracy, completeness, consistency, and timely completion.
Designs, develops, publishes, and maintains Power BI semantic models, dashboards, and reports that translate complex data into clear, actionable insights for product lines and business units.
Uses Power Query and DAX to transform data, define reusable measures, automate reporting logic, and optimize refresh and report performance.
Applies Power BI data governance, security, documentation, testing, deployment, and quality-assurance practices to support reliable self-service analytics.
Interprets and communicates findings through clear reports, presentations, recommendations, and client-facing discussions.
Partners with managers and stakeholders to define, prioritize, and translate business needs into data requirements and analytical approaches.
Researches and recommends best practices, standardized measures, quality-assurance procedures, and process improvements for data analysis and reporting.
Provides technical assistance and training on data collection, analysis, and reporting tools.
Provides informal guidance, technical review, and peer support to junior analysts.
Participates in client and internal meetings, facilitating discussion of data requirements, findings, and recommended actions as appropriate.