Power BI Data Analyst II - Remote Analytics & Insights

Public Consulting Group; Saint Paul (MN); Hybrid; USD 73,000 - 87,000; Full time

Benefits offered by this job

Work From Home

Job summary

Public Consulting Group seeks a Data Analyst 2 to drive advanced data analysis, BI reporting, data integration, and stakeholder support across health, education, and human services projects. You will own analytics products, ensure reliable reporting, and enable self-service insights for multiple product lines and units.

You will design Power BI models, perform data transformations with Power Query/DAX, and collaborate with managers to translate business questions into analytical solutions.

Qualifications

• Bachelor’s degree or higher in data analytics, statistics, mathematics, computer science, information systems, public policy, business, or related field.
• 4+ years of progressively responsible experience in data analysis, reporting, data integration, business intelligence, or system implementation roles.
• Travel up to 10% based on team needs.

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.

Skills

Power BI

Power Query

DAX

Data modeling

SQL

Python/R/SPSS

Data analysis

Communication

Presentation

Team collaboration

Education

Bachelor’s degree or higher in data analytics, statistics, mathematics, computer science, information systems, public policy, business, or related field

Tools

Excel

Job description

Public Consulting Group seeks a Data Analyst 2 to drive advanced data analysis, BI reporting, data integration, and stakeholder support across health, education, and human services projects. You will own analytics products, ensure reliable reporting, and enable self-service insights for multiple product lines and units.

You will design Power BI models, perform data transformations with Power Query/DAX, and collaborate with managers to translate business questions into analytical solutions.