Coherent Pixel System Hiring – Consultant / Data Engineer
Location: Chennai
Mode: WFO / Hybrid
Shift: 12:00 PM – 9:00 PM
Experience: 3+ Years
Job Description
The Data Engineer is responsible for the hands-on development, maintenance, and optimization of robust end-to-end (E2E) analytics data pipelines. You will leverage a modern cloud stack including Azure, Snowflake, and dbt to ingest and transform data according to Data Vault 2.0 standards, while actively utilizing AI-assisted development tools to improve coding efficiency and delivery speed.
Responsibilities
- Build and maintain scalable, automated data ingestion and processing pipelines using Azure, dbt, and Snowflake.
- Extract data from various source systems and load it into Snowflake for downstream processing.
- Develop modular and testable SQL transformations using dbt.
- Implement physical Data Vault 2.0 structures including Hubs, Links, and Satellites.
- Use AI coding assistants such as GitHub Copilot and ChatGPT for:
- Boilerplate code generation
- dbt test creation
- Documentation drafting
- SQL/Python troubleshooting
- Ensure high data quality through automated dbt tests and validation checks.
- Collaborate closely with Tech Leads, Data Architects, and Business Analysts in an Agile environment.
Tools & Technologies
- Snowflake
- dbt
- Azure (ADF, ADLS)
- SQL
- Python
- Git
- CI/CD Tools
- AI-Assisted Coding Tools
Requirements
- 3+ years of hands-on experience in Data Engineering or Database Development.
- Strong expertise in writing optimized and complex SQL queries.
- Solid Python scripting skills.
- Hands-on experience with:
- Microsoft Azure (ADF, Data Lake Storage)
- Snowflake development and performance tuning
- dbt for transformation, testing, and documentation
- Familiarity with AI-assisted development tools like GitHub Copilot.
- Understanding of Data Vault 2.0 concepts including Hubs, Links, and Satellites.
Contact Details
Immediate Joiners Only Preferred
Drop your CV to:
Contact / WhatsApp:
Work Location: In person
