Joshua Ates
Data Engineer
Garner, NC · (713) 562-7616 · joshuaates@live.com · linkedin.com/in/joshuaates · joshuaates.com
Data engineer with 10+ years of experience building and maintaining ETL pipelines and data warehouses using SSIS, Azure Data Factory, and Databricks/PySpark. Background includes SQL Server administration, performance tuning, and BI reporting (Power BI, Tableau, SSRS). Databricks Certified Data Engineer Associate.
Skills
Azure Data Factory · Databricks · PySpark · SQL Server · SSIS · T-SQL · Power BI · Tableau · SSRS · Python · Git · Jira · Data warehouse design · ETL architecture · Query & index optimization
Experience
SSIS Data EngineerOCT 2023 – PRESENT
ABC Supply Co. Inc.
- Provide production support for a multi-server legacy system; sole point of contact for legacy pipelines spanning Access, flat-file transfers, cross-server integrations, and POS systems.
- Decommissioned 300+ SSIS packages as part of a long-term migration plan, enabling the shutdown of five legacy servers.
- Convert SSIS packages to Azure Data Factory workflows and build Databricks notebooks using PySpark.
- Run month-end / year-end processes and daily / weekly reporting for upper management.
Business Intelligence EngineerSEP 2022 – OCT 2023
Amazon · Remote
- Built 21 ETL packages automating data pulls from 8+ source systems using Amazon's ETL manager and SQL.
- Built a cost-of-goods dashboard tracking spend from inbound logistics through final customer delivery.
- Combined location and shipping data to identify inefficient warehouse-to-customer routing, reducing shipping distances and costs.
- Automated manual weekly reporting processes.
Manager of Business Intelligence DevelopmentMAR 2022 – SEP 2022
Cisive
- Built and led a team of four; established scheduling, workflows, and reporting standards.
- Owned hiring, onboarding, and data warehouse standardization.
SQL DeveloperMAY 2020 – MAR 2022
Cisive · United States
- Rebuilt the ETL / data warehouse architecture for easier maintenance and faster iteration.
- Led SQL Server maintenance and optimization (locking, indexing, query tuning).
- Led a team of 3; built reports across SSRS, Power BI, and an in-house reporting tool.
SQL DeveloperAUG 2019 – APR 2020
Axiom Medical · The Woodlands, TX
- Built SSIS packages for legacy data ETL and Power BI dashboards for C-level stakeholders.
- Established a method for generating HIPAA-compliant randomized test data.
- Managed Azure cloud VMs and SQL Server for development environments.
Sr. Power BI ArchitectMAR 2019 – AUG 2019
EPC Group.net · Remote
- Led SQL Server performance optimization, upgrades, and replication setup.
- Delivered Power BI report development and end-user training.
SQL Server Developer and AdministratorSEP 2018 – FEB 2019
MP2 Energy LLC (Shell Energy North America) · The Woodlands, TX
- Built ETL processes for energy-curve loading using SSIS, PowerShell, and Citrix ShareFile.
- Upgraded SQL Server 2008 to 2017; converted Excel reports to Power BI.
Business Applications SpecialistMAY 2017 – SEP 2018
Dril-Quip · Houston, TX
- Developed a new non-conformance review process using AgilePoint, SQL Server, and Epicor.
- Replaced 10+ SSRS subreports with Power BI dashboards.
Business Intelligence DeveloperFEB 2015 – MAY 2017
Hudson Energy · Houston, TX
- Architected enterprise BI and data-warehousing solutions on SQL Server, including snowflake-schema data cubes.
- Designed ETL processes using SSIS; evaluated Tableau vs. Power BI for organizational adoption.
Business Intelligence AssociateJAN 2014 – SEP 2014
Rand Group · Bellaire, TX
- Supported BI solution design, troubleshooting, and ad-hoc reporting for client engagements.
Help Desk SpecialistSEP 2008 – MAR 2012
Best Buy · Houston, TX
- Grew department's share of store revenue from 1.6% to 3.0%; trained new sales-associate hires.
Education & Certifications
BBA, Management Information Systems — University of Houston (2010–2013)
Databricks Certified Data Engineer Associate
Phi Kappa Phi National Honor Society · Dean's List