Data science portfolio

Mark de la Cruz

Senior analytics professional bridging data engineering, product-style reporting, and stakeholder decision support. I turn messy operational data into trusted datasets, dashboards, and data stories that help teams act with confidence.

Snapshot

Positioned for senior data analyst, analytics engineering, and applied data science roles.

My strongest fit is for teams that need someone who can own the full analytics loop: understand ambiguous stakeholder questions, build the SQL/Python or low-code data processing path, validate the numbers, create self-service reporting, and communicate what the data means to technical and non-technical audiences.

Recruiter fit

Roles I am targeting

Senior Data Analyst

SQL-heavy analysis, dashboarding, KPI ownership, data quality, stakeholder-facing insights, and executive-ready reporting.

Product or Customer Analytics

Translating business questions into metrics, reporting infrastructure, behavioral or operational analysis, and decision frameworks.

Research Data Scientist

Regression, statistical analysis, observational data collection, quantitative narratives, and evidence-based recommendations.

Analytics Engineer / Data Engineer

ETL, data modeling, validation, pipeline documentation, automation, and reliable datasets for downstream reporting.

Selected work

Resume-backed analytics work

18K field inputs processed

Self-Service Contractor Performance Reporting

Designed a Power App, Dataverse, and Power BI workflow that gave stakeholders a structured way to monitor contractor quality, field evaluations, and work-order anomalies across regional SCE hubs.

  • Power Apps
  • Dataverse
  • Power BI
Read resume detail
98% compliance rate

Utility Risk Exception Analytics

Built SQL, Python, and Power BI workflows to clean equipment failure data, isolate exception concentrations, validate reporting quality, and help prioritize safety and wildfire-risk mitigation work.

  • SQL
  • Python
  • DAX
Read resume detail
20+ data interns led

Litigation ETL and Quantitative Modeling

Engineered ETL pipelines for enterprise-scale relational datasets, supported regression analysis, and helped turn complex client data into defensible analytical narratives for legal and business stakeholders.

  • Python
  • SQL
  • Regression
Read resume detail

Resume

Experience

2025 - Present

Senior Data Analyst, Substation Project Management - Southern California Edison

Built cross-functional Power App, Dataverse, and Power BI tools for contractor performance, substation infrastructure upgrades, executive reporting, data quality, and CPUC compliance decision-making.

2022 - 2025

Senior Data Analyst, Data Management Oversight - Southern California Edison

Developed SQL and Python processing scripts, automated dashboards, and KPI tools to track equipment failures, repair delays, compliance exceptions, and wildfire mitigation priorities across complex operational source systems.

2019 - 2020

Analyst, Wage & Hour Litigation Consulting - Resolution Economics

Built ETL pipelines with Python and SQL, performed regression and summary-statistical analysis, and led data cleaning protocols for a 20+ intern team in a consulting environment where data quality had legal and economic consequences.

Toolkit

Skills

Analysis

Risk analytics, KPI design, exception analysis, regression, summary statistics, time series.

Data Pipelines

ETL, SQL scripting, Python automation, data validation, data modeling, repeatable reporting flows.

Platforms

Power BI, DAX, Power Apps, Dataverse, SAP, Citrix, Snowflake, BigQuery, Tableau, Looker.

Communication

Executive presentations, product-style analytics, regulatory reporting, stakeholder translation, field context.

Contact

Let's connect.

I am interested in data science, quantitative risk, analytics engineering, and infrastructure decision-support roles.