Snowflake Developer - Data Modeling & Integration

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