Senior SQL Developer

Apex Group; Pune District; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Apex Group is seeking a Senior SQL Developer in Pune to design and implement end-to-end data warehouse solutions, including data models, ETL pipelines, and governance. You will collaborate with business and data teams to translate requirements into scalable architecture and mentor junior engineers.

We expect strong SQL, performance tuning, and experience with cloud platforms and BI tools such as Power BI and Tableau.

Qualifications

• Design end-to-end data warehouse solutions using modern data platforms.
• Define data models (star/snowflake schema), data marts, and OLAP structures.
• Create and manage ETL pipelines to ingest data from various sources (structured, semi-structured).
• Collaborate with business and data teams to translate requirements into scalable data architecture.
• Ensure data quality, governance, security, and compliance standards are met.
• Optimize data storage and query performance for analytical workloads.
• Develop data strategy and roadmap aligned with business objectives.
• Guide and mentor data engineering teams on best practices.
• Strong experience with data warehousing concepts, architecture, and best practices.

Responsibilities

• Design and architect end-to-end data warehouse solutions using modern data platforms.
• Define data models (star/snowflake schema), data marts, and OLAP structures.
• Create and manage ETL pipelines to ingest data from various sources (structured, semi-structured).
• Collaborate with business and data teams to translate requirements into scalable data architecture.
• Ensure data quality, governance, security, and compliance standards are met.
• Optimize data storage and query performance for analytical workloads.
• Develop data strategy and roadmap aligned with business objectives.
• Guide and mentor data engineering teams on best practices.
• Strong experience with data warehousing concepts, architecture, and best practices.

Skills

SQL

Performance tuning

Python

PL/SQL

ETL

CI/CD

Data governance

Tools

Azure

Databricks

Power BI

Tableau

SSIS

SSRS

SSAS

Informatica

Talend

DBT

Job description

## Senior SQL DeveloperApplylocations: Pune - Baner: Pune, Astral Court: Pune - East: Pune, NOB Buldingtime type: Full timeposted on: Posted Todaytime left to apply: End Date: June 30, 2026 (30+ days left to apply)job requisition id: JR-0019566The Apex Group was established in Bermuda in 2003 and is now one of the world’s largest fund administration and middle office solutions providers.Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.Your career with us should reflect your energy and passion.That’s why, at Apex Group, we will do more than simply ‘empower’ you. We will work to supercharge your unique skills and experience.Take the lead and we’ll give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities.For our business, for clients, and for youJob Specification• Design and architect end-to-end data warehouse solutions using modern data platforms • Define data models (star/snowflake schema), data marts, and OLAP structures • Create and manage ETL pipelines to ingest data from various sources (structured, semi-structured) • Collaborate with business and data teams to translate requirements into scalable data architecture • Ensure data quality, governance, security, and compliance standards are met • Optimize data storage and query performance for analytical workloads • Develop data strategy and roadmap aligned with business objectives • Guide and mentor data engineering teams on best practices • Strong experience with data warehousing concepts, architecture, and best practices • Expertise in dimensional modeling, data lakes, and data marts • Hands-on experience with one or more cloud platforms • Proficiency with ETL tools • Excellent SQL and performance tuning skills • Familiarity with DevOps, CI/CD for data pipelines, and version control (Git) • Strong understanding of data governance, cataloging, and security • Experience with BI tools (Power BI, Tableau, etc.) is a plus Skills Required• Tools & Technologies Cloud Platform : Azure (Data Bricks, DevOps, Data factory, azure synapse Analytics, Azure SQL, blob storage, Databricks Delta Lake) • Languages: Python/ PL/SQL/ MS SQL • Databases: Snowflake/ MS SQL Server/Oracle • Design Tools: Erwin & MS Visio. • Data warehouse tools: SSIS, SSRS, SSAS. Power Bi, DBT, Talend Stitch, PowerApps, Informatica 9, • Cloud experience is preferredDisclaimer: Unsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.