Lead Snowflake Subject Matter Expert

Milestone Technologies, Inc.; Los Angeles, California (CA, MO); On-site; USD 124,000 - 135,000; Full time

Job summary

Milestone Technologies, Inc. seeks a Lead Software Engineer with 7+ years in software engineering and 3-5 years in Snowflake, to lead large-scale data initiatives in a non-people management capacity. You will drive design, optimization, and governance of Snowflake platforms, working with global teams on data ingest, modeling, and reporting.

The role emphasizes platform analytics, AI-driven features, and cost-aware data lake solutions, with senior technical leadership across delivery teams.

Qualifications

• 7+ years of professional software engineering experience.
• 3-5 years hands-on Snowflake experience.
• Experience providing technical leadership to developers.
• Snowflake certifications: SnowPro Core and SnowPro Advanced Data Engineer.
• Experience building and optimizing large data lakes and pipelines.
• CI/CD pipelines with Python code.
• Data warehousing, governance, security, and DR basics.

Responsibilities

• Lead design, development, and optimization of Snowflake solutions.
• Provide technical authority across platform strategy, governance and security.
• Architect data ingest and egress with quality and lifecycle integrity.
• Design scalable data models for enterprise wide use and reporting.
• Mentor engineers through design reviews and code reviews.
• Troubleshoot production issues, root cause analysis and bottlenecks.
• Produce audit-ready technical documentation and diagrams.

Skills

Snowflake development

Technical leadership

CI/CD pipelines

REST integrations

Agile delivery

Security

Data governance

Python

AI / Gen AI

Databricks

Azure Synapse

Education

Bachelor’s degree in Computer Science / Information Systems / Software / Electrical or Electronics Engineering

Tools

Snowflake Certifications - SnowPro Core

SnowPro Advanced Data Engineer

Job description

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.

Responsibilities

• 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 lifecycles, 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.

Basic Qualifications

• 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 - SnowPro Core, SnowPro 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 Snowflake Data Warehousing & Medallion data lake strategies.
• Strong hands-on expertise with Security, Disaster Recovery, Data Governance, Monitoring, AI and Enablement.
• Solid understanding of asset lifecycles, license compliance, software normalization, and hardware asset governance.
• Experience with REST integrations, data imports, web services, and event-based integrations.
• Proven experience working in Agile delivery environments with cross-functional global teams.
• Ability to design scalable, resilient, and maintainable solutions that support enterprise growth.

Preferred Qualifications

• Experience with high volume data solutions such as Databricks and Azure Synapse.
• One or more SnowPro advanced or specialty certifications, such as Generative AI, Snowpark or Architect.
• Experience implementing Platform Analytics, advanced Performance Analytics, and complex data-driven insights with a lens towards cost optimization strategy.
• Experience with programming languages such as C# and .NET.
• Strong understanding of platform governance, upgrade strategies, and technical debt management.

Education

Bachelor’s degree in Computer Science, Information Systems, Software, Electrical or Electronics Engineering, or comparable field of study, and/or equivalent work experience

The estimated pay range for this position is USD $90.00/hr - USD $98.50/hr. Exact compensation and offers of employment are dependent on job‑related knowledge, skills, experience, licenses or certifications, and location. We also offer comprehensive benefits. The Talent Acquisition Partner can share more details about compensation or benefits for the role during the interview process.