Senior Data Engineer

C5i; Fujairah Emirate; On-site; AED 120,000 - 200,000; Full time

Job summary

A leading AI & Analytics provider in Fujairah Emirate is seeking an experienced professional skilled in cloud data warehouse solutions and Snowflake technologies. The ideal candidate will have expertise in data modelling, performance optimization, and security management. This role emphasizes delivering robust analytics and integrates seamlessly with varying industry sectors, contributing to impactful AI-driven decision making. The company fosters an inclusive work environment, committed to equal employment opportunities.

Qualifications

• Experience designing, developing, and managing cloud data warehouse solutions using Snowflake.
• Proficient in implementing data modelling and optimizing performance.
• Skills in managing security and developing ETL/ELT pipelines.

Skills

Cloud data warehouse solutions using Snowflake

Data modelling techniques (Star/Snowflake schemas)

Optimize Snowflake performance

Manage Snowflake security using RBAC

ETL/ELT pipelines using Informatica CDI

Develop App Integration processes using REST/SOAP

Tools

Informatica CDI

Snowflake

Job description

C5i is a pure-play AI & Analytics provider that combines the power of human perspective with AI technology to deliver trustworthy intelligence. The company drives value through a comprehensive solution set, integrating multifunctional teams that have technical and business domain expertise with a robust suite of products, solutions, and accelerators tailored for various horizontal and industry-specific use cases. At the core, C5i’s focus is to deliver business impact at speed and scale by driving adoption of AI-assisted decision-making.

C5i caters to some of the world’s largest enterprises, including many Fortune 500 companies. The company’s clients span Technology, Media, and Telecom (TMT), Pharma & Lifesciences, CPG, Retail, Banking, and other sectors. C5i has been recognized by leading industry analysts like Gartner and Forrester for its Analytics and AI capabilities and proprietary AI-based platforms.

Global offices

United States| Canada | United Kingdom| United Arab of Emirates| India

Skills and Experience:

Must Have :

• Design, develop, and manage cloud data warehouse solutions using Snowflake
• Implement data modelling techniques (Star/Snowflake schemas)
• Optimize Snowflake performance using:
• Virtual Warehouses
• Micro-partitioning
• Clustering
• Result and Warehouse caching
• Implement Streams, Tasks, Time Travel, Zero-Copy Cloning
• Manage Snowflake security using RBAC, masking policies, and row-level security
• Design and develop ETL/ELT pipelines using Informatica CDI
• Create and manage Mappings, Mapping Tasks, and Taskflows
• Implement Pushdown Optimization for Snowflake
• Perform data extraction from multiple sources (RDBMS, APIs, flat files)
• Handle incremental loads, CDC, and error handling
• Optimize IICS jobs for large-volume data loads
• Work with Secure Agents (installation, configuration, and monitoring)
• Develop App Integration processes using REST/SOAP services

Good To Have:

• Banking Knowledge
• Certification in Snowflake
• ERWIN data modelling experience

C5i is proud to be an equal opportunity employer. We are committed to equal employment opportunity regardless of race, color, religion, sex, sexual orientation, age, marital status, disability, gender identity, etc. If you have a disability or special need that requires accommodation, please keep us informed about the same at the hiring stages for us to factor necessary accommodations.