Analytics Engagement Consultant

About the role

• It's fun to work in a company where people truly BELIEVE in what they're doing!
• We're committed to bringing passion and customer focus to the business.
• Our people make all the difference in our success.
• Public Partnerships LLC supports individuals with disabilities or chronic illnesses and aging adults, to remain in their homes and communities and "self" direct their own long-term home care.
• Our role as the nation's largest and most experienced Financial Management Service provider is to assist those eligible Medicaid recipients to choose and pay for their own support workers and services within their state-approved personalized budget.

We are appointed by states and managed healthcare organizations to better serve more of their residents and members requiring long-term care and ensure the efficient use of taxpayer funded services. Our culture attracts and rewards people who are results-oriented and strive to exceed customer expectations.

We desire motivated candidates who are excited to join our fast-paced, entrepreneurial environment, and who want to make a difference in helping transform the lives of the consumers we serve.

Job Summary

The Analytics Engagement Consultant supports data-driven decision-making across Public Partnerships LLC (PPL) by delivering analytical insights, developing reporting solutions, and partnering with business stakeholders to solve operational and strategic challenges.

This role is ideal for an early-career analytics professional who demonstrates strong technical aptitude, business curiosity, and a desire to influence organizational outcomes through data. The Analytics Engagement C will contribute to analytics engagements, support data modeling and reporting initiatives, and collaborate with cross-functional teams to improve program performance across PPL's business lines.

Key Responsibilities

Analytics Delivery & Project Execution

• Support the execution of analytics initiatives under the guidance of senior analytics leaders.
• Perform data analysis, reporting, and research to address defined business questions and operational challenges.
• Assist in requirements gathering, project planning, and solution development for analytics engagements.
• Manage assigned deliverables and timelines while proactively communicating risks, dependencies, and obstacles.
• Contribute to the development of dashboards, reports, and analytical tools that support business decision-making.

Data Analysis & Technical Development

• Develop, maintain, and optimize SQL queries, datasets, and reporting solutions.
• Utilize Python and related analytical tools to perform data manipulation, analysis, and automation activities.
• Support data transformation, validation, and quality assurance processes.
• Apply analytical techniques including segmentation, trend analysis, descriptive statistics, and anomaly detection to identify actionable insights.
• Document methodologies, assumptions, business rules, and technical processes to support knowledge sharing and audit readiness

Stakeholder Partnership & Communication

• Collaborate with managers, senior managers, and cross-functional business partners to understand analytical needs and deliver meaningful insights.
• Translate technical findings into clear, concise recommendations for business audiences.
• Participate in stakeholder meetings and contribute to discussions regarding analytical approaches and business opportunities.
• Support the presentation of findings through written reports, dashboards, and verbal communications.

Continuous Improvement & Professional Development

• Participate in code reviews, peer reviews, and knowledge-sharing activities.
• Develop an understanding of PPL's business operations, including Medicaid programs, self-directed services, payroll operations, program performance, and compliance requirements.
• Contribute to the continuous improvement of analytics standards, methodologies, and best practices.
• Stay current on emerging analytics technologies, tools, and industry trends.

All other duties assigned

Required Skills

• Strong SQL skills with demonstrated ability to develop complex queries utilizing joins, common table expressions (CTEs), aggregations, and window functions.
• Working knowledge of Python for data analysis, data manipulation, and automation.
• Understanding of data modeling concepts, including conceptual, logical, and physical data models.
• Strong analytical, problem-solving, and critical-thinking skills.
• Excellent written and verbal communication skills with the ability to explain technical concepts to non-technical audiences.
• Ability to manage multiple priorities and work independently within established deadlines.

Qualifications

Education/Experience

• Bachelor's degree in Computer Science, Statistics, Economics, Engineering, Information Systems, Mathematics, Business Analytics, or a related quantitative field; equivalent combination of education and experience may be considered.
• Two (2) to four (4) years of professional experience in analytics, business intelligence, data analysis, consulting, or a related field.
• Experience with modern data platforms and analytics technologies such as Databricks, Snowflake, Azure Data Factory, Azure Synapse, Power BI, Tableau, or similar tools.
• Experience working in healthcare, Medicaid, government programs, payroll operations, financial services, or other regulated industries.
• Familiarity with cloud-based data architectures and data transformation frameworks.
• Exposure to statistical analysis, predictive modeling, or data science methodologies.
• Experience supporting cross-functional business initiatives through analytics and reporting.

Working Conditions

• Remote.
• Supervisory Responsibility (If applicable): None

Pay and benefits

This role is eligible for a base salary within the posted range. Actual compensation will be determined based on a variety of factors, including skills, experience, and geographic location. Compensation may vary for positions based in high cost-of-labor markets.

The above is intended to describe the general contents and requirements of work being performed by people assigned to this classification. It is not intended to be construed as an exhaustive statement of all duties, responsibilities, or skills of personnel so classified

We believe that we work best when our employees feel empowered and accepted, and that starts by honoring each of our unique life experiences. At PPL, all aspects of employment regarding recruitment, hiring, training, promotion, compensation, benefits, transfers, layoffs, return from layoff, company-sponsored training, education, and social and recreational programs are based on merit, business needs, job requirements, and individual qualifications. PPL will not tolerate discrimination or harassment based on any of these characteristics.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!