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