Juan David Trejos Gamboa

Data & Operations Analyst

Medellín, Colombia

#OpenToWork

About

Data & Operations Analyst with experience owning end-to-end data quality, payroll operations, and reporting for large client portfolios across financial and real-time data environments. Skilled in SQL, PostgreSQL, Python, and Excel, with strong Power BI reporting and Agile/Jira-based workflow management. Early and hands-on adopter of AI-driven automation — including Claude Code, Cursor, n8n workflow automation, and MCP (Model Context Protocol) integrations — to eliminate manual work and scale operational efficiency. Proven ability to identify root causes, build repeatable data workflows, and translate complex datasets into clear, actionable insights for both technical and business stakeholders. Keywords: SQL | PostgreSQL | Python | Excel | Power BI | Data Quality | Data Automation | AI-Driven Automation (Claude Code, Cursor, n8n, MCP) | Agile / Jira | KPI Reporting | Payroll Operations | Client Portfolio Management | Stakeholder Communication

What I'm looking for

I’m looking for remote opportunities in Data Analytics, Data Engineering, or Operations Analytics where I can leverage SQL, Python, data visualization, ETL/ELT, and process automation to solve business problems. I’m particularly interested in roles involving data quality, workflow automation, AI-assisted solutions, and building reliable data pipelines, with opportunities to work with international and cross-functional teams.

Experience

Genius Sports

Live Feed Data Analyst

Genius Sports

Aug 2024 – Jul 2025

● Maintained 99.9% data accuracy across high-volume, real-time datasets, as measured by internal quality benchmarks, by validating and monitoring incoming structured data feeds. ● Reduced data inconsistencies and reporting errors, as measured by incident-tracking metrics, by investigating anomalies, determining root causes, and documenting corrective actions across multiple data sources. ● Increased issue-resolution speed, as measured by escalation response time, by documenting repeatable data workflows and procedures for distributed operational teams. ● Improved operational decision-making support, as measured by downstream reporting accuracy, by monitoring performance metrics and communicating findings clearly to stakeholders.

Data ValidationData QualityReporting
ForUsAll

Data Operations Analyst

ForUsAll

Aug 2024 – Jun 2025

● Owned end-to-end payroll and retirement operations for a portfolio of 90+ clients, as measured by on-time, accurate payroll delivery, achieving 100% data accuracy through reconciliation audits. ● Reduced manual operational workload by 15+ hours per week, as measured by workflow tracking, by building automation with Python scripting alongside modern AI-driven tools — including Claude Code, Cursor, n8n workflow automation, and MCP (Model Context Protocol) integrations. ● Reduced data discrepancies by 20%, as measured by synchronization error rates, by writing SQL queries to clean, normalize, and cross- validate data across relational systems. ● Improved team operational visibility and efficiency, as measured by task completion tracking, by implementing an Agile workflow with dashboards, tasks, and subtasks in Jira, supported by daily standups. ● Drove operational decision-making, as measured by KPI tracking presented in daily standups, by developing SQL queries on PostgreSQL (via Mode) to monitor team performance and surface improvement opportunities. ● Improved reporting reliability, as measured by a reduction in validation failures, by implementing automated data quality monitoring and anomaly detection.

PythonSQLPostgreSQL

Education

Universidad Nacional de Colombia

B.S. · Software Engineering

2027

Skills

REST APIsAWSSnowflakeAnomaly DetectionRoot Cause AnalysisData ReconciliationData ValidationPayroll OperationsKPI ReportingJiraAgileAI-Driven AutomationData AutomationData QualityPower BIExcelPythonPostgreSQLSQL

Languages

Spanish (Native or bilingual proficiency)English (Full professional proficiency)