Snowflake DB Developer - Database Design (6-10 yrs)

Job Title : Snowflake Developer

Location : Remote

Role : FTE

Job Description :

We are seeking a highly skilled and experienced Snowflake Developer with professional specializing in the Snowflake data cloud platform to join our team. As a Snowflake Developer, you will be responsible for designing, implementing, and maintaining data storage and processing solutions that enable data-driven decision-making across the organization. You will work closely with stakeholders to understand their requirements and transform complex data into meaningful insights.

Responsibilities :

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.

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.

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.

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.

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.

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.

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.

- 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.

- Notice Period should not be more than 15 days.