Brent Broadnax

L

Data Engineer

LMI - Client: National Aeronautics and Space Administration (NASA)

Mar 2025 - Jul 2025 (5 months)

Supported NASA's Office of Inspector General by developing scalable data pipelines, managing ingestion workflows, and conducting advanced data cleanup operations using Python and DatabricksDesigned and maintained PowerBI dashboards for agency-wide reporting, improving transparency and stakeholder visibility into key operational metricsImplemented and maintained DAGs in Apache Airflow to orchestrate automated data tasks across AWS infrastructureConfigured and supported AWS services including S3, EC2, AWS Athena, and Secrets Manager as part of the organization's broader data architecture strategyAdvised senior leadership on the architectural design of a new medallion-layered data warehouse, integrating compliance, performance, and maintainabi

Lead Data Engineer

TrueSense Marketing

Jan 2024 - Aug 2024 (8 months)

Developed data analytics pipelines between a range of marketing platforms and Snowflake data warehouses using Microsoft Azure Data Factory and Fivetran HVRAnalyzed and error-corrected several data sources within multiple data warehouses – including Snowflake and Microsoft SQL ServerCreated and implemented data governance processes for new reporting sources, ensuring data quality, security, and complianceImproved documentation related to data quality, data models, data cleanliness, and data lineage within the organizationEstablished data governance frameworks to ensure data accuracy, consistency, and regulatory compliance across all data sources

I

Senior Data Quality Analyst/Engineer - SDET

IBM - Client: Veterans Affairs

Jun 2023 - Dec 2023 (7 months)

Implemented data quality and validation processes using complex a combination of Python/PySpark and T-SQL queries in Azure Synapse, Databricks, and Microsoft SQL ServerPerformed quantitative and statistical analysis of healthcare claims and demographic dataWorked over multiple teams to build data pipelines (ETL) using SQL Server Integration ServicesCrafted comprehensive documentation including data models, data dictionaries, and other program documentation to support data governance initiativesDeveloped and maintained data governance policies and procedures to ensure compliance with healthcare regulations and data privacy lawsLeveraged UI/UX principles to develop and maintain a host of PowerBI dashboards for key stakeholders

B

Data Engineer/Analyst

Bution

Feb 2023 - Jun 2023 (5 months)

Implemented PowerBI and developed various reporting (UI/UX) tools within the organizationBuilt ETL data pipelines using Python and SSIS to create reporting tables leveraging T-SQL.Worked to develop processes for building data models using Databricks and deploying dashboardsHelped train users on PowerBI, data visualization best practices, and data governance principlesIntegrated complex datasets between Azure and Microsoft SQL Server instances, ensuring proper data lineage and metadata management

T

Data Engineer/Analyst - SDET

Take2 - Client: Veterans Affairs

May 2022 - Feb 2023 (10 months)

Created data artifacts to assist leadership in decision-making around capital investments and large-scale construction projectsWorked across teams to deploy new data models, UI/UX tools, quantitative analytical techniques, and a suite of dashboardsImplemented new data pipelines between systems, Sharepoint, SQL Server, and Azure Databricks using tools including Snowflake, T-SQL and SSISBuilt and maintained a suite of dashboards using PowerBI and SSRS with custom metrics and visualizations

Data Engineer - SDET

Verisys

May 2021 - Apr 2022 (1 year)

Developed healthcare data pipelines between data storage systems (such as Snowflake, AWS, Azure Databricks, Redshift, and Oracle SQL Servers) and various API frameworks using Python, DBT, both PL/SQL and T-SQLReviewed several data validation tools for suitability within our existing data processing systemsOperated across internal groups to improve data-related documentation and processesLeveraged databricks to run exploratory analysis, initial machine learning tasks, and to build reporting tools for BI teams using PowerBI, Teradata, and TableauDeveloped core code needed for various applications – fully architected the core framework using behavior driven development (BDD) principles

Data Analyst/SQL Developer - Contractor

Gap Inc.

Dec 2020 - Mar 2021 (4 months)

Provided ad-hoc assistance on a variety of data and analysis projects within the Real Estate groupCreated several interactive PowerBl reports and applications to assist with key business objectivesIncorporated a wide variety of data from within the greater organization to facilitate executive decision-makingEstablished working relationships within the organization to facilitate the transfer of data and expertise

R

Marketing Data Engineer - Contractor

Royal Ahold Delhaize

Dec 2020 - Apr 2021 (5 months)

Implemented a number of data pipelines from marketing platforms into Google BigQuery using DatabricksBuilt ETL processes using Python to extract API data (including Google Analytics), apply various transformations, and load into multiple tables within BigQuery and SnowflakeCreated automated processes to read and ingest flat files received via email into Google Cloud StorageAssisted in creating and managing a number of dashboards and analysis toolsAutomated the processing and validation of ingested data using messaging tools to increase team visibilityCrafted guidelines for documentation and version control – all within an Agile frameworkOperated across multiple brands and groups to deliver on a range of data-related initiatives

W

Senior Data Analyst/SQL Developer - Contractor

Williams Companies

Jul 2020 - Dec 2020 (6 months)

