Data Engineer – Python | dbt | Redshift | AWS

Data Engineer – Python | dbt | Redshift | AWS
About the Company
Catalyst Info Labs Pvt.

Ltd.

is a growing software solutions company focused on developing scalable, data-driven platforms that empower businesses with actionable insights.

We are looking for a skilled Data Engineer to join our team and contribute to the design, development, and optimization of high-performance data pipelines and infrastructure.
Key Responsibilities
Design, develop, and maintain data pipelines and ETL/ELT processes to support analytics and business operations.
Build and optimize data models using dbt (data build tool) and manage transformations within Amazon Redshift.
Write and optimize SQL queries for data processing and reporting.
Ensure the reliability, performance, and scalability of data infrastructure on AWS.
Collaborate with cross-functional teams including data analysts, scientists, and business stakeholders to ensure data quality and usability.
Implement and manage version control using Git for dbt projects.
Support workflow orchestration using tools such as Airflow, Dagster, or Prefect.
Maintain documentation for data pipelines, models, and processes.
Required Technical Skills
Strong proficiency in Python for data processing, automation, and ETL pipeline development.
Hands-on experience with dbt for transformation and data modeling.
In-depth knowledge of Amazon Redshift architecture, optimization, and best practices.
Expertise in SQL, including complex queries, window functions, and performance tuning.
Understanding of data warehouse design principles, dimensional modeling, and star/snowflake schemas.
Experience working with AWS services such as S3, Lambda, Glue, and Step Functions.
Familiarity with IAM policies, data security, and access management within AWS.
Preferred Qualifications
Experience with CI/CD implementation for data pipelines.
Exposure to data governance and data lineage tools.
Experience with Snowflake, BigQuery, or other cloud data warehouses.
Knowledge of streaming technologies such as Kafka or Kinesis.
Experience with Infrastructure as Code tools like Terraform or CloudFormation.
Experience Levels
Junior (1–3 years): Exposure to dbt and Redshift.
Mid-level (3–5 years): Proven experience managing production data pipelines.
Senior (5+ years): Expertise in data architecture, performance optimization, and mentoring.
Soft Skills
Strong analytical and problem-solving skills.
Excellent verbal and written communication abilities.
Attention to detail with a focus on data quality, testing, and monitoring.
Ability to collaborate effectively in a fast-paced, cross-functional environment.
How to Apply
Interested candidates can apply directly on LinkedIn or send their resumes to hr@catalystinfolabs.com
with the subject line: “Application – Data Engineer – [Your Name]”