Snowflake Data Engineer

Company Description Shivsys Group is a global technology partner focused on helping businesses drive growth, transformation, and efficiency in a digital-first world. The company delivers end-to-end solutions across mobile application development, web development, cloud computing, and AI & data analytics, tailored to each client’s specific goals and industry needs. Shivsys follows a customer-first approach, emphasizing secure, scalable, and high-quality solutions that provide measurable business value. The organization is ISO/IEC 27001:2022 certified, demonstrating strong commitment to information security and data protection. Serving clients from startups to large enterprises across sectors such as finance, healthcare, retail, and manufacturing, Shivsys enables digital transformation and supports long-term innovation.Role Description Experience: 4+ YearsLocation: DubaiRelocation: Candidates from India willing to relocate to DubaiVisa: Initial 2 months on Business Visa, extendable up to 3 yearsCompensation: As per market standardRole OverviewWe are looking for a Snowflake Data Engineer with strong hands-on experience in Snowflake, SQL, data pipelines, ELT, and data modeling. Experience with investment or financial-services data is highly preferred.Key ResponsibilitiesBuild and maintain Snowflake data pipelines, tables, views, procedures, tasks, and streams.Develop ingestion, staging, cleansing, transformation, and consumption layers.Create source-to-target mappings for investment, portfolio, accounting, market, and reference data.Develop reusable data models for holdings, transactions, instruments, valuations, cash, performance, and historical data.Handle historical data migration, backfill, reconciliation, and data-quality validation.Implement data-quality checks, exception handling, audit controls, and reconciliation logic.Optimize Snowflake performance, warehouse usage, queries, data loading, and costs.Implement data security using RBAC, masking, secure views, and data segregation.Collaborate with Business Analysts, Architects, Integration, Governance, and Testing teams.Prepare technical documentation, deployment scripts, data dictionaries, and handover materials.Must-Have Skills4+ years of Data Engineering experience with strong hands-on Snowflake expertise.Strong SQL and complex data transformation skills.Experience with data pipelines, ELT processes, and data modeling.Experience with ETL/ELT tools, orchestration, cloud storage, APIs, and BI/reporting layers.Hands-on experience with data migration, reconciliation, and data-quality processes.Good understanding of data governance, lineage, access control, and sensitive data handling.Excellent communication skills.PreferredExperience in investment management, financial services, accounting, portfolio, or market data.Exposure to public/private investment data structures and historical datasets.Ideal Candidate: Strong Snowflake Data Engineer with financial/investment data experience and willingness to relocate to Dubai.