Brett Rocco - Senior Data Engineer

I design and build scalable data systems for Finance & Enterprise analytics.

About Me

I am a Senior Data Engineer with over 15 years of experience designing scalable data pipelines, warehouses, and analytics solutions. My work bridges deep technical expertise in Snowflake, DBT, Airflow, and Python with business domain knowledge in Finance and FP&A systems (OneStream, SAP BPC, Hyperion). I thrive on building reliable data systems that empower Finance and business teams to make faster, data-driven decisions.

Featured Project

Stock Dashboard (Supabase + Python + Finnhub API)

A live project that collects daily stock price data into Supabase, refreshed automatically via GitHub Actions. The dashboard highlights price changes and sector breakdowns, showing end-to-end data engineering in action.

See All Projects

Experience

Finance Data Pipelines (Snowflake + DBT + OneStream)

Built ELT pipelines to integrate ERP actuals data from SAP and Snowflake into OneStream for FP&A, ensuring accurate and timely reporting during monthly close and forecasting cycles. Leveraged DBT and Airflow to orchestrate transformations, improving scalability, reliability, and Finance team efficiency.

Python Automation for FP&A

Developed a Python-based automation framework that streamlined recurring Finance data prep tasks. Eliminated manual effort and saved the FP&A team 100+ hours annually while reducing the risk of errors in close processes.

Legacy ETL Optimization (Oracle + ODI + Hyperion/HFM)

Optimized legacy PL/SQL and ODI ETL pipelines feeding Hyperion/HFM, reducing runtimes by over 50%. Enabled faster data availability for Finance, shortening close timelines and accelerating decision-making.

Contact

Interested in collaborating or learning more about my work?