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