<div>Born with an intense desire to offer professional and purposeful solutions to today’s business ultimatums, ALTRAIZE offers well researched alternatives to meet challenges in Human Resource Management.</div><div>Altraize sets itself ahead as it:</div><div>• Aims at reinventing itself and implementing new ideas, evolving itself into a contemporary and a forward thinking organisation.</div><div>• Believes in being professional and at the same time giving a personal touch, working closely with its clients and candidates. • Superior process and software applications to manage database, track applications, offer status.</div><div>• A fun place to work, learning and rewarding its employees a platform to execute their ideas, own up the process and a rewarding career.</div><div>• Has Knowledge of different industries, market trends, hiring trends, talent availability (spread &amp; cost),</div><div>• Aims to be a global service provider and become a world-class organization.</div>

ALTRAIZE

Shift: 2:00 PM – 11:00 PM IST Job Summary
We are looking for a skilled Data Engineer with 4+ years of hands-on experience in building and maintaining scalable data platforms and ETL/ELT solutions.
The ideal candidate should have strong production experience with Python, SQL, Snowflake, DBT, and Apache Airflow/Prefect, along with exposure to analytics and BI tools such as DOMO. The candidate should be experienced in developing reliable, high-performance data pipelines that support analytics, reporting, and business decision-making.
Key Responsibilities
<ul>
<li>
Design, develop, and maintain scalable ETL/ELT pipelines using Python and SQL.
</li>
<li>
Ingest, transform, validate, and deliver high-quality data from multiple sources.
</li>
<li>
Build, schedule, monitor, and troubleshoot automated workflows using Apache Airflow or Prefect.
</li>
<li>
Develop and maintain DBT models for data transformation, testing, documentation, and reusable data models.
</li>
<li>
Design, implement, and optimize data warehouse solutions using Snowflake and GCP BigQuery.
</li>
<li>
Perform schema design, query optimization, performance tuning, and cost optimization.
</li>
<li>
Write complex and optimized SQL queries for data extraction, transformation, reporting, and analytics.
</li>
<li>
Implement data quality checks, validation frameworks, monitoring, error handling, and pipeline performance improvements.
</li>
<li>
Collaborate with Data Analysts, Data Scientists, Product Teams, and Business Stakeholders to understand requirements and deliver scalable data solutions.
</li>
<li>
Follow data engineering best practices related to Git, version control, testing, documentation, governance, and maintainability.
</li>
<li>
Implement monitoring, logging, and observability practices for production data pipelines.
</li>
</ul>
Required Skills &amp; Experience
<ul>
<li>
4+ years of hands-on experience in Data Engineering.
</li>
<li>
Strong hands-on experience with Snowflake and DBT — mandatory.
</li>
<li>
Strong SQL skills, including: Complex queries, Joins, CTEs ,Window functions,&nbsp; Query optimization, Performance tuning
</li>
<li>
Recent hands-on production experience with Snowflake, DBT, and SQL.
</li>
<li>
Strong proficiency in Python.
</li>
<li>
Strong experience developing DBT models, transformations, tests, and documentation.
</li>
<li>
Good understanding and hands-on experience in Data Modeling, including dimensional modeling.
</li>
<li>
Experience with workflow orchestration tools such as Apache Airflow or Prefect.
</li>
<li>
Experience with DOMO or other Analytics/BI tools.
</li>
<li>
Proven experience designing, developing, and optimizing ETL/ELT pipelines.
</li>
<li>
Strong understanding of data quality, troubleshooting, query optimization, and performance tuning.
</li>
<li>
Good analytical, problem-solving, communication, and collaboration skills.
</li>
</ul>
Preferred Qualifications
<ul>
<li>
Experience with Google Cloud Platform (GCP) and cloud-based data platforms.
</li>
<li>
Knowledge of CI/CD practices for data engineering projects.
</li>
<li>
Hands-on experience with Git and version control.
</li>
<li>
Experience implementing monitoring, logging, and observability for data pipelines.
</li>
<li>
Experience working in production-scale data warehouse environments.
</li>
</ul>
Technical SkillsAreaRequired SkillsProgrammingPython, SQLData ModelingDimensional Modeling, Data Warehouse ModelingData WarehousingSnowflake – Strong Hands-on Experience RequiredData TransformationDBT – Strong Hands-on Experience RequiredWorkflow OrchestrationApache Airflow / PrefectAnalytics / BIDOMO or any Analytics/BI ToolCloudGCP / BigQueryCore ExpertiseETL/ELT, Data Quality, Query Optimization, Performance TuningVersion ControlGitMonitoringLogging, Monitoring &amp; ObservabilityCandidate Screening Criteria
Snowflake, DBT, and SQL are core requirements for this role.
Candidates should be able to demonstrate:
<ul>
<li>
Strong fundamentals in Snowflake, DBT, and SQL.
</li>
<li>
Recent, hands-on experience working with these technologies in a production data engineering environment.
</li>
<li>
Experience designing and optimizing real-world ETL/ELT pipelines.
</li>
<li>
Strong understanding of data modeling and data warehouse concepts.
</li>
<li>
Practical experience troubleshooting and optimizing production data pipelines.
</li>
</ul>
Candidates without recent hands-on production experience in Snowflake and DBT may not be considered.
What We're Looking For
We are looking for someone who can take ownership of data engineering initiatives, build reliable and scalable pipelines, troubleshoot production issues, and work closely with cross-functional teams to deliver high-quality data solutions.