Senior Data Engineering & Analytics Lead

PM2CM, Inc.; Pomona (CA); Hybrid; USD 130,000 - 170,000; Full time

Benefits offered by this job

Health insurance

401K match

Profit sharing

Job summary

PM2CM, Inc. is seeking a Senior Data Engineering & Analytics Lead to drive data strategy, build scalable infrastructure, and deliver actionable insights for strategic decision-making.

The role blends hands-on data engineering with leadership across cross-functional teams, leveraging Power BI, Excel, SAS and SAP to deliver enterprise-grade analytics. You will lead ETL and data modeling efforts, partner with IT and operations to ensure data quality, and communicate complex insights through

Qualifications

• 7+ years of experience designing and delivering complex data engineering solutions.
• Expert proficiency in Microsoft Office, advanced Excel (Power Query), SAS, and SAP.
• Experience with Business Intelligence tools for data visualization and analytics.
• Strong analytical foundation with the ability to translate insights into business value.

Responsibilities

• Lead the design, development, and deployment of scalable data engineering solutions including ETL, data modeling, and data pipelines.
• Apply advanced analytical methods to build forecasting and performance analysis models.
• Develop dashboards and visual analytics using Power BI, Excel, SAS and other BI tools.
• Translate analytical insights into clear reports and executive-ready narratives for leadership.
• Perform in-depth project data analysis to identify trends and improve reporting capabilities.
• Create and maintain robust technical documentation and data support for stakeholders.
• Collaborate with IT and business teams to ensure data quality, reliability, and governance.

Skills

Data engineering

Advanced Excel (Power Query)

SAS

SQL

Business Intelligence

Analytical thinking

Education

Bachelor’s degree in Computer Science / Information Systems / Data Analytics

Lean Six Sigma Black Belt

Tools

SAP

Job description

PM2CM, Inc., (Project Management to Construction Management) is a professional services company and certified SBE and DBE, dedicated to providing Program and Project Management, Construction Management and Project Controls services during the design and construction phase of projects. Our expertise is in Project Controls which includes Scheduling, Cost Controls, Document Management and Controls, Budget tracking and monitoring, Estimating, Risk Analysis, Claims avoidance and Mitigation, Change Management and Earned Value Management.

Our goal is simple: To offer and deliver the “best in class” project management, construction management and project controls services that allow our clients to build with confidence.

To achieve these objectives, we will strive to have a sound and complete understanding of the project scope and our client’s corporate needs. We shall provide our services with integrity and stellar professionalism and hire the best qualified professionals.

This is a remote role with periodic in-person team meetings in Pomona, CA.

We are seeking an experienced Senior Data Engineering & Analytics Lead to drive data strategy, build scalable data infrastructure, and deliver actionable insights that support strategic decision-making across the organization.

Key Responsibilities

• Lead the design, development, and deployment of scalable data engineering solutions, including ETL, data modeling, and data pipeline architecture for large and complex datasets.
• Apply advanced analytical and statistical methods to build forecasting, economic modeling, and performance analysis that solve complex business problems.
• Develop intuitive dashboards and visual analytics using Power BI, Excel (Power Query), SAS, and other BI tools to support cross-functional stakeholders.
• Translate analytical insights into clear reports, metrics, and executive-ready narratives that guide strategic operations and decisions.
• Perform in-depth project data analysis and identify patterns, trends, and opportunities to improve processes and reporting capabilities.
• Create and maintain robust technical documentation and deliver data support to leadership, operational teams, and business partners.
• Collaborate with IT and business stakeholders to ensure data quality, reliability, and governance.

Requirements

Required Qualifications

• 7+ years of experience designing and delivering complex data engineering solutions.
• Expert proficiency in Microsoft Office, advanced Excel (including Power Query), SAS, and SAP.
• Experience with Business Intelligence tools for data visualization and analytics.
• Strong analytical foundation with the ability to solve complex problems and translate them into business value.

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent combination of education/experience).
• Advanced proficiency in SQL.
• Knowledge of utility business operations.
• Lean Six Sigma Black Belt or equivalent certification.

What We Offer

• Remote work flexibility with periodic in-person team meetings in Pomona, CA.
• Opportunity to lead critical enterprise data initiatives and influence strategic decisions.

Benefits

• 100% paid health insurance, 401K match and profit sharing.