Remote Power Query Jobs in Riverside, CA (NOW HIRING)

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.

About the Role:

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.

Benefits

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.