Senior Professional- Snowflake Architect, Data Management & Reporting-

Position Overview

• Snowflake Architecture and Design: Collaborate with stakeholders, data engineers, and business analysts to design and architect data solutions based on the Snowflake cloud data platform. Create detailed data models and schema designs to support various business requirements.

• Harness Snowpark's multi-language capabilities to create efficient and modular code.

• Develop custom user-defined functions (UDFs) to extend Snowflake's native capabilities and optimize query performance.

• Technical Leadership: Lead a team of developers and data engineers, providing technical guidance, mentoring, and support throughout the development lifecycle. Drive best practices, code reviews, and ensure the team follows industry standards and conventions.

• Data Integration: Develop and maintain data integration workflows to ingest, process, and transform data from various sources into Snowflake. Implement ETL/ELT processes to ensure data accuracy and consistency.

• Performance Optimization: Optimize Snowflake database performance by tuning queries, optimizing data structures, and improving data loading and extraction processes. Monitor system performance and troubleshoot issues when they arise.

• Security and Governance: Implement and enforce data security measures, access controls, and data governance policies within Snowflake. Ensure compliance with data privacy regulations and industry standards.

• Collaboration: Collaborate with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand data requirements and deliver comprehensive solutions.

• Cloud Infrastructure: Work closely with cloud infrastructure teams to ensure the Snowflake environment is properly configured, monitored, and scaled to meet performance and availability requirements.

• Continuous Improvement: Stay up-to-date with the latest advancements in Snowflake and cloud technologies. Propose and implement improvements to enhance the overall data architecture and development processes.

Qualifications & Experience

• 15+ years of Technology industry experience; bachelor’s degree in IT or related fields.

• Proven experience as a Snowflake Architect or similar role, with hands-on experience in architecting and implementing data solutions on the Snowflake cloud data platform.

• Strong proficiency in SQL, data modeling, and database design principles.

• Solid understanding of data warehousing concepts, ETL/ELT processes, and data integration methodologies.

• Experience in leading and managing a team of developers and data engineers.

• Familiarity with cloud platforms like AWS, Azure, or GCP, with specific expertise in Snowflake's integration with cloud services.

• Excellent problem-solving skills and the ability to troubleshoot and resolve complex data-related issues.

• Strong communication and interpersonal skills to collaborate effectively with various stakeholders.

Additional Qualifications:

• Experience required designing relational database schemas, stored procedures, and views for performance with large data sets

• Familiar in: NoSQL\NewSQL databases, SDLC methodologies; defect tracking (JIRA, DevOps, ServiceNow etc).

• Experience/Familiarity with Master Data Management & related tools

• Proven track record of full project lifecycle and development, as well as post-implementation support activities

• Experience Design, development, modification and testing of databases designed to support Data Warehousing and BI business teams

• Strong documentation capability and consistency to testing and release management standards

Soft Skills:

• Candidate must have an analytical, logical thought process for developing project solutions

• Good interpersonal and communication skills; works well in a team environment

• Ability to deliver under competing priorities and pressures

• Excellent organizational skills in the areas of code structuring & partitioning, commenting, and documentation for team alignment and modifications

Apollo provides equal employment opportunities regardless of age, disability, gender reassignment, marital or civil partner status, pregnancy or maternity, race, colour, nationality, ethnic or national origin, religion or belief, veteran status, gender/sex or sexual orientation, or any other criterion or circumstance protected by applicable law, ordinance, or regulation. The above criteria are intended to be used as a guide only – candidates who do not meet all the above criteria may still be considered if they are deemed to have relevant experience/ equivalent levels of skill or knowledge to fulfil the requirements of the role. Any job offer will be conditional upon and subject to satisfactory reference and background screening checks, all necessary corporate and regulatory approvals or certifications as required from time to time, and entering into definitive contractual documentation satisfactory to Apollo.