Best-fit roles
Data Analyst / Senior Data Analyst
BI Analyst / Power BI Developer
Data Engineer
Analytics Engineer
Automation / Reporting Engineer
Operational Intelligence Analyst
Resume
Resume built around data systems, analytics, and automation.
A focused professional summary of the experience behind Lopez Data Works — connecting BI, data engineering, Python automation, SQL, dashboards, APIs, and operational intelligence into one clear story.
Professional summary
Jayson Lopez
Data Systems, Analytics & Automation Professional
I build end-to-end data systems across ingestion, transformation, automation, SQL modeling, Power BI reporting, operational dashboards, APIs, and decision-support workflows. My work focuses on turning raw, messy business data into systems that improve visibility, auditability, and execution.
Core stack
PythonSQLPower BIDAXPower QueryAzure SQLETL/ELTAPIsFastAPIPlaywrightExcel AutomationData ModelingInventory AnalyticsProcurementPricing AnalyticsOperational Reporting
Professional profile
Built for roles at the intersection of analytics, engineering, and automation.
This resume presents a focused view of the systems-thinking, technical range, and operational problem-solving behind Lopez Data Works — spanning BI, data engineering, Python automation, SQL, dashboards, APIs, and decision-support systems.
Role positioning
Cross-functional data systems profile
Designed for roles that require someone who can move between business requirements, data modeling, automation, reporting, and delivery — while keeping the operational decision at the center of the system.
Python, SQL, Azure SQL, Power BI, DAX, APIs, and Excel automation
ETL/ELT, reporting, dashboards, data modeling, validation, and operational workflows
Inventory, procurement, pricing, logistics, quoting, e-commerce, CCC, PartsTrader, and OrderTime domain depth
Data systems builder
Pipelines, automation workflows, SQL models, dashboards, APIs, and operational reporting layers.
Analytics + BI operator
Power BI, DAX, KPI frameworks, executive views, performance tracking, and decision-support reporting.
Business-domain depth
Inventory, procurement, pricing, logistics, quoting, e-commerce, CCC, PartsTrader, and OrderTime workflows.
Experience highlights
Built data systems and dashboards across inventory, procurement, pricing, quoting, logistics, and e-commerce operations.
Designed Python, SQL, Azure SQL, automation, and reporting workflows that reduce repetitive manual work and improve auditability.
Created BI dashboards, semantic models, executive reporting, validation logic, and repeatable analytics outputs for operational decisions.
Mentored teams and led data/reporting initiatives across technical and business groups.
Education & recognition
Southern New Hampshire University
B.S. Data Analytics, Minor in Project Management
GPA 3.80 • Dean’s Honors • Presidential List
National Society of Leadership and Success • Emerging Leader Award • Mentored 100+ students