Looking for a job

Macaulay Madalene

@macaulaymadalene

Message

Analytics Engineer at Condé Nast who built 40+ Hex dashboards and dbt models for self-service analytics.

United States

Message

At Condé Nast, I engineered dbt models that transform Salesforce, Stripe, and PostgreSQL data into BigQuery schemas, giving more than 150 internal stakeholders self-service access to analytics. I also created 40+ Hex dashboards that reduced manual reporting by 18 hours a week.

Earlier, I built data pipelines and analytics platforms at Clearsense, LLC and Florida Blue, and delivered SQL and Tableau analytics for financial services clients at EY. At Condé Nast, I also spearheaded a migration to event-driven Apache Airflow DAGs, reducing pipeline failures by 67% and annual infrastructure costs by $45,000.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Engineer

Current

Condé Nast

Jan 2024 - Present (2 years 10 months)

Spearheaded migration of legacy ETL infrastructure from scheduled scripts to event-driven Apache Airflow DAGs, coordinating across 5 cross-functional teams and reducing pipeline failure incidents by 67% while cutting infrastructure costs by $45,000 annually.

Airflow ETL Data Engineering Migration Cross Functional Collaboration Cost Optimization

Current

Analytics Engineer

Current

Condé Nast

Jul 2021 - Present (5 years 4 months)

Engineered scalable dbt models transforming raw event and transactional data into BigQuery warehouse schemas, enabling 150+ internal stakeholders to access self-serve analytics. Constructed 40+ dashboards in Hex tracking product KPIs, customer health metrics, and revenue trends, reducing manual reporting overhead by 18 hours per week.

DBT BigQuery Hex Fivetran SQL Salesforce Stripe PostgreSQL Data Modeling ETL Data Warehouse Analytics Dashboarding Stakeholder Management

Data Engineer II

Clearsense, LLC

Jan 2020 - Jul 2021 (1 year 6 months)

Designed and deployed healthcare data integration workflows using Apache Airflow, orchestrating ETL jobs that consolidated patient records from 8 hospital systems into a unified analytics platform. Optimized BigQuery transformation queries through partitioning, clustering, and materialized views, reducing average query execution time from 45 seconds to 8 seconds.

Airflow BigQuery DBT SQL ETL Data Quality Healthcare Data Data Warehouse

Data Engineer

Florida Blue

Nov 2018 - Jan 2020 (1 year 2 months)

Built Python-based data pipelines extracting insurance claims and member enrollment data from legacy mainframe systems into Snowflake data warehouse, processing 120,000 claims daily. Created SQL-based transformation layer modeling insurance workflows and metrics, supporting 35+ analytical reports.

Python SQL Snowflake Data Pipelines ETL Data Warehouse Data Modeling Insurance

Data Analytics Associate

Jul 2017 - Nov 2018 (1 year 4 months)

Executed analytics engagements for 6 Fortune 500 financial services clients, translating business requirements into SQL queries and Tableau dashboards that surfaced cost reduction and revenue optimization opportunities. Developed Python scripts automating repetitive data extraction and validation tasks, reducing manual data preparation time by 12 hours per week.

SQL Tableau Python Data Analysis Exploratory Data Analysis Financial Services Fraud Detection Visualization