Data Engineer

ICE; Hyderabad; On-site; INR 1,200,000 - 2,500,000; Full time

Job summary

Intercontinental Exchange (ICE) is seeking a Data Engineer to design and optimize SQL queries, develop Snowflake stored procedures, and support migration of legacy applications for ICE Mortgage Technology.

The ideal candidate has 5+ years of data engineering experience, strong SQL, Python scripting, and hands-on Snowflake proficiency. Hybrid work in a global data-driven environment, with opportunities to mentor peers and influence architecture.

Qualifications

• Bachelor’s degree or equivalent experience.
• 5+ years in data engineering or DB development.
• Strong SQL and stored procedures expertise.
• Snowflake objects, streams, tasks, and file formats experience.
• Python/Shell scripting for data processing and ETL.
• Git and Agile/Scrum SDLC experience.
• Excellent analytical and communication skills.

Responsibilities

• Snowflake-based data warehouse design and development for new data integration and migration projects.
• Design and develop data transformation logic using SQL, Snowflake SPs, and Python scripts for ETL/ELT workloads.
• Build and maintain data pipelines for reporting, analytics, and application data needs.
• Create Snowflake objects like tables, views, streams, tasks, file formats, and external stages.
• Collaborate with data engineers, analysts, and product owners to gather requirements.
• Draft technical design documentation based on data architecture principles.
• Develop unit tests for SQL scripts, procedures, and pipelines.
• Document deployment procedures, handover, and monitoring steps.
• Mentor junior developers when needed.
• Keep up-to-date with Snowflake features and cloud data platform trends.
• Perform related duties as assigned.

Skills

SQL queries

Stored procedures

Snowflake

Python scripts

ETL

Data warehousing

Git

Agile/Scrum

Education

Bachelor’s Degree

Tools

AWS S3

Azure Blob Storage

Git

Job description

Job Description:

Overview

Job Purpose

At Intercontinental Exchange (ICE), we engineer technology, exchanges and clearing houses that connect companies around the world to global capital and derivative markets. With a leading-edge approach to developing technology platforms, we have built market infrastructure in all major trading centers, offering customers the ability to manage risk and make informed decisions globally. By leveraging our core strengths in technology, we continue to identify new ways to serve our customers and transform global markets.

AIP Suites (Data Modernization to Snowflake) builds an analytics-ready data architecture where data from source systems such as PDM (Product Data Management) and RDO is ingested into Snowflake for centralized storage and modeling. These models support ICE BI, which consumes Snowflake data for analytics and dashboarding. This design ensures clean separation between raw ingestion, transformation, analytics, and service-based consumption, supporting scalable and future-proof data-driven operations.

ICE Mortgage Technology is seeking a Data Engineer who will be responsible for design and optimize SQL queries, develop stored procedures, and participate in the migration and modernization of legacy applications to support IMT (ICE Mortgage Technology) Products. The candidate should have a strong background in SQL and Stored Procedures

Responsibilities

• Provides Snowflake-based data warehouse design and development for projects involving new data integration, migration, and enhancement of existing pipelines.
• Designs and develops data transformation logic using SQL, Snowflake stored procedures, and Python-based scripts for ETL/ELT workloads.
• Builds and maintains robust data pipelines to support reporting, analytics, and application data needs.
• Creates and maintains Snowflake objects like tables, views, streams, tasks, file formats, and external stages.
• Participates in project meetings with data engineers, analysts, business users, and product owners to understand and implement technical requirements.
• Writes technical design documentation based on business requirements and data architecture principles.
• Develops and/or reviews unit testing protocols for SQL scripts, procedures, and data pipelines using automation frameworks.
• Completes documentation and procedures for pipeline deployment, operational handover, and monitoring.
• May mentor or guide junior developers and data engineers.
• Stays current with Snowflake features, best practices, and industry trends in cloud data platforms.
• Performs additional related duties as assigned.

Knowledge and Experience

• Bachelor’s Degree or the equivalent combination of education, training, or work experience.
• 5+ years of professional experience in data engineering or database development.
• Strong Hands-on experience:
• Writing complex SQL queries and stored procedures
• Database stored procedures, functions, views, and schema design
• Using Streams, Tasks, Time Travel, and Cloning
• Proficiency in database performance tuning and performance optimization — clustering, warehouse sizing, caching, etc.
• Experience configuring external stages to integrate with cloud storage (AWS S3, Azure Blob, etc.).
• Experience writing Python/Shell scripts for data processing (where needed).
• Knowledge on Snowflake and Tidal is an added advantage
• Proficiency in using Git and working within Agile/Scrum SDLC environments.
• Familiarity working in a Software Development Life Cycle (SDLC) leveraging Agile principles.
• Excellent analytical, decision-making, and problem-solving skills.
• Ability to multitask in a fast-paced environment with a focus on timeliness, documentation, and communication with peers and business users.
• Strong verbal and written communication skills to engage both technical and non-technical audiences at various organizational levels.