Snowflake Developer - Data Modeling & Integration

Forward Eye Technologies; Dadri; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Forward Eye Technologies is seeking a senior Snowflake developer with 6+ years of experience, including 4+ years in Snowflake design and implementation. You will design scalable data storage, optimize SQL queries, and ensure data governance and security across the data platform.

You will collaborate with data engineers and business analysts to model data, integrate sources, and deliver insightful visualizations. Documentation and knowledge sharing are also key parts of the role.

Qualifications

• Designing and building scalable Snowflake data storage solutions.
• Strong SQL and PL/SQL skills for data extraction and analysis.
• Experience with data modeling and ensuring data quality.
• Knowledge of data governance, security, and access controls.
• Ability to translate business needs into visual data representations.

Responsibilities

• Design Snowflake solutions meeting warehousing standards.
• Collaborate with stakeholders to gather requirements for analytics.
• Optimize performance of Snowflake data models and queries.
• Ensure data governance and security best practices.
• Create technical solution designs and documentation.
• Develop user guides for self-service analytics.
• Troubleshoot and validate data solutions throughout development.

Skills

Snowflake development

SQL & PL/SQL

Data modeling

Data governance

Stakeholder management

Documentation

Education

Bachelor's degree in Computer Science/Information Systems

Tools

SAP

JDE Systems

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