Joshua is available for hire

Joshua Zenteno Jiménez

Verified Expert in Engineering

Data Engineer and BI Developer

Tres de Mayo, Mexico

Toptal member since January 23, 2025

Expertise

Data Analysis DAX SQL Excel Development SAS Business Intelligence Development ETL Jira SSIS Oracle Development Python Tableau Development

Bio

With 13 years of experience, Joshua specializes in data analysis, business analytics, BI, QA, and data engineering. He has delivered data-driven and decision-making solutions, dashboards, and finance reports (revenue, profit, taxes, interest, etc.) in the banking, payments, retail, telecom, and insurance sectors. Joshua has developed models for propensity, fraud, KPIs, clustering, behavior analysis, and ETL automation. He has 13 years in SQL and Excel, 6 in Power BI, 9 in SAS, and 7 in ETL.

Portfolio

PayPal

SQL, Google BigQuery, Microsoft Power BI, Excel 365, Jira, Microsoft Excel...

Santander Consumer USA

SQL, Amazon Redshift, Python, PySpark, Microsoft Power BI, Excel 365...

Agile Thought

SAS, Jira, SQL, Azure Data Factory (ADF), Microsoft Power BI, Python, ETL...

Experience

Excel 365 - 13 years
SQL - 13 years
SAS - 9 years
ETL - 8 years
Microsoft Power BI - 6 years
SQL Server Integration Services (SSIS) - 4 years
Jira - 4 years
Google BigQuery - 2 years

Availability

Part-time

Preferred Environment

SQL, Microsoft Power BI, SAS, ETL, Excel 365, Python, Microsoft Excel

The most amazing...

...achievement was leading the transformation of the billing campaigns project at Santander Bank, which focused on increasing credit and debit card billings.

Work Experience

Senior Data BI Analyst

2024 - PRESENT

PayPal

Developed SQL queries to provide data for the customer journey project.
Designed Power BI models to support dashboard development for customer journey and contact routing projects.
Performed statistical analysis and summarized large data volumes.

Technologies: SQL, Google BigQuery, Microsoft Power BI, Excel 365, Jira, Microsoft Excel, Data Analysis, DAX

Senior Data Analyst

2023 - 2024

Santander Consumer USA

Created functional and technical documentation for data provisioning pipelines, including source-to-target mappings and data environment diagrams.
Provided data-driven solutions and KPI dashboards while conducting ad-hoc analysis and deep dives into financial data from multiple sources.
Ensured data accuracy, integrity, and security across financial databases and systems.

Technologies: SQL, Amazon Redshift, Python, PySpark, Microsoft Power BI, Excel 365, Microsoft Excel, Data Analysis, DAX

Leader | Senior Data Engineer

2021 - 2023

Agile Thought

Served as a development lead at CIBanco, integrating databases to create a unified customer database. Developed a dynamic customer ID algorithm in Python, implemented data quality rules, and created dashboards for efficient data consultation.
Worked as a senior developer at Soriana, implementing a new data hierarchy and developing data architecture and dashboards. Designed and developed QA test matrices and QA test plans.
Optimized processes for the store expansion project and resolved ETL issues while serving as development lead at AutoZone USA.

Technologies: SAS, Jira, SQL, Azure Data Factory (ADF), Microsoft Power BI, Python, ETL, Amazon Redshift, PostgreSQL, Excel 365, Microsoft Excel, Data Analysis, DAX

Cross-functional Leader | Senior Data Engineer

2020 - 2021

NTT Data

Spearheaded and developed the technical segregation project, migrating databases from Teradata to Oracle while developing KPI dashboards and establishing data quality rules.
Handled planning, architecture design, and solution diagrams, along with documentation. Managed data lineage, including the creation of data lineage documentation and dictionaries.
Developed dashboards to monitor statistics and implemented data quality rules to track key metrics over time, including completeness, integrity, consistency, and validity.

Technologies: SAS, SQL, Abinitio, IBM Cognos, Tableau, Python, Excel 365, Microsoft Excel, Data Analysis

Subdirector of Risk Analytics

2019 - 2020

CellPay

Built analytical models and implemented neural networks for risk scoring while monitoring company growth through KPIs.
Developed financial dashboards and reports (Revenue, Profit, Interest, Commissions, Taxes, Reserve, etc.).
Developed reserve models for probability of default (PD), loss given default (LGD), exposure at default (EAD), expected loss, profitability, and perpetuity.
Architected dashboards to monitor company growth, tracking KPIs, rollbacks, stay rates, and provisions.

