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.