Senior Data Engineer (DBT)

Senior Data Engineer (DBT) – Financial Services - W2 Requirement Location: Irvine, CA (Onsite – 5 Days/Week) Duration: Long-Term Contract Job Summary We are seeking a Senior Data Engineer with strong expertise in DBT (Data Build Tool) and the Financial Services domain. The ideal candidate will have experience building scalable ELT pipelines, designing enterprise data warehouses, and supporting financial reporting and analytics using modern cloud technologies. Required Experience • 8+ years of Data Engineering experience. • 3+ years of hands-on DBT experience. • Financial Services experience (Banking, Asset Management, Wealth Management, Capital Markets, Investment Management, or Mutual Funds). Required Skills • DBT (Data Build Tool) • Snowflake • Advanced SQL • Python • ETL/ELT Pipeline Development • Data Warehousing & Data Modeling (Star/Snowflake Schema) • Git/GitHub & CI/CD • AWS, Azure, or GCP • Data Quality Testing & Performance Tuning • Agile/Scrum Preferred Skills • Airflow or Dagster • Azure Data Factory (ADF) • Databricks • Power BI or Tableau • Kafka, REST APIs, Terraform, Shell Scripting Domain Expertise Experience with Financial Reporting, Portfolio Management, Securities, Equities, Fixed Income, Risk & Compliance, Regulatory Reporting, Trading Platforms, Hedge Funds, and Investment Management. Responsibilities • Develop and maintain DBT models, macros, snapshots, and incremental pipelines. • Build scalable ELT pipelines using DBT, Snowflake, SQL, and Python. • Design dimensional data models and optimize SQL/DBT performance. • Integrate data from multiple financial systems into enterprise data warehouses. • Implement data quality, testing, monitoring, and production support. • Collaborate with Business Analysts, Architects, Finance teams, and Product Owners. • Participate in code reviews, CI/CD deployments, documentation, and Agile ceremonies.