What are the responsibilities and job description for the DBT Developer - Irvine, CA - ONLY LOCAL TO CALIFORNIA position at Geopaq Logic?
Job Title: DBT Developer
Location: Irvine, CA
Duration: 6 Months of Contract
Required Qualifications:
Minimum 4 years of experience in data engineering, analytics engineering, BI engineering, data warehousing, or data transformation roles.
Strong hands-on experience with dbt Core and/or dbt Cloud, including dbt models, macros, tests, snapshots, seeds, sources, packages, documentation, lineage, and project structure.
Strong experience using dbt with Snowflake to build scalable ELT transformation pipelines, curated data models, and analytics-ready datasets.
Strong SQL development skills with experience writing complex transformations, performing data validation, troubleshooting data issues, and analyzing large datasets.
Strong understanding of dbt best practices for modular, testable, well-documented projects.
Hands-on Snowflake experience, including databases, schemas, tables, views, warehouses, roles, access controls, query optimization, and performance considerations.
Strong understanding of data modeling concepts, including star schema, fact and dimension tables, slowly changing dimensions, staging layers, data marts, and semantic/reporting layers.
Experience with data reconciliation and business rule validation.
Ability to translate business requirements, source-to-target mappings, metric definitions, and reporting logic into technical specifications and dbt transformation models.
Good troubleshooting and analytical skills with the ability to identify root causes of data issues, failed transformations, and performance bottlenecks.
Bachelor’s degree in Computer Science, Engineering, Information Systems, Data Analytics, Business Analytics, or a related technical field. Equivalent practical experience may also be considered