Job Description
- Strong SQL & DBT Expertise
- Experience building and maintaining scalable data models in DBT .
- Proficient in modular SQL , Jinja templating , testing strategies, and DBT best practices.
- Data Warehouse Proficiency
- Hands-on experience with Snowflake including:
- Dimensional and data vault modeling (star/snowflake schemas)
- Performance optimization and query tuning
- Role-based access and security management
- Data Pipeline & Integration Tools
- Experience with Kafka (or similar event streaming tools) for ingesting real-time data.
- Familiarity with SnapLogic for ETL/ELT workflow design, orchestration, and monitoring.
- Version Control & Automation
- Proficient in Git and GitHub for code versioning and collaboration.
- Experience with GitHub Actions or other CI/CD tools to automate DBT model testing, deployment, and documentation updates.
- Data Quality & Governance
- Strong understanding of data validation, testing (e.g., dbt tests), and lineage tracking.
- Emphasis on maintaining data trust across pipelines and models.
- Stakeholder Management
- Partner with business and technical stakeholders to define data needs and deliver insights.
- Ability to explain complex data concepts in clear, non-technical terms.
- Documentation & Communication
- Maintain clear documentation for models, metrics, and data transformations (using DBT docs or similar).
- Strong verbal and written communication skills; able to work cross-functionally across teams.
- Problem-Solving & Ownership
- Proactive in identifying and resolving data gaps or issues.
- Self-starter with a continuous improvement mindset and a focus on delivering business value through data.
- IAC
- deploy scalable, secure, and high-performing Snowflake environments in line with data governance and security in palce using Terraform and other automation scripit
- Automate infrastructure provisioning, testing, and deployment for seamless operations.
Key skill Required
- SQL
- GitHub
- Automation
- Data Governance
- CI/CD
- Collaboration
- Communication
- Data Quality
- Data Validation
- Data Warehouse
- Design
- Documentation
- Git
- Governance
- Infrastructure
- Integration
- Jinja
- Management
- Modular
- Optimization
- Orchestration
- Ownership
- Pipeline
- Proactive
- Security
- Security Management
- Stakeholder Management
- Terraform
- Validation
- Version Control
- Versioning
- Workflow
- Workflow Design
- Written Communication
