Snowflake Developer - Data Modeling & Integration

Forward Eye Technologies; Pune District; On-site; INR 2,000,000 - 3,500,000; Full time

Job summary

Forward Eye Technologies in Pune, Maharashtra, India, seeks an experienced Snowflake Developer to design scalable data storage and analytics solutions. You will write complex SQL/PLSQL, model data, and ensure governance and security within Snowflake environments while collaborating with business stakeholders to translate requirements into impactful visuals.

The role emphasizes hands-on development, optimization, and knowledge sharing, with a focus on delivering accurate analytics and

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Minimum 5 years of Snowflake development experience.
• Extensive knowledge of SQL and PL/SQL.
• Experience with SAP & JDE systems preferred.
• Strong data modeling concepts and best practices.
• Proficiency in SQL data retrieval and manipulation.
• Knowledge of data governance and Snowflake security principles.
• Excellent analytical and problem-solving skills with ability to translate requirements into visuals.
• Strong communication and stakeholder management skills.

Responsibilities

• Snowflake Development: design scalable data storage solutions and optimize Snowflake architecture.
• Data Modeling and Integration: collaborate with data engineers and analysts to integrate data sources and ensure data quality.
• Performance Optimization: fine-tune models and queries for efficient data retrieval.
• Data Governance and Security: define access controls and encryption to protect sensitive information.
• Collaboration and Stakeholder Management: translate requirements into effective data visualizations and present capabilities to stakeholders.
• Documentation and Knowledge Sharing: create design docs, unit tests, and user guides for self-service analytics.
• Quality Assurance and Troubleshooting: validate solutions and resolve production issues.

Skills

SQL & PL/SQL

Snowflake

Data Modeling

Data Governance

Security Concepts

Stakeholder Management

Data Visualization

SAP

JDE Systems

Education

Bachelor's degree in Computer Science, Information Systems, or a related field

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