Lead Snowflake Subject Matter Expert

12 Months contract Description

Seeking a Lead Software Engineer with 7+ years’ overall software engineering experience and 3-5 years’ experience with Snowflake. The ideal candidate will have experience leading large-scale data initiatives, including projects that have evolved into multi-year, multi-million-dollar programs. The position requires extensive expertise in data management, transformation, and analysis, with a strong focus on handling complex and high-volume datasets. While this is not a people management role, the individual will be expected to provide technical leadership and oversight to other developers from a project delivery perspective.

Candidates should possess significant experience with Snowflake and understand the importance of efficient platform utilization and cost management. Experience working within large enterprise environments is highly desirable, particularly those managing data ecosystems containing trillions of records. The ability to identify, organize, and extract meaningful information from large datasets and support the development of scalable data lake solutions is essential. Additionally, the candidate should be proficient in designing and optimizing queries to meet evolving business and user reporting requirements.

• Lead the design, development, and optimization of complex Snowflake solutions leveraging modern platform capabilities, best practices, and extensibility frameworks.
• Act as a technical authority across all development team activities to include platform strategy, AI adoption & implementation, and platform governance and security.
• Architect and govern complex data ingest & egress across multiple internal and external data sources, ensuring data quality, normalization, reconciliation, lifecycle integrity, and operational reliability.
• Design scalable models that support enterprise-wide capabilities, asset life cycles, compliance, reporting, and integration with downstream systems.
• Be the technical expert within the Snowflake platform for alignment with global data guidelines in support of PII, GDPR, PIPL, CCPA regulations.
• Build and optimize Platform Analytics, Performance Analytics, and executive-level dashboards, driving data informed decision making.
• Leverage emerging Snowflake capabilities such as Snowflake Intelligence, Streamlit, Cortex AI and Gen AI.
• Define technical patterns, guardrails, and reference architectures aligned with platform strategy and long-term sustainment.
• Partner with Product Management, Enterprise Architecture, Security, and Operations to translate strategic goals into robust technical solutions.
• Mentor engineers and provide architectural guidance through design reviews, code reviews, and technical coaching.
• Lead complex troubleshooting efforts, including production break-fix, discovery failures, root cause analysis, integration bottlenecks, and performance degradation.
• Produce high-quality, audit-ready technical documentation, including solution designs, data models, and architectural diagrams.
• Act as technical authority within the development team for complex data mastering, fuzzy logic, address validation, and relationship management.

• 7+ years of professional software engineering experience, with significant (3-5 years) hands-on development on the Snowflake platform.
• Experience providing technical leadership and oversight to other developers
• Snowflake certifications - Snow Pro Core, Snow Pro Advanced Data Engineer
• Demonstrated experience implementing and supporting detailed Snowflake optimization reports for very large volume data lakes across multiple accounts.
• Strong experience creating and maintaining CI/CD pipelines, enabled with custom Python code.
• Strong technical expertise implementing…