Design and operate large-scale data models and batch/stream pipelines using Python, SQL, Presto and internal orchestration, supporting data products used by analytics and product teams. Build reusable, metadata-driven pipelines and data contracts with Python unit and integration tests, improving consistency and maintainability across workflows. Own pipeline reliability across SLAs, data quality, lineage and observability; partner with analytics and product stakeholders to prevent failures and resolve data issues. Act as technical and product owner for reporting pipelines, translating business requirements into scalable data solutions.

Built and maintained ELT pipelines across subscription, revenue and productivity domains using Snowflake, dbt Core/Cloud, Airflow, AWS Glue, Fivetran and Terraform. Designed incremental models, SCD2 dimensions and surrogate-key strategies; implemented dbt tests and Python-based data-quality checks. Established dbt CI workflows, automated documentation and lineage, and improved build times by ~60% through incremental refactoring, scan pruning and join optimization. Reduced new-domain onboarding time by ~50% using reusable macros, templates and a modular data-modeling framework.

Built scalable Snowflake analytics pipelines with dbt Core, Fivetran, AWS Glue and Airflow across multiple business domains. Developed reusable Python metamodels to automate dbt model generation, standardize project structure and accelerate client onboarding. Implemented automated data-quality validation using dbt tests and custom Python checks.

Led migration of SQL Server tables and stored procedures to Snowflake using Snowpark; migrated ~80% of production stored procedures and introduced testing and quality controls. Built optimized ELT sources with SQL, Python, Jinja and dbt Cloud, transforming production data into trusted metrics and analytical datasets. Delivered stakeholder-facing KPIs and reporting in Sigma and Power BI and defined quality and accuracy standards for production reporting.

Led Oracle and SQL database migrations to cloud data platforms using AWS, Azure, dbt and Snowflake. Built ETL/ELT sources using SQL, NoSQL, Python and Jinja and developed business metrics, KPIs and reporting across Tableau, Power BI, Sigma and Looker. Refactored tables and views and optimized commercial and sales reporting to improve consistency and decision-making.

Built and maintained Snowflake/dbt transformations for billing and transportation-management analytics and managed electronic data exchange with 700+ carriers worldwide. Delivered 30+ EDI billing projects using WinSQL, B2BI and IBM Gentran, improving customer billing processes by ~80%. Migrated a 700+ carrier server to an SFTP model in IBM B2BI, strengthening security and confidentiality.

Managed Oracle and SQL database backups, contingency plans and public-cloud operations; used dbt and Airflow to automate Snowflake transformations and table loads. Designed Oracle scalability plans using RAC and Linux and standardized databases serving 5,000+ beneficiaries across 50+ municipalities. Reduced public-procurement operating costs by ~30% through a data-driven decision-support system.