What does a successful Snowflakes Advisor do?
We are seeking a highly skilled and experienced Snowflake Advisor to take ownership of our data warehousing strategy, implementation, maintenance and support. In this role, you will design, develop, and lead the adoption of Snowflake-based solutions to ensure scalable, efficient, and secure data systems that empower our business analytics and decision-making processes.
As a Snowflake Advisor, you will collaborate with cross-functional teams, lead data initiatives, and act as the subject matter expert for Snowflake across the organization.
What you will do:
- Define and implement best practices for data modelling, schema design, query optimization in Snowflakes
- Develop and manage ETL/ELT workflows to ingest, transform and load data into Snowflakes from various resources
- Integrate data from diverse systems like databases, API`s, flat files, cloud storage etc. into Snowflakes.
- Using tools like Streamsets, Informatica or dbt to streamline data transformation processes
Monitor or tune Snowflake performance including warehouse sizing, query optimizing and storage management.
- Manage Snowflakes caching, clustering and partitioning to improve efficiency
- Analyze and resolve query performance bottlenecks
- Monitor and resolve data quality issues within the warehouse
- Collaboration with data analysts, data engineers and business users to understand reporting and analytic needs
- Work closely with DevOps team for Automation, deployment and monitoring
- Plan and execute strategies for scaling Snowflakes environments as data volume grows
- Monitor system health and proactively identify and resolve issues
- Implement automations for regular tasks
- Enable seamless integration of Snowflakes with BI Tools like Power BI and create Dashboards
- Support ad hoc query requests while maintaining system performance
- Creating and maintaining documentation related to data warehouse architecture, data flow, and processes
- Providing technical support, troubleshooting, and guidance to users accessing the data warehouse
- Optimize Snowflakes queries and manage Performance
- Keeping up to date with emerging trends and technologies in data warehousing and data management
- Good working knowledge of Linux operating system
- Working experience on GIT and other repository management solutions
- Good knowledge of monitoring tools like Dynatrace, Splunk
- Serve as a technical leader for Snowflakes based projects, ensuring alignment with business goals and timelines
- Provide mentorship and guidance to team members in Snowflakes implementation, performance tuning and data management
- Collaborate with stakeholders to define and prioritize data warehousing initiatives and roadmaps.
- Act as point of contact for Snowflakes related queries, issues and initiatives
What you will need to have:
- Must have 8 to 10 years of experience in data management tools like Snowflakes, Streamsets, Informatica
- Should have experience on monitoring tools like Dynatrace, Splunk.
- Should have experience on Kubernetes cluster management
- CloudWatch for monitoring and logging and Linux OS experience
- Ability to track progress against assigned tasks, report status, and proactively identifies issues.
- Demonstrate the ability to present information effectively in communications with peers and project management team.
- Highly Organized and works well in a fast paced, fluid and dynamic environment.
What would be great to have:
- Experience in EKS for managing Kubernetes cluster
- Containerization technologies such as Docker and Podman
- AWS CLI for command-line interactions
- CI/CD pipelines using Harness
- S3 for storage solutions and IAM for access management
- Banking and Financial Services experience
- Knowledge of software development Life cycle best practices
R-10356376
