Snowflake Developer - Data Modeling & Integration

Forward Eye Technologies; Dadri; On-site; INR 1,500,000 - 2,800,000; Full time

Job summary

Forward Eye Technologies in India is seeking a Senior Snowflake Developer to design scalable data warehouses, implement efficient SQL/PLSQL queries, and build robust data models that meet governance standards.

You will collaborate with data engineers and business analysts, integrate data from diverse sources, optimize performance, enforce security controls, and present insights to stakeholders through clear visualizations and documentation.

Qualifications

• Bachelor's degree in Computer Science or related field.
• Minimum 5 years of Snowflake development experience.
• Strong SQL & PL/SQL proficiency.
• Experience with SAP and JDE systems is a plus.
• Ability to translate business requirements into data models and visuals.

Responsibilities

• Design and implement Snowflake data storage solutions following best practices.
• Collaborate with data engineers and analysts to model and integrate data.
• Tune performance of data models and queries for efficient retrieval.
• Enforce data governance, security controls, and access policies.
• Work with stakeholders to translate needs into visual analytics.
• Create design docs and user guides for maintainability.
• Test and troubleshoot Snowflake solutions in development and prod.

Skills

Snowflake development

SQL & PL/SQL

Data modeling

Data governance

Stakeholder management

SAP & JDE knowledge

SQL optimization

Problem solving

Communication skills

Education

Bachelor's degree in CS/IS

Tools

SAP

JDE

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