• Design, build, and maintain scalable ETL/ELT pipelines to ingest data from multiple sources including advertising platforms (Google Ads, Facebook Ads, Bing Ads), CRM systems, and operational databases • Manage and optimize our Snowflake data warehouse, including schema design, query performance tuning, and cost optimization • Configure and maintain Fivetran connectors and data integrations, ensuring data quality and timely syncs across all platforms • Develop and maintain data transformation layers using SQL and dbt to create clean, reliable datasets for analytics consumption • Build and manage automated workflows and Snowflake tasks for scheduled data refreshes and reporting • Partner with the analytics team to understand data requirements and translate them into robust technical solutions • Implement data quality monitoring, alerting, and validation frameworks to ensure accuracy and completeness • Document data models, pipelines, and processes to maintain institutional knowledge • Support HIPAA-compliant data handling practices and maintain appropriate access controls • Troubleshoot data issues and perform root cause analysis when discrepancies arise