Locations- Hyderabad/ Ahmedabad
Department: Information Technology
Experience: 3 to 5 Years
Mandatory Skills
Snowflake DBT Matillion, Matillion DPC Cloud Storage Data Modelling Medallion Architecture Project Ownership ETL Data Security
Job Description
We are seeking a highly skilled and experienced Senior Data Engineer to join our growing data team at Logic Pursuits. In this role, you will lead the design and implementation of scalable, high-performance data pipelines using Snowflake, dbt, and Matillion Data Productivity Cloud, define architectural best practices, and drive data transformation at scale. You’ll work closely with clients to translate business needs into robust data solutions and play a key role in mentoring junior engineers, enforcing standards, and delivering production-grade data platforms.
Key Responsibilities
- Architect and implement modular, test-driven ELT pipelines using dbt and Matillion Data Productivity Cloud on Snowflake.
- Design layered data models (e.g., staging, intermediate, mart layers / medallion architecture) aligned with dbt and Matillion best practices.
- Lead ingestion of structured and semi-structured data from APIs, flat files, cloud storage (Azure Data Lake, AWS S3), and databases into Snowflake using Matillion’s native connectors and custom components where required.
- Optimize Snowflake for performance and cost: warehouse sizing, clustering, materializations, query profiling, and credit monitoring.
- Apply advanced dbt capabilities including macros, packages, custom tests, sources, exposures, and documentation using dbt docs.
- Build reusable Matillion pipelines, shared jobs, and orchestration flows on the Data Productivity Cloud, integrating them with dbt transformations for end-to-end data delivery.
- Orchestrate workflows using dbt Cloud, Matillion Data Productivity Cloud, Airflow, or Azure Data Factory, integrated with CI/CD pipelines.
- Define and enforce data governance and compliance practices using Snowflake RBAC, secure data sharing, and encryption strategies.
- Collaborate with analysts, data scientists, architects, and business stakeholders to deliver validated, business-ready data assets.
- Mentor junior engineers, lead architectural/code reviews, and help establish reusable frameworks and standards across dbt, Matillion, and Snowflake.
- Engage with clients to gather requirements, present solutions, and manage end-to-end project delivery in a consulting setup
Required Qualifications
- 3 to 5 years of experience in data engineering roles, with 2+ years of hands-on experience working with Snowflake and dbt in production environments, and demonstrable project experience with Matillion (Data Productivity Cloud or Matillion ETL)
Technical Skills:
◦ Cloud Data Warehouse & Transformation Stack:
1. Expert-level knowledge of SQL and Snowflake, including performance optimization, storage layers, query profiling, clustering, and cost management.
2. Experience in dbt development: modular model design, macros, tests, documentation, and version control using Git.
3. Hands-on experience with Matillion Data Productivity Cloud, including Designer pipelines, orchestration jobs, transformation jobs, variables, shared jobs, and Git-based project management.
◦ Orchestration and Integration:
1. Proficiency in orchestrating workflows using dbt Cloud, Matillion Data Productivity Cloud, Airflow, or Azure Data Factory.
2. Comfortable working with data ingestion from cloud storage (e.g., Azure Data Lake, AWS S3) and APIs, including building Matillion pipelines that consume REST APIs and leverage native SaaS connectors.
◦ Data Modelling and Architecture:
1. Dimensional modelling (Star/Snowflake schemas), Slowly changing dimensions.
2. Knowledge of modern data warehousing principles.
3. Experience implementing Medallion Architecture (Bronze/Silver/Gold layers) using a combination of Matillion for ingestion and staging and dbt for downstream transformations.
4. Experience working with Parquet, JSON, CSV, or other data formats.
◦ Programming Languages:
1. Python: For data transformation, notebook development, automation, and extending Matillion via Python script components.
2. SQL: Strong grasp of SQL for querying and performance tuning.
3. Jinja (nice to have): Exposure to Jinja for advanced dbt development.
◦ Data Engineering & Analytical Skills:
1. ETL/ELT pipeline design and optimization across dbt and Matillion.
2. Exposure to AI/ML data pipelines, feature stores, or MLflow for model tracking (good to have).
3. Exposure to data quality and validation frameworks.
◦ Security & Governance:
1. Experience implementing data quality checks using dbt tests and Matillion validation components.
2. Data encryption, secure key management, and security best practices for Snowflake, dbt, and Matillion (credential management, OAuth, workspace/environment isolation).
Soft Skills & Leadership:
- Ability to thrive in client-facing roles with competing/changing priorities and fast-paced delivery cycles.
- Stakeholder Communication: Collaborate with business stakeholders to understand objectives and convert them into actionable data engineering designs.
- Project Ownership: End-to-end delivery including design, implementation, and monitoring.
- Mentorship: Guide junior engineers and establish best practices; Build new skill in the team.
- Agile Practices: Work in sprints, participate in scrum ceremonies, story estimation.
- Education:
◦ Bachelor’s or master’s degree in computer science, Data Engineering, or a related field.
◦ Certifications such as Snowflake SnowPro Advanced, dbt Certified Developer, and Matillion Associate or Professional Certification (Data Productivity Cloud) are a plus.
Additional Information
Why Join Us?
- Work on modern data architecture at scale using cutting-edge technologies alongside best-inclass tools like Snowflake, dbt, and Matillion Data Productivity Cloud.
- Collaborate with a dynamic and talented team of data professionals.
- Grow your leadership skills through hands-on project ownership and mentorship.
- Competitive compensation, flexible work options, and continuous learning culture.
- This is 5 days work from office role
- Interview process- 3-4 rounds in the process
Required Qualification
Bachelor of Engineering - Bachelor of Technology (B.E./B.Tech.) ,
Pay: ₹800,000.00 - ₹1,600,000.00 per year
Application Question(s):
- Which cloud you have hands on experience?
- Experience in End to End project ownership?
- Experience in Matillion ETL tool/ Matillion DPC ?
- Years of experience in Snowflake and DBT?
- We are looking for candidate who can join within 15 days, Can you join within 15 days of selection?
- What is your current & expected salary?
Work Location: In person
