DBT / Analytical Engineer

InApp Inc.; United States; Hybrid; USD 110,000 - 165,000; Full time

Job summary

InApp Inc. seeks a DBT / Analytical Engineer with 4–7 years of experience for remote/hybrid work in the United States.

You will design scalable data models, implement dbt pipelines, and optimize Snowflake schemas to deliver trustworthy analytics assets. Responsibilities include translating business needs into reusable models, ensuring data quality, and collaborating on data governance and CI/CD practices within analytics projects.

Qualifications

• Experience with dimensional modeling and Kimball methodology
• Snowflake/Advanced SQL optimization
• dbt Core or Cloud and layer design
• Analytics engineering translating business requirements into data models
• Data warehousing exposure with ERP/financial data

Responsibilities

• Translate business requirements into reusable data models
• Build semantic datasets and ensure data lineage
• Implement data quality testing frameworks
• Support cross-system integrations and master data alignment

Skills

SQL proficiency

Analytical thinking

Data modeling

Data governance

Education

Bachelor's degree in a related field

Tools

dbt Core/Cloud

Snowflake

ETL tools

Git CI/CD

Job description

DBT / Analytical Engineer

Experience : 4-7 Years Project Location(s) : Remote/Hybrid

Notice Period: Immediate to 10 days

Data Modeling (Highest Priority)

• Dimensional modeling (Kimball methodology)
• Star and snowflake schema design
• Slowly Changing Dimensions (SCD Type 1 & 2)
• Conformed dimensions
• Fact, dimension, bridge, and factless fact tables
• Data warehouse design patterns

Snowflake

• Advanced SQL
• Query optimization and performance tuning
• Data sharing, security, and access control
• Data governance best practices

dbt

• dbt Core and/or dbt Cloud
• Staging, intermediate, and mart layer design
• Testing, documentation, and exposures
• Incremental models
• Git workflows and CI/CD practices

Analytics Engineering

• Translating business requirements into reusable data models
• Building semantic and business-friendly datasets
• Data lineage and impact analysis
• Data quality and testing frameworks

Data Warehousing Experience (High Priority)

Experience designing analytical models for:

• ERP systems (Deltek, CMiC, SAP, Oracle, etc.)
• Financial and accounting data
• Payroll and HCM data
• Project management and construction data (preferred)
• Procurement and vendor management
• Cross-system integrations and master data alignment