Data Analyst 2

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

Preferred

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

Benefits

• Medical and dental care benefits
• 401k
• PTO
• Parental leave
• Bereavement leave
• Glassdoor
• 3.7
• Public Consulting Group is a consulting company offering management consulting services to public sector organizations and entities.
• Boston, Massachusetts, USA
• http://www.publicconsultinggroup.com/
• Late Stage
• Leadership Team
• Jimmy Cleveland
• Chief Executive Officer
• David Flores
• Chief Technology Officer
• Recent News
• Bizjournals.com Feed (2025-11-12 15:43:17)
• Clark University lands $27M federal grant to expand IT apprenticeship program
• 2026-07-14
• Public Consulting Group Receives U.S. Department of Labor Approval for National Apprenticeship Program
• 2025-11-20
• Maryland State Department of Education Partners with Public Consulting Group to Expand Special Education Director and Aspiring Leaders Academy
• 2025-10-21
• Company data provided by
• AI Tools
• Customize Your Resume
• Maximize your interview chances
• Build Cover Letter
• Make your application stand out

Qualifications

• 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
• 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
• Bachelor's degree or higher in data analytics, statistics, mathematics, computer science, information systems, public policy, business, or a related field; equivalent relevant experience may be considered
• 4+ years of progressively responsible experience in data analysis, reporting, data integration, business intelligence, or system implementation roles
• PCG does not sponsor newly hired foreign national workers for work authorization, including H-1B sponsorship
• Experience with R, SPSS, Python, or comparable technologies is beneficial
• 4+ years of progressively responsible experience in data analysis, reporting, data integration, business intelligence, or system implementation roles.

Required skills

• Power BI, SQL, Excel, Microsoft Office, Data Analysis, Data Modeling, Data Integration, ETL, Data Warehousing

Experience

• 4+ years