Data Analyst

ABOUT CoorB

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.

• 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, Golden Gate, 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.