Java Snowflake Developer

Straive; Mumbai; Hybrid; INR 4,200,000 - 7,000,000; Full time

Job summary

Straive is seeking a Senior Data Engineer to design, build, and evolve our in-house data platforms. You will lead dataset construction, pipelines, and data marts, collaborating with analysts and data scientists. Hybrid work model; office presence three days a week with manager-approved remote days.

Ideal candidate has 7+ years in data engineering, strong Java skills, and AWS/Snowflake qualifications, enabling robust data solutions for diverse domains including finance and education.

Qualifications

• Bachelor’s or master’s degree in Computer Science, Information Technology, Engineering or related quantitative discipline from a top tier university.
• Certified in AWS Data Engineer Specialty or AWS Solution Architect Associate.
• Snowflake SnowPro Core Certification mandatory and 5+ years of hands on experience working on snowflake projects.
• 7+ years of experience in data engineering or relevant working experience in a similar role, preferably in the financial industry.
• Strong understanding of at least one Enterprise Agile Framework (e.g., Kanban, SAFe, SCRUM).
• Strong understanding of ETL, data warehousing, BI (Qlik) and Advanced Data Analytics concepts.
• Deep knowledge of cloud-enabled technologies – AWS RDS and AWS Fargate.
• Experience with Snowflake, PostgreSQL, MS SQL databases and data warehouses.
• Strong programming skills with Java.
• Experience with ETL tools such as AWS Glue.
• Strong analytical and problem-solving skills.
• Excellent communicator with a team-oriented approach.

Responsibilities

• Analyse raw data to generate BI and Advanced Analytics datasets based on stakeholder requirements.
• Design data pipelines to curate data into the inhouse data warehouse.
• Design data marts to facilitate dataset consumption by internal stakeholders.
• Define migration activities to move data to the inhouse data warehouse.
• Regular housekeeping of raw data and data in the warehouse.
• Build and maintain data pipelines and data platforms; develop prototypes.
• Explore data quality improvements and opportunities to acquire better data.
• Develop analytical tooling to support BI and Advanced Data Analytics.

Skills

Analytical thinking

Problem solving

Communication

Team collaboration

Java programming

Education

Bachelor’s or Master’s degree in CS/IT/Engineering

AWS Data Engineer Specialty

AWS Solution Architect Associate

Snowflake SnowPro Core Certification

Tools

Snowflake

PostgreSQL

MS SQL

AWS Glue

AWS RDS

AWS Fargate

Job description

About Straive:Straive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains. Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the company’s long-term vision. The company is a specialized solutions provider to business information providers in finance, insurance, legal, real estate, life sciences and

logistics. Straive continues to be the leading content services provider to research and education publishers. Data Analytics & Al Services: Our Data Solutions business has become critical to our client’s success. We use technology and Al with human experts-in loop to create data assets that our clients use to power their data products and their end customers & workflows. As our clients expect us to become their future-fit Analytics and Al partner, they look to us for help in building data analytics and Al enterprise capabilities for them. With a client-base scoping 30 countries worldwide, Straive’s multi-geographical resource pool is strategically located in eight countries - India, Philippines, USA, Nicaragua, Vietnam, United Kingdom, and the company headquarters in Singapore. Website: https://www.straive.com/ Linkedin.

About the Role:

A “Senior Data Engineer” is mid-level professional leading the design, build and evolution of the inhouse data platforms. You lead the construction of datasets requested by various stakeholders, the build and maintenance of the resulting data pipelines. You closely work in collaboration with our data analysts, data scientist and business application development teams in delivering data solutions. Our hybrid work model is designed to give you the best of both worlds—flexibility and face-to-face collaboration. Employees are required to be present in the office on Mondays, Wednesdays and Fridays each week. This means you’ll be in the office at least three days a week, with the option to work remotely on the other days, based on manager approval and business needs. This approach helps us stay connected as a team while giving you the flexibility to work in a way that suits you.

Design

• 1. Analyse relevant internally and externally sourced data (raw data) to generate BI and Advanced Analytics datasets based on your stakeholders’ requirements
• 2. Design data pipelines to curate sourced data into the inhouse data warehouse
• 3. Design data marts to facilitate dataset consumption out of the inhouse data warehouse by business and IT internal stakeholders
• 4. Design data model changes that align with the inhouse data warehouse standards
• 5. Define migration execution activities to move data from existing database solutions to the inhouse data warehouse

• 1. Regular housekeeping of raw data and data stored in the inhouse data warehouse
• 2. Build and maintenance of data pipelines and data platforms
• 3. Build data solution prototypes
• 4. Explore ways to enhance data quality and reliability
• 5. Identify and realize opportunities to acquire better data (raw data)
• 6. Develop analytical tooling to better support BI and Advanced Data Analytics activities
• 7. Execute data migration from existing databases to the inhouse data warehouse
• 8. Promote and champion data engineering standards and best-in-class methodology

You will have the following qualifications:

• 1. Bachelor’s or master’s degree in Computer Science, Information Technology, Engineering or related quantitative discipline from a top tier university.
• 2. Certified in AWS Data Engineer Specialty or AWS Solution Architect Associate
• 3. Snowflake SnowPro Core Certification mandatory and 5+ years of hands on experience working on snowflake projects.
• 4. 7+ years of experience in data engineering or relevant working experience in a similar role, preferably in the financial industry
• 5. Strong understanding or practical experience of at least one common Enterprise Agile Framework e.g. Kanban, SAFe, SCRUM, etc.
• 6. Strong understanding of ETL, data warehouse and BI(Qlik) and Advanced Data Analytics concepts
• 7. Deep knowledge of cloud-enabled technologies – AWS RDS and AWS Fargate, etc.
• 8. Experience with databases and data warehouses - Snowflake, PostgreSQL, MS SQL
• 9. Strong programming skills with advanced knowledge of Java
• 10. Practical experience with ETL tools such as AWS Glue, etc.
• 11. Strong critical-thinking, analytical and problem-solving skills
• 12. Excellent communicator with team-oriented approach