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
Apply via :
job-boards.greenhouse.io
