Data Analyst

About the role

CoorB builds solutions focused on process automation, user experience and advanced data analytics, helping clients achieve operational excellence in the finance industry. It is looking for a Data Analyst in Jeddah who will work closely with the Data Architect, Technical Data Lead, Business Analysts, ETL and BI Developers, Platform Administrators and business stakeholders. The role covers translating business needs into data requirements, analysing data sources and quality, and supporting the move toward the target data architecture.

Key responsibilities

• Analyse business requirements and translate them into data and analytical requirements, working with stakeholders on processes, KPIs and reporting needs.
• Analyse ODS, DWH, staging, data marts and reporting environments; profile data to find quality issues, duplication, inconsistencies and missing values.
• Investigate existing reports, dashboards and business logic, then define source-to-target mappings, business rules and transformation logic.
• Develop complex SQL queries for extraction, reconciliation, validation and analysis, and support ETL/ELT teams in validating pipelines.
• Support data migration and coexistence between legacy and target platforms, including source-to-target reconciliation.
• Work with BI developers on dashboards, reports, KPIs and semantic models, and support Power BI and other BI solutions.
• Define data quality rules, assist with metadata, data lineage, data ownership and the business glossary, and align requirements with data governance and security.
• Prepare data for advanced analytics, machine learning and future AI/LLM use cases, and communicate findings to technical and non-technical stakeholders.

Required profile

• Strong experience as a Data Analyst, BI Analyst or similar data-focused role.
• Experience gathering and documenting business and data requirements.
• Structured approach to data analysis and good communication with business users, developers and architects.
• Experience in financial services, banking, insurance or other regulated industries is a strong advantage.

Required skills

• Strong SQL and relational databases, preferably Oracle or similar.
• ODS, DWH, data marts, lakehouse, semantic layers, ETL/ELT and BI architectures.
• Data profiling, reconciliation, validation and data quality analysis.
• Data modelling (facts, dimensions, relationships).
• Power BI or similar BI platforms.
• Advantage: Informatica, GoldenGate, MDM, CDC, Microsoft Fabric, Databricks, Snowflake, Azure, AWS, GCP.