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 modern 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 fast-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

Important 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.