Developed a wide range of both ad-hoc and project-focused reporting tools using PowerBI and DatabricksUsed classification and text prediction machine learning algorithms (Python) to better process user-generated pipeline dataIngested and processed data from multiple sources, including internal Oracle Maximo databases (PL/SQL), various SharePoint assets, and several internally-built toolsCreated data pipelines (ETL) using Python and Oracle technologiesWrote and updated the Oracle SQL (PL/SQL) and Microsoft (T-SQL) queries associated with the Maximo asset deployment at WilliamsWorked across multiple work groups to develop metrics and metrics to aid internal report development efforts

I

Lead Data Analyst - SDET

IT Concepts - Client: Veterans Affairs

Sep 2019 - Jul 2020 (11 months)

Created suite of reports and dashboards in SSRS and PowerBI to illustrate users of VA electronic health records and help directors gauge future organizational needRegularly worked with large data sets (200 million+ records) to find trends, tendencies, and other vital program informationUsed experience with graphic design and layout to ensure an engaging user experienceUsed Agile development methodologies to ensure project area was both on-time and delivered usable outputEvaluated the suitability of implementing PowerBI program-wide for reporting and dashboard requirementsWrite and debugged complex T-SQL queries to join and unite data (ETL) from multiple data warehouses (including Snowflake and Databricks), tables, and servers using SQL Serv

R

Analytics & Automation Manager

RGI Data Assets

Jan 2019 - Sep 2019 (9 months)

Employed various statistical techniques to segment our advertising audiences - improving ad effectiveness and customer sentimentEvaluated Google BigQuery (SQL), in conjunction with Google Data Studio, for internal data warehouse and reporting needs.Analyzed advertising audience performance to create new ad copy that reduced cost per lead by an excess of 45%Created engaging visualizations using Microsoft Excel, Tableau, and PowerBI – all fed from Azure CosmosDB - to present department updates and trends to executive leadershipWrangling data from multiple sources including social media, existing consumer databases, Google Analytics, email service providers, and pay per click advertising platformsDeveloped quantitative research techniques to l

Marketing Analyst Manager

Oakwood Systems Group

Mar 2018 - Jan 2019 (11 months)

Provided expertise to executive leadership relative to marketing data, advertising metrics, and sales outcomes in a readily available design within MS DynamicsWrote scripts in JavaScript and T-SQL to integrate MS Dynamics and website content to improve user experienceAnalyzed search engine, social media, Google Analytics, and sales data to enhance lead generation activitiesDirected weekly meetings with leadership to present weekly updates, highlighted key findings, and made recommendationsSolely responsible for ingesting, analyzing, and moving data into visualization tools on Google CloudUsed text mining and regression analysis to develop an email campaign resulting in more than $400k of new revenue in only 60 daysOptimized website visibili

N

Senior Marketing Analyst

NerdBox

Feb 2017 - Mar 2018 (1 year 2 months)

Designed a host of data visualizations and reports to drive a deeper understanding of data (including Google Analytics), and its possibilities, within clientsInformed and educated business leaders about the potential to leverage opportunities through analysis of their sales, marketing, and logistical dataDeveloped and replaced various JavaScript scripts for client dashboards and websites to enhance functionality and product integration with platforms including BigQuery, Snowflake, Redshift, and other cloud data platformsExecuted the development of campaigns and other client needs, including project plans, target dates, design development, and other deliverablesDeployed marketing automation functionalities to support data driven client organ

N

Data Analyst

New Jersey Department of Environmental Protection

Jan 2015 - Feb 2017 (2 years 2 months)

Designed and maintained several custom geospatial (ArcGIS) dashboards for Department Directors to help shape and refine state regulatory policyDeveloped internal procedures to handle tasks including acquiring new data from staff, quantitative analysis and research, performing data cleaning, and loading data into our data warehouse and visualization tools including ArcGIS and T-SQLPrepared written technical and non-technical reports for executives within New Jersey State Government using Department dataImplemented internal tracking systems to manage data and reporting issues using JavaScript, Google Cloud solutions, SQL, and advanced MS Excel techniquesAssisted in administering IT contracts and coordinating with external vendors

Client Services Volunteer

Taproot Foundation

Mar 2013 - Dec 2014 (1 year 10 months)

Provided non-profit organizations consulting services around project management, data visualization, and marketing automationExtracted, transformed, and loaded data into a number of client data warehouse systems

Z

Analyst

Zotheca Consulting

Jun 2009 - Mar 2013 (3 years 10 months)

Used data storytelling techniques to integrate databases (Microsoft SQL Server and BigQuery), marketing (Google Analytics), advertising, and other data into a digestible and usable format for clientsDesigned and updated various relational database solutions to drive client content management systems (CMS)Created custom solutions using open-source CMS systems including WordPress and Drupal populated via MySQL and T-SQL data sources

V

Business Analyst

Verizon Communications

May 2008 - May 2009 (1 year 1 month)

Utilized both agile and waterfall methods development principles to implement Receivables Management department applicationsRegularly utilized written communication and data visualization skills (data obtained using T-SQL) to create effective convey project and business requirementsConducted acceptance testing to ensure all requirements were met and implementing any necessary scripts to resolve gaps

About

Detail

Timeline

Résumé

Brent Broadnax

About

Detail

Behavioral traits