Data Modeling & Transformations: (50%)

• Design and implement dbt models including base, intermediate, and mart layers
• Create dimension tables following data warehousing principles
• Implement business logic in transformations
• Set up incremental processing for data models

Data Quality Framework: (30%)

• Embed quality tests in dbt models (uniqueness, not-null, relationships)
• Set up data freshness checks
• Create custom data quality tests for business rules
• Monitor data quality metrics
• Establish and maintain alerting systems for quality issues

Data Governance & Standards: (10%)

• Develop and enforce naming conventions across databases and tools
• Create field-level standards (date formats, currency handling, etc.)
• Standardize calculations for key metrics
• Build and maintain data dictionaries
• Document business rules and assumptions

Process & Documentation: (10 %)

• Create PR templates for model changes
• Set up model documentation requirements
• Build style guides for SQL/dbt development
• Establish testing requirements for new models
• Create technical documentation

Qualifications

Required Skills:

• Strong SQL expertise
• Experience with dbt
• Understanding of git management
• Understanding of data modeling principles
• Experience with data quality implementation
• Strong documentation skills
• Ability to collaborate with technical and non-technical stakeholders