Position : Senior Data Engineer (Snowflake, dbt &

- Matillion)

Department : Information Technology

Job Location : Ahmedabad / Hyderabad (Work From Office 5 Days a Week)

Experience : 5- 8 Years

About :

Our client helps organizations solve complex business challenges through up-to-date data platforms, cloud technologies, artificial intelligence, and automation. Our mission is to transform businesses into intelligent, data-driven enterprises by delivering scalable, secure, and high-performance data solutions. Our team combines deep consulting expertise with cutting-edge technologies to build robust analytics platforms that enable informed decision-making, operational excellence, and business transformation.

Role Overview :

Our Client is looking for an experienced Senior Data Engineer to design, build, and optimize enterprise-scale cloud data platforms using Snowflake, dbt, and Matillion Data Productivity Cloud (DPC). The ideal candidate will lead end-to-end implementation of modern ELT architectures, develop scalable data models, optimize cloud data warehouses, mentor engineering teams, and collaborate with clients to deliver production-ready data solutions. This is a client-facing leadership role requiring strong technical expertise, architectural thinking, and project ownership.

Key Responsibilities :

- Design and develop scalable ELT pipelines using Snowflake, dbt, and Matillion Data Productivity Cloud.
- Architect modern cloud data platforms using Medallion Architecture (Bronze, Silver, Gold).
- Build reusable and modular dbt models, macros, tests, packages, and documentation.
- Develop ingestion pipelines from APIs, databases, Azure Data Lake, AWS S3, and cloud storage using Matillion.
- Optimize Snowflake performance through warehouse tuning, clustering, query optimization, and cost management.
- Design dimensional data models including Star Schema, Snowflake Schema, and Slowly Changing Dimensions (SCD).
- Build orchestration workflows using dbt Cloud, Matillion DPC, Airflow, or Azure Data Factory.




- Implement CI/CD pipelines and version control using Git.
- Ensure data quality through automated testing, validation frameworks, and monitoring.
- Implement enterprise data governance, security, encryption, RBAC, and secure data sharing.
- Collaborate with business stakeholders, architects, analysts, and data scientists to deliver business-ready data products.
- Lead architecture reviews, mentor junior engineers, and establish engineering best practices.
- Own project delivery from requirement gathering through deployment and post-production support.

Mandatory Skills :

- Snowflake
- dbt
- Matillion ETL / Matillion Data Productivity Cloud (DPC)
- SQL
- ETL / ELT Pipeline Development
- Cloud Storage (Azure Data Lake, AWS S3)
- Data Modelling
- Medallion Architecture
- Dimensional Modelling
- Data Warehousing
- Project Ownership
- Data Security &
- Governance
- Git &
- CI/CD

Preferred Skills :

- Python
- Airflow
- Azure Data Factory
- REST API Integration
- Jinja
- Apache Spark
- AI/ML Data Pipelines
- MLflow
- Data Quality Frameworks
- Agile/Scrum
- Docker or Kubernetes

Technical Requirements :

1.

Cloud Data

Engineering :

- Expert-level experience with Snowflake architecture and performance optimization.
- Strong experience developing production-grade dbt projects.
- Hands-on expertise with Matillion Data Productivity Cloud or Matillion ETL.
- Experience building scalable cloud-native ELT pipelines.

2. Data Modelling :

- Star Schema
- Snowflake Schema
- Slowly Changing Dimensions (SCD)
- Medallion Architecture
- Modern Data Warehouse Design

3. Data Integration :

- Azure Data Lake
- AWS S3




- REST APIs
- Structured and Semi-Structured Data
- JSON, CSV, Parquet

4. Programming :

- SQL
- Python
- Git Version Control
- Jinja (Preferred)

5. Security &

- Governance :
- Snowflake RBAC
- Encryption
- Secure Data Sharing
- Credential Management
- Data Validation
- dbt Tests
- Matillion Validation Components

Leadership &

- Soft Skills :
- Strong client-facing communication skills.
- Excellent stakeholder management.
- Ability to own projects from design to production deployment.
- Experience mentoring and coaching junior engineers.
- Strong analytical and problem-solving abilities.
- Ability to manage multiple priorities in a quick-paced consulting environment.
- Experience working in Agile/Scrum delivery models.

Required Qualifications :

- Bachelor's or Master's degree in Computer Science, Information Technology, Data Engineering, or a related field.

Preferred Certifications :

- Snowflake SnowPro Certification
- dbt Certified Developer
- Matillion Associate or Professional Certification
- Cloud Certifications (AWS, Azure, or GCP)

Why Join Logic Pursuits?

- Work with cutting-edge cloud data technologies including Snowflake, dbt, and Matillion Data Productivity Cloud.
- Lead enterprise-scale data engineering initiatives.
- Collaborate with experienced consultants and data professionals.
- Gain ownership of high-impact client projects.
- Continuous learning, certification support, and career growth opportunities.
- Competitive compensation and an innovation-driven work environment.

Employment Details :

- Employment Type : Full-Time
- Work Mode : Work From Office (5 Days a Week)
- Location : Ahmedabad / Hyderabad
- Interview Process : 3 - 4 Rounds

Key Hiring Guidelines :

- Immediate joiners or candidates with a maximum 15-day notice period only.
- This is a 100% Work From Office role (No Hybrid/Remote).
- Preference will be given to candidates based in Ahmedabad or Hyderabad.

📌 Senior Data Engineer - Snowflake/Matillion (India)
🏢 One stop shop advisory services (ossas)
📍 India