Snowflake Developer

ADV TECHMINDS; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

ADV TECHMINDS is seeking a seasoned Snowflake Developer to design, implement, and maintain data storage and processing solutions on the Snowflake data cloud platform. You will work closely with stakeholders to translate requirements into scalable data architectures and insightful analytics.

The role emphasizes advanced SQL/PL/SQL, data modeling, and data governance, with collaboration across data engineers and business analysts to ensure data quality and secure access.

Qualifications

• Bachelor's degree in computer science, information systems or a related field.
• Extensive knowledge of SQL & PL/SQL.
• Prior knowledge with SAP & JDE systems is preferred.
• Proven experience designing and developing complex business scenarios and meaningful use cases.
• Strong understanding of data modeling concepts and best practices.

Responsibilities

• Snowflake development: design and build scalable data storage solutions in Snowflake.
• Write, optimize, and troubleshoot complex SQL queries and stored procedures.
• Integrate Snowflake with various data sources and tools for data flow.
• Collaborate with data engineers and analysts on data modeling and data quality.
• Perform data governance and security best practices within Snowflake.

Skills

Snowflake

SQL

PL/SQL

Data Modeling

Data Governance

Security

Stakeholder Management

Documentation

Education

Bachelor's degree in CS/Information Systems

Tools

SAP

JDE

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 datawithin 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:

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