Data Analyst II - Power BI & Insights (Remote)

Public Consulting Group; Boston (MA); Hybrid; USD 73,000 - 87,000; Full time

Job summary

Public Consulting Group is seeking a Data Analyst 2 to drive advanced data analysis, BI reporting, data integration, and stakeholder support. This role combines technical ownership of analytics products with reliable, actionable reporting for multiple product lines.

You will design and maintain Power BI models, dashboards, and reports, using Power Query and DAX to transform data and optimize performance. Office setting with hybrid work options available.

Qualifications

• Bachelor’s degree 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.
• Proficiency in Power BI, Power Query, DAX, data modeling, and reporting.

Responsibilities

• Owns data dictionaries, data flow diagrams, transformation logic, validation rules, and reporting definitions.
• Leads data analysis, reporting, data integration, and ETL activities with limited supervision.
• Gathers, maps, cleanses, and integrates data from primary and secondary sources.
• Designs, develops, publishes, and maintains Power BI semantic models, dashboards, and reports.
• Interprets and communicates findings through clear reports and client-facing discussions.

Skills

Power BI

SQL

Data analysis

Problem solving

Communication

Education

Bachelor’s degree in data analytics or related field

Tools

Power Query

DAX

Excel

Job description

Public Consulting Group is seeking a Data Analyst 2 to drive advanced data analysis, BI reporting, data integration, and stakeholder support. This role combines technical ownership of analytics products with reliable, actionable reporting for multiple product lines.

You will design and maintain Power BI models, dashboards, and reports, using Power Query and DAX to transform data and optimize performance. Office setting with hybrid work options available.