Lead Software / Platform Engineer I

Position Summary:

This role will mainly help design, build data models, and oversee implementation of data pipelines on our Snowflake data platform(“DAX”). You will work with Snowflake, Erwin and Matillion to develop scalable and efficient data pipelines that support our business needs.

A strong understanding of data modeling principles is essential to build robust data pipelines based on our Data Architecture. Additionally, familiarity with DevOps models, CI/CD workflows and best practices is important.

Key Responsibilities:

Core Deliverables:

• Develop and deliver Conceptual/Logical/Physical data models
• Develop data mappings and transformation rules document
• Develop business glossaries (metadata) and relevant data model documentation (data dictionaries) for data and analytics solutions.

Responsibilities:

• Work with business SMEs and data stewards to align data models according to business process.
• Ensure data architecture and data management principles are followed during development of new data models

• Build data modelling standards, naming conventions and follow them during implementation.
• Work with data stewards, data management specialists to ensure metadata, data quality rules are implemented accurately.
• Integrate data from various source systems (e.g., databases, APIs, flat files) into Snowflake.
• Review and support the whole SDLC till go-live and post-production issues. This includes reviewing technical mapping documents, test cases, test plans and execution. Includes scheduling seamless deployment to go live.

• Ability to conduct workshops with business SMEs and data stewards to understand the business processes.
• Data Profiling and analysis to establish strong hold on data.
• Conduct root cause analysis and recommend long-term fixes for recurring issues
• Conduct impact assessment for any upstream / downstream changes.

Devops & Operations:

Ensure compliance with data governance, security.

Qualifications:

Core SnowPro Certificate is highly desired

Experience & Skills:

• 8+ years of experience as a Data Engineer/Data Modeler, preferably in a cloud-based environment.
• Strong experience with data modelling and data warehouse and data integration.
• Deep understanding of Snowflake, including performance optimization and best practices.
• Strong SQL skill is mandatory
• Solid understanding of data modeling concepts to build effective pipelines.
• Familiarity with DevOps workflows and working in environments with CI/CD, version control (Git, Bitbucket), and automated deployments.

Strong problem-solving skills and the ability to troubleshoot pipeline issues effectively.