JA Joshua Ates
DATA ENGINEERING

A decade turning data into decisions.

Ten-plus years across BI development and data engineering — Microsoft SQL Server, Power BI, SSIS, Azure Data Factory, and Databricks — from Amazon logistics analytics to multi-server legacy migrations. Databricks Certified Data Engineer Associate.

DOWNLOAD RÉSUMÉ (PDF)
BI & REPORTING
Power BI · Tableau
SSRS · Crystal Reports
DATA ENGINEERING
SSIS · Azure Data Factory
Databricks · PySpark
DATABASES
SQL Server · MySQL
Indexing · Query tuning
LANGUAGES
Python · SQL
PHP · JavaScript
CAREER PROGRESSION
Data & BI Career BI Foundations Power BI · Tableau · SSRS ETL & SQL Server SSIS · T-SQL · DB Admin Cloud & Big Data Azure Data Factory · Databricks · PySpark Rand Group BI Associate 2014 Hudson Energy BI Developer 2015 – 2017 Dril-Quip Business Apps Specialist 2017 – 2018 MP2 Energy SQL Dev/Admin 2018 – 2019 EPC Group.net Sr. Power BI Architect 2019 Axiom Medical SQL Developer 2019 – 2020 Cisive SQL Developer 2020 – 2022 Cisive Manager, BI Dev 2022 Amazon BI Engineer 2022 – 2023 ABC Supply Co. SSIS Data Engineer 2023 – Present Domains reflect primary skill focus per role; some roles overlap multiple domains.
EXPERIENCE

ABC Supply Co. — SSIS Data Engineer

OCT 2023 – PRESENT

Production support for a multi-server legacy system. Decommissioned 300+ SSIS packages and helped shut down five legacy servers as part of a long-term migration. Sole point of contact for legacy systems spanning Access, flat-file transfers, cross-server pipelines, and POS integrations. Converts SSIS packages to Azure Data Factory and builds Databricks PySpark notebooks.

Amazon — Business Intelligence Engineer

SEP 2022 – OCT 2023

Built 21+ ETL packages automating data pulls from 8+ sources, plus a dashboard tracking cost of goods from inbound logistics to final delivery. Combined location and shipping data into a heat map that identified inefficient warehouse-to-customer routing — used to reduce shipping distances and costs.

Cisive — Manager of BI Development / SQL Developer

MAY 2020 – SEP 2022

Built and led a team of four, established project workflows, and ran hiring and onboarding. As developer, rebuilt the organization's ETL and data-warehouse architecture for maintainability and scale, and led SQL Server optimization work — locking, indexing, and query tuning.

Axiom Medical — SQL Developer

AUG 2019 – APR 2020

Built SSIS packages for legacy data ETL, created Power BI dashboards for C-level stakeholders, and established a method for generating HIPAA-compliant randomized test data.

Earlier roles — EPC Group · MP2 Energy · Dril-Quip · Hudson Energy · Rand Group

2014 – 2019

A progression through BI architecture and SQL development: enterprise data warehousing and snowflake-schema cubes, Power BI report development and migration off SSRS, SQL Server performance tuning, replication and version upgrades, and ETL for energy-curve loading.

EDUCATION
BBA, Management Information Systems
University of Houston · 2010–2013
Phi Kappa Phi National Honor Society · Dean's List
CERTIFICATION
Databricks Certified Data Engineer Associate
Continuing coursework in Python, machine learning, and statistical modeling.