Senior Data Engineer Snowflake
InfoCepts
Job Title: Senior Data Engineer-Snowflake
Purpose of the Position: To lead the data engineering team in architecting and delivering enterprise-scale Snowflake solutions for retail analytics, ensuring alignment with strategic business goals and modernization initiatives.
Work Location: Chennai/Bangalore/Pune/Nagpur
Key Result Areas and Activities:
- Data Pipeline Development: Drive ingestion and transformation of multi-source retail data (MMS, CRM, Workday, Courion etc).
- Architecture Leadership: Define and implement Snowflake architecture for multi-layered retail data processing.
- ETL Strategy: Lead migration strategy from Netezza to Snowflake, ensuring automation and scalability.
- ETL Development: Build and optimize ETL workflows using Informatica, AWS Glue and SQL stored procedures.
- Strategic Alignment: Align data engineering practices with retail business priorities (sales, customer, workforce, inventory)
- Data Modelling: Create and maintain Snowflake tables and layered views for business consumption.
- Data Governance: Implement standards for lineage, documentation, and compliance.
- Collaboration: Coordinate with team members, work closely with data analysts, business stakeholders, and regulatory teams to understand data needs and deliver solutions.
- Performance Optimization: Ensure efficient query performance, storage management and cost-effective data processing in Snowflake.
- Documentation & Governance: Maintain clear documentation of data models, transformations, and lineage to support audit and compliance requirements.
- Team Leadership: Mentor and manage engineers across different levels, ensuring delivery excellence.
- Innovation: Explore snowflake features like dynamic tables, automation, and advanced Snowflake features for efficiency.