Technologies: SAS, SQL, SQL Server Integration Services (SSIS), Python, Excel 2016, Microsoft Excel, Data Analysis, Microsoft Power BI, DAX

Senior SAS Consultant

2019 - 2019

BBVA Bancomer

Served as the lead in the development of analyses, reports, process automation, and KPI dashboards to track and describe the behavior of hours worked, rotations, vacancies, and hiring policies for BBVA employees.
Automated processes to track employee growth and goals achieved.
Created KPI dashboards to monitor employee growth.

Technologies: SAS, SQL, Microsoft Power BI, Excel 2016, Microsoft Excel, Data Analysis, DAX

Senior Analytics Consultant

2017 - 2019

Banco Santander

Headed the transformation of billing campaigns by developing a data mart, tracking processes, and dashboards to measure campaign performance.
Designed and developed the billing campaign generator process, including the creation of a control group to optimize future measurement, and led the design and development of the campaign data mart.
Developed an automated process for tracking and analyzing campaigns through KPIs vs. control group, enabling the comparison of behavior between campaign participants and non-participants.
Identified and implemented new strategies to support business growth and increase the number of positive responders while developing propensity models based on customer preferences.

Technologies: SAS, SQL, Tableau, Excel 2016, Microsoft Excel, Data Analysis

Senior SAS Consultant | Project Manager

2015 - 2017

Tata Consultancy Services - Citibanamex

Managed consumer risk portfolios, including credit cards, auto loans, personal credit, Infonavit loans, and staff accounts.
Spearheaded data migration projects and designed data models to support insurance sales and claims processes.
Designed and developed data models for insurance policies and claims, covering individual and collective categories such as life, personal accidents, and damages.

Technologies: SAS, Abinitio, SQL, Excel 2016, Excel 2013, Microsoft Excel, Data Analysis

Senior Analyst in Data Mining

2014 - 2015

Banco Santander

Developed insurance models for client scoring and the optimization of marketing strategies.
Built a Mexico insurance value segmentation model to score clients across three axes—profitability, loyalty, and value—enabling data-driven decision-making for marketing campaigns focused on cross-selling and up-selling opportunities.
Designed six insurance propensity models to calculate the probability of clients acquiring insurance policies and predict their future tenure.

Technologies: SAS, SQL, SQL Server Integration Services (SSIS), Excel 2013, Microsoft Excel, Data Analysis

Statistical Analyst

2013 - 2014

Telefónica

Architected customer segmentation and churn prediction models to drive targeted strategies and improve retention.
Developed a client segmentation model based on value clusters for segmentation and identifying users based on their value, behavior, and recharge patterns.
Built a churn model by calculating client abandonment probabilities using decision trees and logistic regression.
Crafted a social network model to identify key centers and target them with benefits to attract more customers.

Technologies: SQL, SAS, R, SQL Server Integration Services (SSIS), Oracle, Excel 2010, Excel 2013, Microsoft Excel, Data Analysis

Analyst

2012 - 2013

Qualitas

Built models to optimize special rates and drive effective policy implementation.
Developed and applied deterministic and econometric models to optimize special rates.
Analyzed special business to authorize insured amounts.
Coordinated between the commercial and technical teams to effectively monitor and implement company policies, primarily for car subscriptions.

Technologies: SQL, Excel 2010, Microsoft Excel, Data Analysis

Experience

Santander Bank | Transformation of Billing Campaigns

As a project leader, I developed and implemented a comprehensive campaign measurement system, which included creating a campaign generator and data mart in SAS and designing a campaign measurement process within SAS. I also built a campaign measurement dashboard in Tableau to visualize key metrics. Additionally, I defined KPIs to assess campaign performance accurately and conducted analysis to develop predictive models for future optimization.

Education

2005 - 2010

Bachelor's Degree in Actuarial Science

Autonomous University of Mexico State - Toluca, Mexico

Skills

Libraries/APIs

PySpark

Tools

Microsoft Power BI, Excel 2010, Microsoft Excel, Jira, Tableau, Abinitio, IBM Cognos, Excel 2016, Excel 2013

Languages

SQL, SAS, Python, R

Paradigms

ETL

Platforms

Oracle

Storage

PostgreSQL, SQL Server Integration Services (SSIS)

Other

Excel 365, Data Analysis, DAX, Google BigQuery, Amazon Redshift, Azure Data Factory (ADF)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring