Lead Snowflake Developer - Snowflake Architecture, CI/CD, SQL, ETL Processes, BI Tools

We are looking for a highly skilled Lead Snowflake Developer to join our team. The ideal candidate will have extensive experience in designing, developing, and managing Snowflake data warehouses, along with a strong understanding of cloud technologies and ETL processes. The Lead Developer will guide development efforts, ensure best practices, and collaborate with cross-functional teams to deliver data solutions that meet business needs.

• Design, develop, and maintain scalable Snowflake data warehouse solutions.
• Lead the architecture and implementation of advanced Snowflake features such as Micro Partitions, Data Sharing, Streams, Tasks, and Time Travel.
• Collaborate with business stakeholders to gather requirements and translate them into technical specifications.
• Oversee the CI/CD process for deploying Snowflake solutions, including managing GitHub repositories and conducting code reviews.
• Mentor and provide guidance to junior developers on Snowflake best practices and database programming.
• Monitor Snowflake performance and optimize resource usage, adjusting as necessary to minimize costs.
• Conduct regular meetings and collaborate with teams using Agile methodologies (Scrum and Kanban).
• Assist in data migration from various sources (e.g., AWS S3) into Snowflake, using tools like SnowPipe for continuous data integration.
• Develop and document ETL processes and data flow architectures using tools like Airflow and SSIS.
• Create and maintain Confluence pages and documentation for processes, designs, and knowledge sharing.

• Snowflake Proficiency: In-depth knowledge of Snowflake architecture, advanced features, and performance tuning.
• Database Technologies: Strong experience in SQL Server, Oracle, T-SQL, PL/SQL, Analytical functions, and complex SQL scripting.
• Tools & Technologies: Proficiency in BI Tools (SSIS, SSRS, SSAS, Power BI), Cloud Technologies (AWS), and development tools (Git, VS Code).
• ETL Processes: Experience with data loading strategies and workflows using Snowpipe and other ETL methodologies.
• Agile Methodologies: Familiarity with JIRA, ServiceNow, and managing sprints and backlog items.
• Reporting Tools: Knowledge of PowerBI and ability to generate insightful reports for business intelligence.

• 4+ years of experience specifically working with Snowflake Data Warehouse.
• A total of 9.5 years of experience in IT, with a focus on data architecture, business intelligence, and data engineering.
• Previous experience in technical leadership or similar roles managing project teams and guiding technical direction.

• Lead daily stand-up meetings and sprint reviews, providing updates on progress and roadblocks.
• Develop and execute strategies for effective monitoring, performance tuning, and cost management within Snowflake.
• Design and implement data models and architectures that meet business reporting and analytical needs.
• Collaborate with cross-functional teams to ensure alignment on data strategies and deliverables.
• Coordinate efforts for knowledge sharing and training, ensuring the team is up-to-date with Snowflake developments.

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Relevant certifications in Snowflake or Data Engineering are a plus.

• Excellent communication and interpersonal skills.
• Strong analytical and problem-solving abilities.
• Ability to work independently as well as part of a cross-functional team.
• Proven leadership skills with a focus on team development and collaboration.

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT
 

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice