Open to opportunities

Mark de la cruz

@markdelacruz1

Message

Risk & Data Analyst using SQL, Python, and dashboards to drive utility decisions.

United States

Message

What I'm looking for

I’m looking to apply quantitative risk and data analytics to high-impact infrastructure and compliance work—building dependable pipelines and dashboards that help executive teams make faster, safer investment decisions.

I’m a highly analytical, impact-driven Quantitative Risk and Data Analyst with 7 years of professional experience at major California electric utilities, including Southern California Edison.

I use SQL, Python, and modern data platforms to process complex infrastructure datasets—tracking asset equipment failures, quantifying risk, and engineering data pipelines that stand up to enterprise reporting needs.

At SCE, I’ve built and governed scalable tracking and reporting solutions, including an MS Power App and Dataverse system processing 1,000+ contractor performance scorecards and 18,000 field evaluation inputs, plus advanced Power BI dashboards using DAX and robust data modeling for executive-ready insights.

I also translate complex quantitative risk metrics and model outputs into clear, actionable presentations for senior leadership—driving measurable outcomes like increasing compliance rates from 92% to 98% and strengthening wildfire-risk mitigation through automated KPI tools. Previously, at Resolution Economics, I engineered ETL pipelines and used statistical modeling to support high-stakes quantitative consulting work.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Analyst, Substation

Current

Southern California Edison

Jan 2025 - Present (1 year 5 months)

Designed and deployed a cross-functional MS Power App and Dataverse database that processes 1,000+ contractor performance scorecards and 18,000 field evaluation inputs to track work-order anomalies across regional hubs. Built Power BI dashboards with advanced DAX and governed enterprise data architecture to support CPUC regulatory compliance and executive decision-making.

Dataverse Power BI DAX Data Modeling Data Governance Data Pipeline Development Performance Dashboards Regulatory Compliance

Senior Data Analyst, Data Oversight

Southern California Edison

Jan 2022 - Jan 2025 (3 years)

Developed SQL and Python processing scripts to track, clean, and analyze equipment failure data and repair delays across SAP and Citrix platforms, accelerating mitigation of high-consequence infrastructure risks. Increased compliance rate from 92% to 98% by building automated Power BI dashboards that isolated exception concentrations and supported monthly VP-level remediation planning.

SQL Python Power BI DAX SAP Citrix Data Cleaning Compliance Analytics

Analyst, Valencia DCH

Southern California Edison

Jan 2020 - Jan 2022 (2 years)

Analyzed high-voltage substation, transformer, and distribution circuit datasets to deliver recurring asset health and risk reports for project lifecycle meetings with internal teams and field contractors. Built an online Purchase Order database to streamline workflows and speed up material delivery timelines.

Power BI Citrix Operational Reporting Data Extraction Data Integration Ad Hoc Reporting

Analyst, Wage & Hour Consulting

Resolution Economics, LLC

Jan 2019 - Jan 2020 (1 year)

Built ETL data pipelines with Python and SQL to process enterprise relational datasets while maintaining data integrity for high-stakes quantitative economic consulting. Applied regression analysis and statistical methods to model trends and support predictive legal narratives submitted for federal and state court proceedings.