Data Analyst 2: Remote Power BI Expert & Insight Driver

Public Consulting Group; Charleston (WV); Hybrid; USD 73,000 - 87,000; Full time

Benefits offered by this job

Medical and dental care benefits

401k plan

Paid time off

Job summary

Public Consulting Group is seeking a Data Analyst 2 to perform advanced data analysis, BI reporting, data integration, and stakeholder support. This role combines technical ownership of analytics products with reliable, actionable reporting across client and internal teams.

Responsibilities include building Power BI models, transforming data with Power Query and DAX, and delivering trusted insights for product lines and business units. Office setting with potential WFH options.

Qualifications

• Bachelor’s degree or higher in data analytics, statistics, mathematics, CS, information systems, public policy, business, or related field; equivalent experience may be considered.
• 4+ years of progressively responsible experience in data analysis, reporting, data integration, BI, or system implementation roles.

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 integrity of databases and reporting systems.
• Analyzes complex datasets to identify trends, 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 translating complex data into clear insights.

Skills

Power BI

SQL

Power Query

DAX

Data Modeling

Excel

Education

Bachelor’s degree

4+ years data analytics

Tools

R

Python

ETL

Job description

Public Consulting Group is seeking a Data Analyst 2 to perform advanced data analysis, BI reporting, data integration, and stakeholder support. This role combines technical ownership of analytics products with reliable, actionable reporting across client and internal teams.

Responsibilities include building Power BI models, transforming data with Power Query and DAX, and delivering trusted insights for product lines and business units. Office setting with potential WFH options.