Data Analyst

CoorB; Saudi Arabia; On-site; SAR 120,000 - 190,000; Full time

Job summary

CoorB is seeking a Data Analyst/BI Analyst to translate business requirements into robust data and analytics solutions. You will work with stakeholders to define KPIs, data sources, and reporting needs, and develop SQL queries, data models, and semantic layers for dashboards.

Experience with Power BI and Oracle is preferred, along with cloud platforms such as Azure/AWS. You will collaborate across ETL/ELT teams and data governance activities, ensuring data quality and clear communication of

Qualifications

• Strong SQL skills and experience with relational databases.
• Solid data modeling concepts: facts, dimensions, relationships.
• Experience with data profiling, reconciliation, and data quality analysis.
• Ability to gather and document business and data requirements.
• Experience with BI platforms like Power BI.

Responsibilities

• Analyze business requirements and translate into data and analytics specifications.
• Collaborate with stakeholders on KPIs, reporting needs, and data sources.
• Develop and optimize SQL queries for data extraction and validation.
• Support ETL/ELT teams and validate data pipelines during migrations.
• Define data source-to-target mappings and business rules.
• Create analytical datasets and semantic layer requirements for dashboards.
• Assist with metadata, lineage, and data governance activities.
• Communicate analytical findings to technical and non-technical audiences.

Skills

SQL Proficiency

Data Modeling

ETL/ELT

Data Profiling

Communication

Tools

Power BI

Oracle

Azure

AWS

Job description

Responsibilities

b YOU WILL b 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.

Qualifications

• 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.