Job Description
Role & Responsibilities :
1. Snowflake Development :
- Designing and building scalable and efficient data storage solutions meeting data warehousing design standards and using Snowflake's architecture.
- Strong experience in SQL & PL/ SQL
- Hands-on Writing, optimizing, and troubleshooting complex SQL queries and Stored Procedures to extract and analyze data within the Snowflake environment.
- Integrating Snowflake with various data sources and third-party tools to facilitate data flow.
- Staying up-to-date with the latest features and best practices for Snowflake development.
2. Data Modeling and Integration :
- Collaborate with data engineers and business analysts to understand data sources, perform data modeling, and ensure the availability of clean and accurate data for analysis.
- Integrate data from various sources into Snowflake, ensuring data quality and consistency.
3. Performance Optimization :
- Optimize Snowflake solutions for performance by fine-tuning data models, queries, and visuals.
- Implement performance optimization techniques to ensure efficient data retrieval with less computation Cost.
4. Data Governance and Security :
- Implement data governance and security best practices within Snowflake solutions.
- Define and enforce data access controls, data encryption, and other security measures to protect sensitive information.
5. Collaboration and Stakeholder Management :
- Collaborate closely with business stakeholders to gather requirements, understand their needs, and translate them into effective data visualizations.
- Conduct regular meetings and presentations to demonstrate the capabilities and value of Data Models solutions.
6. Documentation and Knowledge Sharing :
- Create technical solution design and unit test cases. Document data models, report specifications, and development processes to ensure knowledge sharing and maintainability.
- Create user guides and training materials to enable self-service analytics for end-users.
7. Quality Assurance and Troubleshooting :
- Conduct thorough testing and validation of developed Snowflake solutions to ensure accuracy, functionality, and adherence to business requirements.
- Troubleshoot and resolve any issues or bugs that arise during testing or production.
Qualifications :
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- Minimum of 5 years of experience in Snowflake development.
- Extensive knowledge and expertise in SQL & PL/SQL.
- Prior knowledge working with SAP & JDE Systems would be preferred.
- Proven experience in designing and developing complex Business Scenarios and meaningful use cases.
- Strong understanding of data modeling concepts and best practices.
- Proficiency in SQL for data retrieval and manipulation.
- Solid understanding of data governance and security principles within Snowflake.
- Excellent analytical and problem-solving skills with the ability to translate business requirements into effective visualizations.
- Strong communication and stakeholder management skills, with the ability to effectively collaborate with stakeholders at all levels of the organization.
Experience : 6+ Years , Relevant in snowflake development should be 4 Years