Aaron Rodriguez
Senior Data Engineer
Toney, AL 901.607.6553 ajrodr1982@gmail.com ajrodriguez.me
Download PDF ↓
Summary
Data analytics product leader with 20+ years of progressive experience spanning software product management, data engineering, and enterprise analytics delivery. Proven track record of defining product roadmaps, leading Agile ceremonies, gathering and translating complex stakeholder requirements into prioritized backlogs, and driving end-to-end delivery of high-quality, data-driven software. Deep technical fluency across the full pipeline lifecycle — from building new data pipelines in Azure Databricks and Azure Data Factory, Fivetran connectors, and SSIS packages to maintaining and debugging complex pipelines in production — enabling direct, informed collaboration with data engineers, analysts, and security specialists throughout the full development lifecycle. Experienced operating within DoD-adjacent environments through technical publications work for the US Marine Corps aligned to DoD CALS standards. Known for bridging the gap between business stakeholders and engineering teams, championing data-driven decision-making, and delivering analytical platforms that support executive, operational, and strategic objectives.
Experience
National CineMedia (NCM)
May 2022 – Present
Senior Data Engineer (Official title: BI Engineer III)
  • Built new data pipelines in Azure Databricks and Azure Data Factory, Fivetran connectors, and SSIS packages — expanding the data platform to support new vendors, business logic requirements, and data sources as they were onboarded.
  • Owned end-to-end monitoring, diagnosis, and resolution of production pipeline failures across ADF and Databricks — restoring data flow to executive, sales, and finance reporting for the largest cinema advertising network in the US, where outages directly halt campaign and revenue visibility across the organization.
  • Maintained and extended a metadata-driven Databricks architecture that dynamically generates fact and dimension tables via SQL — implementing bug fixes, business logic updates, aggregation changes, and data cleansing in close collaboration with the product owner and business stakeholders.
  • Managed and troubleshot Fivetran integrations ingesting programmatic advertising data from DSP and SSP vendors including The Trade Desk, Xandr, OpenX, and PubMatic — diagnosing vendor-side schema changes, dependency breaks, and data anomalies to maintain pipeline integrity across critical ad data feeds.
  • Diagnosed and resolved a critical production outage caused by a vendor deleting upstream tables with downstream pipeline dependencies — reconstructed the affected SQL logic, validated data integrity end-to-end, and restored reporting across all impacted business domains.
  • Built and maintained a comprehensive Power BI reporting layer including SSAS semantic models, DAX measures, calculated columns, dataflows, and datasets — delivering campaign performance, sales, and financial reporting to stakeholders across the organization.
  • Led Agile ceremonies including sprint planning, daily standups, sprint reviews, and retrospectives via Azure DevOps — collaborating with product owners, engineers, and cross-functional stakeholders to define, prioritize, and deliver data analytics capabilities on a structured release cadence.
  • Gathered, analyzed, and documented business requirements from executive, sales, and finance stakeholders — translating operational reporting needs, data quality standards, and pipeline reliability requirements into well-defined user stories, acceptance criteria, and backlog items.
  • Contributed to product roadmap definition and led backlog grooming sessions — prioritizing pipeline features, analytics enhancements, and data quality improvements based on business impact, feasibility, and strategic alignment across the organization.
Tools: Python, SQL, Spark SQL, DAX, Databricks, Azure Data Factory, Azure Data Lake Storage, Azure DevOps, Fivetran, The Trade Desk, Xandr, PubMatic, OpenX, Power BI, SSAS, SSMS, SQL Server, MySQL
Insight Global (AT&T — Contractor)
March 2022 – May 2022
Senior Data Engineer
  • Maintained and extended ADF pipelines supporting enterprise analytics for a large telecommunications client — diagnosing failures, implementing business logic updates, and ensuring reliable nightly data processing.
  • Built and maintained Power BI semantic models, DAX measures, dataflows, and datasets — supporting operational and executive reporting across business domains.
  • Short-term contract role; departed for a permanent position at National CineMedia.
