Data Engineers with 3–5 years of experience
for a dedicated, long-term engagement with a leading US manufacturing client. The role focuses on designing, developing, and maintaining scalable data pipelines, enterprise data integrations, and reliable data products supporting reporting, analytics, and business decision-making.
Required Skills
- Strong hands-on experience with Snowflake, Python, SQL, and dbt (Data Build Tool).
- Experience designing and developing ETL/ELT pipelines and data integration workflows.
- Knowledge of CI/CD pipelines, Git, and version control.
- Experience with API integrations, data warehousing, and dimensional data modeling.
- Understanding of data quality, monitoring, testing, troubleshooting, and performance optimization.
- Strong communication skills and ability to collaborate with US-based stakeholders.
Preferred Skills
- Experience with Atlan for data cataloging, governance, and lineage management.
- Experience with ThoughtSpot or similar business intelligence and analytics platforms.
- Knowledge of data product development and curated datasets.
- Familiarity with AWS, Azure, or other cloud platforms.
- Experience with manufacturing or supply chain data.
Position Details
- Position: Data Engineer – Snowflake & dbt
- Experience: 3–5 Years
- Openings: 2
- Location: CapeStart Offshore Delivery Center, India
- Employment Type: Full-time, Long-term Engagement
- Shift Timing: Approximately 3:30 PM – 12:30 AM IST (subject to US daylight saving time and client requirements)
- Joining: Immediate
We are looking for technically proficient, self-driven Data Engineers who can independently deliver high-quality data solutions, demonstrate strong ownership, and contribute to enterprise data platform modernization initiatives.
Roles and Responsibilities
Design, develop, test, and maintain scalable ETL/ELT data pipelines using Snowflake, Python, SQL, and dbt (Data Build Tool).
- Develop and optimize dbt models, transformations, macros, tests, and documentation to support enterprise data processing and analytics.
- Build and maintain data integration solutions using APIs, databases, and enterprise data sources.
- Design reusable data models, curated datasets, and data products to support business intelligence, reporting, and analytics.
- Optimize Snowflake queries, data transformations, and storage strategies for performance, scalability, and cost efficiency.
- Implement automated data quality checks, monitoring, alerting, and validation processes to ensure data accuracy, reliability, and completeness.
- Develop and maintain CI/CD pipelines using Git, GitHub Actions, Azure DevOps, or similar tools to automate deployment and testing.
- Support data governance, security, privacy, and compliance initiatives by following established enterprise standards.
- Work with Atlan, ThoughtSpot, and other data cataloging or BI tools, where applicable, to support data discovery, governance, and business analytics.
- Collaborate with US-based Data Platform teams, business analysts, architects, and stakeholders to understand requirements and deliver scalable data solutions.
- Contribute to cloud data platform modernization, automation, architecture improvements, and operational excellence initiatives.
- Troubleshoot data pipeline failures, resolve integration issues, and provide ongoing operational support.
- Create and maintain technical documentation, data lineage information, and operational support materials.
- Independently manage assigned development tasks, participate in code reviews, and ensure timely delivery of high-quality solutions.