Senior Snowflake Developer
Job description
About the role
This role owns the architecture and delivery of data capabilities on the Keyloop Snowflake platform, shaping how information flows across dealer, manufacturer, and supplier ecosystems. You will take self-directed ownership of features and small epics, from initial design to production deployment and ongoing optimization. The position requires you to lead technical discussions independently while coaching more junior developers on best practices and clean implementation. You will act as a trusted data engineering partner to Finance, Sales, and Operations, aligning technical solutions with business outcomes. Success in this role means delivering reliable, scalable, and well-governed data products that drive efficiency and profitability for our customers. You will be responsible for ensuring that data is not only available but also trustworthy, well-documented, and secure. This is a hands-on leadership role where your technical decisions directly influence the company's data-driven transformation in the automotive industry.
Key facts
What you'll do
Lead complete delivery of features and small epics on the Snowflake platform, translating ambiguous requirements into production-ready data solutions.
Design and implement robust Snowflake database objects, including tables, views, streams, tasks, stored procedures, and dynamic tables to support evolving business needs.
Build and maintain ELT pipelines using Boomi, dbt, or SQL-based transformations, ensuring data moves reliably from source systems into the warehouse.
Architect and manage Bronze, Silver, and Gold data layers in strict alignment with Keyloop's data platform standards and long-term vision.
Develop and optimize complex SQL for high-performance data transformation, aggregation, and reporting use cases across large datasets.
Implement Snowflake performance best practices, such as clustering keys, result caching, query profiling, and warehouse right-sizing to control costs and improve speed.
Own the end-to-end testing strategy for pipeline and model changes, ensuring comprehensive coverage that extends beyond unit-level checks to data quality and integrity.
Coach and support IC1 and IC2 developers on Snowflake, SQL, and data engineering best practices to elevate the entire team's capability.
Lead technical design discussions for your features, documenting decisions and trade-offs, and representing the team in cross-functional planning meetings.
Coordinate cross-functional data requirements with adjacent teams in Finance, Sales, and Operations to ensure solutions meet real business needs.
Support data quality checks, reconciliation processes, and lineage documentation to maintain transparency and trust in the data ecosystem.
Manage Snowflake environment configuration across development, QA, and production, ensuring consistency and compliance.
Contribute actively to data governance initiatives, including access control, data masking, row-level security, and thoughtful tagging strategies.
Monitor pipeline health around the clock, proactively identify failures, and provide production support, including occasional out-of-hours incident response.
Support UAT cycles by providing technical recommendations and formal sign-off to ensure data readiness for business validation.
Produce clear technical documentation, including data dictionaries, ERDs, and pipeline runbooks, to ensure knowledge sharing and continuity.
Requirements
Bring 4 to 7 years of hands-on Snowflake development experience within a production data environment, demonstrating consistent delivery and reliability.
Write strong SQL queries using window functions, CTEs, recursive queries, and advanced aggregations to solve complex analytical problems.
Possess hands-on experience with Snowflake-specific features such as streams, tasks, dynamic tables, time travel, and zero-copy cloning for efficient data workflows.
Have experience building ELT or ETL pipelines that integrate source systems like Salesforce, NetSuite, or other enterprise ERP platforms.
Understand dimensional modelling and core data warehousing concepts, including star schema design and slowly changing dimension techniques.
Show familiarity with Snowflake access controls, including roles, grants, and the implementation of row and column-level security policies.
Demonstrate proficiency with version control using Git and modern CI/CD practices for data pipeline deployment and change management.
Translate ambiguous business data requirements into logical and scalable technical data models that stakeholders can understand and use.
Demonstrate the ability to coach or mentor junior developers and lead technical discussions within a cross-functional, Agile team environment.
Show a strong commitment to data quality, ownership, and documentation, ensuring that solutions are maintainable and auditable.
Nice to have
Hold SnowPro Core or Advanced Data Engineer certification as proof of deep Snowflake expertise and professional validation.
Have hands-on experience with dbt for transformation orchestration, managing complex dependency graphs and versioned deployments.
Possess experience with Boomi as an integration tool, specifically in building connectors and flows that feed data into Snowflake.
Understand Salesforce data structures deeply and have experience supporting Salesforce reporting and data extraction requirements.
Have experience with NetSuite financial data extraction, modeling, and integration into enterprise data platforms.
Know data observability tooling such as Monte Carlo or Great Expectations, using them to monitor data health and detect anomalies.
Have a background working within Agile delivery teams, navigating Jira-based project management, and collaborating with distributed stakeholders.
Come from an industry background in automotive, SaaS, or financial systems data, bringing relevant context and faster domain adaptation.
Practical notes
Candidates must be located in Ho Chi Minh City due to the role's operational and collaboration requirements.
This is an employee engagement, offering stable long-term career development within a growing technology team.
Successful candidates should be prepared for occasional out-of-hours support to manage production incidents and ensure high data availability.