Tools: T-SQL, SQL Server, Azure Data Factory, Azure DevOps, Power BI, SSAS, DAX, SSMS
Provisions Group
September 2021 – March 2022
Senior Data Engineer
  • Designed and maintained ADF pipelines and Power BI reporting solutions across multiple client engagements — delivering data engineering and BI support in a consulting capacity across varied business domains.
  • Built Power BI semantic models, DAX measures, dataflows, and datasets tailored to each client's reporting requirements — ensuring consistent, trustworthy outputs across engagements.
Tools: T-SQL, SQL Server, Azure Data Factory, Azure DevOps, Power BI, SSAS, DAX, SSMS
Various Employers
2013 – 2021
Data Engineer / BI Developer
  • Built and maintained ADF pipelines, SSIS packages, and SQL Server-based ETL workflows across full-time and contract roles — supporting data warehouse and reporting environments with full and incremental load patterns across cloud and on-premises environments.
  • Worked with Azure services including Azure Data Factory and Azure SQL alongside on-premises SQL Server — supporting gradual cloud adoption across multiple organizations and client engagements.
  • Designed and maintained Power BI semantic models, SSAS tabular models, DAX measures, calculated columns, and SSRS reports — delivering self-service and governed analytics across business domains including logistics, manufacturing, and enterprise clients.
Tools: Python, T-SQL, PL/SQL, DAX, SQL Server, Oracle, MySQL, Azure Data Factory, Azure SQL, Azure DevOps, Power BI, SSAS, SSRS, SSIS, SSMS, DAX Studio, Tabular Editor, Tableau
Tec-Masters Inc.
2002 – 2013
Database & Reporting Engineer / Technical Publications Developer
  • Designed and developed Class IV Interactive Electronic Technical Manuals (IETMs) for the US Marine Corps using Arbortext Epic Editor and IADS — authoring structured XML/SGML content in accordance with DoD CALS standards and enabling field personnel to access maintenance, logistics, and operational data electronically.
  • Built automated SQL jobs extracting data from MySQL databases, ensuring data integrity and reliable nightly processing — establishing early version control, automation, and documentation practices for production data workflows.
  • Developed Excel-based reporting solutions providing operational and financial visibility to leadership and program stakeholders.
  • Self-initiated and built an HTML/SQL Server web application that replaced a manual Word document workflow — enabling authors to submit technical manual updates directly into a database with automated email notifications, eliminating distribution bottlenecks and serving as the catalyst for a career transition into data engineering.
Tools: SQL Server Express, MySQL, HTML, T-SQL, MS Excel, Arbortext Epic Editor, IADS, XML, SGML
Military Service
United States Marine Corps Reserve  ·  Field Artillery Cannoneer  ·  October 2001 – 2005
Deployed to Iraq in 2004 in support of Operation Iraqi Freedom II (OIF II), serving with I MEF in the Al-Anbar Province — developing direct familiarity with DoD operational culture, mission-driven environments, and the importance of reliable information systems in high-stakes contexts.
Skills
Product Management
Agile/Scrum, product roadmap development, backlog grooming, sprint planning, user story authoring, requirements gathering, stakeholder management, KPI definition, acceptance criteria, data governance
Languages
Python, SQL, Spark SQL, DAX, M, T-SQL
Data Engineering
ETL/ELT pipelines, ADF pipeline operations & debugging, Fivetran vendor integrations, incremental sync patterns, MERGE-based upserts, metadata-driven architectures, batch processing
Platforms
Databricks, Azure Data Factory, Azure Data Lake Storage, Azure DevOps, Fivetran, Snowflake, AWS (Glue, Athena, Lambda, Redshift, S3), SQL Server, MySQL, DuckDB, MotherDuck, Supabase
BI & Semantic Layer
Power BI, SSAS (Tabular & Multidimensional), SSRS, DAX Studio, Tabular Editor, ALM Toolkit, Power BI Dataflows, Row-Level Security
Orchestration
Apache Airflow, Fivetran, SSIS, Dagster
DevOps & Governance
Azure DevOps, GitHub Actions, CI/CD, automated validation, access controls
Ad Tech & Domain
Programmatic advertising, DSP/SSP data integration, ad campaign & impression pipelines, ad measurement & attribution, cinema advertising — The Trade Desk, Xandr, PubMatic, OpenX, Innovid, Locality, PlaceExchange, Simplifi, Sizmek, StackAdapt, Vistar