Engineer
The Offshore Tech Lead/Snowflake Platform Engineer will be responsible for leading the design, development, optimization, and administration of enterprise-scale data solutions on the Snowflake Data Cloud platform. This role involves both hands-on engineering and technical leadership, including coordinating the offshore team, ensuring adherence to best practices, and collaborating with cross-functional stakeholders (Onsite/Client) to deliver high-performance, scalable, and secure data solutions.
-
Team Leadership: Lead, coach, and mentor a team of offshore Snowflake data engineers and developers, ensuring technical tasks are executed efficiently and to high quality standards.
-
Technical Alignment: Serve as the primary technical point of contact between the offshore team and the onsite/client architecture, product, and business teams. Provide cross-time zone technical support and guidance.
-
Code Quality & Standards: Define, enforce, and govern coding standards, security policies, and development best practices (e.g., SQL optimization, Python scripting, data modeling) across all Snowflake-related development. Conduct structured code and design reviews.
-
Roadmap & Planning: Plan technical milestones, contribute to the platform's future technical roadmap, and collaborate on resource/capacity planning for ongoing initiatives.
-
Solution Architecture: Lead the design and implementation of robust, scalable, and cost-effective data warehousing solutions, ELT/ETL processes, and data pipelines within the Snowflake environment.
-
Data Modeling: Design and optimize Snowflake schemas, including implementing best-practice structures like Bronze, Silver, and Gold data quality zones.
-
Performance & Optimization: Proactively monitor, tune, and optimize Snowflake query performance, resource utilization, and virtual warehouse consumption to manage costs and ensure high efficiency.
-
Administration & Governance: Engineer and administer Snowflake features, including access control (RBAC), security policies, data masking, and data sharing capabilities to ensure compliance and governance.
-
Data Ingestion: Design and implement data ingestion strategies for batch and streaming data from diverse sources (e.g., S3, Azure Data Lake, Kafka, APIs) using tools like Snowpipe, Python, or external ETL/ELT tools (e.g., Fivetran, Matillion, dbt).
-
CI/CD & Automation: Develop and maintain CI/CD pipelines (using tools like Git, GitHub Actions, Jenkins, or Bamboo) for automated testing and deployment of Snowflake objects (stored procedures, views, UDFs, etc.).
-
Cloud Integration: Ensure seamless integration between Snowflake and the underlying cloud ecosystem (e.g., AWS S3/Lambda or Azure Data Factory/ADLS).
-
8+ years of experience in Information Technology, with 5+ years of hands-on experience in Snowflake development, administration, and platform engineering.
-
2+ years of experience in a Technical Lead or similar leadership role, specifically managing and mentoring offshore/distributed teams.
-
Proven experience working on large-scale enterprise data warehousing and big data projects.
-
Snowflake: Deep expertise in Snowflake architecture, features (Virtual Warehouses, Snowpipe, Streams, Tasks, Time Travel, Caching), and performance tuning.
-
SQL: Advanced proficiency in writing and optimizing complex SQL queries.
-
Programming: Strong proficiency in Python (or Scala/Java) for scripting, automation, and data transformation (experience with Snowpark is a plus).
-
Cloud Platforms: Hands-on experience with at least one major cloud platform (AWS, Azure, or GCP), particularly their data and storage services (e.g., S3, Azure Data Lake Storage, Google Cloud Storage).
-
ETL/ELT: Solid understanding and experience with modern ELT/ETL methodologies and tools (e.g., dbt, Informatica, Talend).
-
DevOps & CI/CD: Experience with version control (Git) and building continuous integration/continuous delivery pipelines for data solutions.
Professional & Leadership Skills
Communication: Excellent written and verbal communication skills, with the ability to articulate complex technical concepts to both technical and non-technical stakeholders across different time zones.-
Problem-Solving: Strong analytical and problem-solving skills to diagnose and resolve data quality, performance, and platform-related issues.
-
Stakeholder Management: Proven ability to work collaboratively with cross-functional teams (e.g., Data Scientists, Data Analysts, Product Owners) and manage offshore team deliverables.
-
Snowflake certification (e.g., SnowPro Core, SnowPro Advanced Architect, or Data Engineer).
-
Experience with Infrastructure as Code (e.g., Terraform) for managing Snowflake resources.
-
Familiarity with data governance tools and concepts (e.g., data lineage, data cataloging).
-
Experience in a specific business domain (e.g., Real Estate, Retail).
