Lead Snowflake Data Engineer

Position overview :

We are looking for a hands-on Lead Data Engineer to join our team! In this role, you will be responsible for leading the team of data engineers (Onsite / Offshore) to build new data pipelines (loading millions of transformed true records into our cloud data warehouse in a timely manner) to support evolving analytical needs for critical business decisions. Manage existing data pipelines keeping data relevant and true, ready for analytical consumption.

Key responsibilities :

• Lead data warehouse development activities for a team,
• Lead more than one project in parallel.
• ssign data warehouse development tasks to team of 1-6 developers (Onsite / Offshore).
• Be a subject-matter expert (SME) in Data Warehouse domain and relevant business function.
• Work with minimal supervision and provide status updates and escalation to leadership as appropriate.
• Provides application support as part of an on-call rotation to work on resolving outages and user questions.
• Review project objectives and determine best technology to apply.
• Design and build large scale datasets for a wide range of consumer needs.
• Build, test and implement highly efficient data pipelines using a variety of technologies.
• Develop best practice standards for solution design and data structures.
• Create and maintain project specific documentation like architecture diagrams, flow charts
• nalyze new data sources to understand quality, availability, and content.
• Write technical design documentation.
• Conducts peer code reviews.
• Create and executes unit tests.
• Supports QA team during testing.
• Mentor less experienced members of the development team.

Technical skills :

o Hands on experience on AWS on Lambda, S3, SNS / SQS, EC2 is a bare minimum,

Must have soft skills :

Enterprise Experience - Understands and follows enterprise guidelines for CICD, security, change management, RCA, on-call rotation etc,

Nice to have :

Technical certifications from AWS, Microsoft, Azure, GCP or any other recognized Software vendor,

4 years+ on any ETL / ELT tool - Informatica, Pentaho, Fivetran, DBT etc.

4 years+ with developing functional metrics in any specific business vertical (finance, retail, telecom etc),

4 years+ with team lead experience,

3 years+ in a large-scale support organization supporting thousands of users,