Data Analyst 2

🕒 September 15

🇺🇸 United States – Remote

💵 $73k - $86.5k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📉 Data Analyst

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 1%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Public Consulting Group

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 1986

🏥 Healthcare

🍽️ Food & Beverage

📦 Logistics

Healthcare • Food & Beverage • Logistics

Public Consulting Group (PCG) is a leading public sector management consulting and operations improvement firm specializing in partnering with health, education, and human services agencies to enhance their effectiveness and impact. Through its strategic advisory and consulting services, PCG helps schools, state, and municipal agencies streamline their operations, improve programs, meet financial, regulatory, and operational challenges, and ultimately build stronger communities. Emphasizing technology solutions, PCG aids in automating services and achieving strategic goals. Additionally, the company is committed to social impact initiatives, such as fighting food insecurity, and actively participates in workforce development through apprenticeships.

📋 Description

• Own and maintain data dictionaries, data flow diagrams, transformation logic, validation rules, and reporting definitions • Lead defined data analysis, reporting, data integration, and ad hoc ETL activities across projects • Gather, map, cleanse, and integrate data from primary and secondary sources • Analyze complex quantitative and qualitative datasets to identify trends, patterns, risks, and actionable business insights • Troubleshoot data-quality issues, coding errors, and reporting discrepancies and drive resolution • Own recurring reporting deliverables and ensure accuracy, completeness, consistency, and timely completion • Design, develop, publish, and maintain Power BI semantic models, dashboards, and reports • Use Power Query and DAX to transform data, define reusable measures, automate reporting logic, and optimize performance • Apply Power BI data governance, security, documentation, testing, deployment, and quality-assurance practices • Interpret and communicate findings through reports, presentations, recommendations, and client-facing discussions • Partner with managers and stakeholders to translate business needs into data requirements and analytical approaches • Research and recommend best practices, standardized measures, quality-assurance procedures, and process improvements • Provide technical assistance and training on data collection, analysis, and reporting tools • Provide informal guidance, technical review, and peer support to junior analysts • Participate in client and internal meetings concerning data requirements, findings, and recommended actions

🎯 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 • 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 and 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 • Ability to recognize improvement opportunities, recommend best practices, and drive positive change • Ability to travel up to 10% • 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

🏖️ Benefits

• Medical and dental care benefits • 401k • PTO • Parental leave • Bereavement leave • Work from home