Data Analyst (Exp-6 Y) with Python exp-Hybrid-Full time

Primary Skills: Python, SQL, Pandas, NumPy, Data Analysis, Data Reconciliation
Domain: Data Analytics / Financial Services

Job Summary

We are seeking a skilled Python Data Analyst with strong experience in Python programming, SQL, data analysis, and automation. The candidate will work on modernizing secure, cloud-based data solutions, integrating and reconciling data across platforms such as Murex, FDR, Azure, and internal systems. The role requires expertise in data mapping, ETL testing, data validation, and ensuring data accuracy across multiple applications.

Key Responsibilities

• Develop and maintain Python scripts for data processing, ingestion, transformation, validation, and reconciliation.

• Analyze and reconcile data across Murex, FDR, data warehouses, and internal applications.

• Write complex SQL/T-SQL queries for data extraction, validation, migration, and root-cause analysis.

• Work with multiple data formats, including JSON, XML, CSV, Excel, APIs, and databases.

• Create source-to-target mappings, data dictionaries, and data lineage documentation.

• Perform data profiling, quality checks, trend analysis, and variance analysis.

• Support ETL processes, data migration, functional testing, integration testing, and regression testing.

• Work with Azure data services such as Azure SQL, Azure Data Factory, and Azure Functions.

• Troubleshoot data pipeline failures, automation scripts, and production data issues.

• Prepare test cases, defect reports, technical documentation, and validation evidence.

• Collaborate with business analysts, data engineers, architects, security, and platform teams.

Required Skills

• 4+ years of hands-on experience with Python for data analysis, processing, and automation.

• Strong SQL and T-SQL skills, including complex queries, joins, stored procedures, and data validation.

• Experience with Pandas, NumPy, Object-Oriented Programming (OOP), and exception handling.

• Strong understanding of data mapping, data lineage, reconciliation, and data quality.

• Experience in ETL testing, data migration testing, and defect management.

• Knowledge of data profiling, root-cause analysis, and variance analysis.

• Excellent analytical, communication, and problem-solving skills.

Good to Have

• Experience with Azure SQL Database, SQL Server, Azure Data Factory, and Azure Functions.

• Knowledge of Azure Key Vault, Entra ID, Blob Storage, and ADLS Gen2.

• Exposure to Dremio, Synapse Analytics, Databricks, and Logic Apps.

• Financial services experience, including trade lifecycle, risk, market data, or reference data.

• Familiarity with Azure DevOps, Agile methodologies, and CI/CD practices.

• Azure certification is an added advantage.