SQL Developer Gurugram - Calculation Delivery

Required skills:
•    Experience in UK Pensions Data Analysis (DB or DC, with DB being preferable)
•    Seeking a candidate with expertise in advance SQL for writing complex SQL queries, proficient in joins and subqueries, and a strong understanding of data logic to solve analytical challenges and optimize performance.
•    Extract, clean, and analyze data from various sources using SQL.
•    Perform data validation and ensure data quality.
•    Support ad-hoc analysis requests from management and other departments.
•    Good written and verbal communication as may be engaging directly with clients (depending on project)

Key Responsibilities:
•    Provide technical and pensions support to the Configuration Analysis team
•    Receive data from ceding administrator’s system
•    Load data into a temporary database
•    Analyse data received alongside scheme documentation and map to our target database
•    Develop data reconciliations in SQL
•    Analyse, map and test interface data
•    Liaise with calc analysts to agree benefit tranches and structure
•    Configure base scheme and category set ups to match benefit structure of the scheme

• The candidate should be comfortable with an individual contributor (IC) role.
• The role requires writing complex SQL queries from scratch.
• Proficiency in writing sub-queries and working with multiple tables is essential.
• A strong understanding of all types of joins, including Inner Join, Self-Join, Left Join, and Right Join, is required.

Full Time Graduates only