Data Analyst

We build full-fledged innovative solutions with a focus on process automation, user experience enhancement, and advanced data analytics. With our extensive industry expertise, we help achieve operational excellence, future-proof your IT investments, and ensure a competitive edge in the ever-evolving finance industry.

We are looking for a Data Analyst to work closely with the Data Architect, Technical Data Lead, Business Analysts, ETL Developers, BI Developers, Platform Administrators, and business stakeholders.

The Data Analyst will play a key role in understanding business requirements, analyzing existing data structures and processes, validating data, defining analytical requirements, and supporting the transition toward the company’s target data architecture.

The role requires a strong combination of business analysis, data analysis, SQL, data quality, reporting, and data visualization skills, with the ability to translate business questions into reliable, actionable data insights.

»       Analyze business requirements and translate them into clear data and analytical requirements.

»       Work with stakeholders to understand business processes, KPIs, reporting requirements, and data needs.

»       Analyze existing data sources, ODS, DWH, staging, data marts, and reporting environments.

»       Profile and assess data to identify quality issues, duplication, inconsistencies, missing values, and data anomalies.

»       Investigate existing reports, dashboards, calculations, and business logic to ensure they are correctly understood before migration or redesign.

»       Define and document data requirements, source-to-target mappings, business rules, and transformation logic.

»       Develop complex SQL queries for data extraction, reconciliation, validation, and analysis.

»       Support the Data Architect in assessing current-state data architecture and defining requirements for the target-state platform.

»       Work with ETL/ELT teams to validate data pipelines and transformation logic.

»       Perform source-to-target reconciliation and data validation during migration activities.

»       Support data migration and coexistence activities between legacy and target platforms.

»       Analyze data from Oracle, DWH, ODS, MDM, BI, and other enterprise data platforms.

»       Work with data integration patterns including batch, CDC, APIs, and file-based ingestion from an analytical and business perspective.

»       Develop and maintain analytical datasets, data marts, and semantic-layer requirements.

»       Work with BI developers to define and validate dashboards, reports, KPIs, and semantic models.

»       Support Power BI and other BI solutions by validating metrics, dimensions, measures, and business calculations.

»       Define and document data quality rules and support data quality monitoring.

»       Assist with metadata, data lineage, data ownership, and business glossary activities.

»       Identify opportunities to simplify reporting, eliminate redundant data processes, and improve data usage.

»       Support regulatory, management, operational, and enterprise reporting requirements.

»       Ensure analytical requirements are aligned with data governance, security, and regulatory requirements.

»       Support the preparation of data for advanced analytics, machine learning, and future AI/LLM use cases.

»       Communicate analytical findings and data issues clearly to both technical and non-technical stakeholders.

»       Contribute to data standards, documentation, and best practices across the organization.

Requirements

»       Strong experience as a Data Analyst, BI Analyst, Business Intelligence Analyst, or similar data-focused role.

»       Strong SQL skills and experience working with relational databases, preferably Oracle or similar enterprise database platforms.

»       Good understanding of ODS, DWH, data marts, lakehouse, semantic layers, ETL/ELT, and BI architectures.

»       Experience with data profiling, reconciliation, validation, and data quality analysis.

»       Experience gathering and documenting business and data requirements.

»       Strong understanding of data modeling concepts, including facts, dimensions, relationships, and analytical data structures.

»       Experience with Power BI or similar visualization and BI platforms.

»       Understanding of enterprise data platforms and technologies such as Informatica, GoldenGate, MDM, DQ, EDC/Axon, or equivalent technologies is an advantage.

»       Experience working with cloud and modern data platforms such as Microsoft Fabric, Databricks, Snowflake, Azure, AWS, or GCP is an advantage.

»       Understanding of CDC, data integration, metadata, lineage, data governance, and data security.

»       Ability to investigate complex data problems and identify the root cause of inconsistencies.

»       Strong attention to detail and a structured approach to data analysis.

»       Ability to communicate effectively with business users, developers, architects, and senior stakeholders.

»       Experience working in financial services, banking, insurance, or other regulated industries is a strong advantage.