Senior Data Warehouse Consultant

Nextwo Co.; Riyadh; On-site; SAR 350,000 - 550,000; Full time

Job summary

Nextwo Co. seeks a Senior Data Warehouse Consultant with 10+ years of hands-on experience in designing, building, and optimizing enterprise data warehouse solutions for banking.

The consultant will lead architecture and delivery initiatives, translating complex requirements into scalable, compliant data platforms that support regulatory reporting, risk analytics, customer analytics, and executive decision-making.

Qualifications

• Bachelor's degree in CS/IS/Data Eng or related field; Master preferred.
• Minimum 10 years in data warehousing, BI, and data engineering.
• 7-10 years in banking/financial services; Islamic banking preferred.
• Proven track record delivering 2-3 end-to-end DWH implementations in lead roles.
• Experience in consulting/SI environments is a plus.

Responsibilities

• Lead data warehouse design, development, and optimization across the enterprise platform.
• Translate business and regulatory requirements into robust data models and ETL solutions.
• Perform performance tuning, capacity planning, and architecture reviews.
• Mentor junior engineers and enforce development standards.
• Coordinate with risk, finance, and compliance stakeholders.
• Ensure compliance with data governance and security policies including Shariah-aligned policies.
• Support data migration, modernization, and cloud-transformation initiatives.

Skills

Leadership

Stakeholder management

Communication

Mentoring

Problem solving

Education

Bachelor's degree in Computer Science/Info Systems/Data Eng

Master's degree preferred

Tools

Power BI

Tableau

OBIEE/OAC

MicroStrategy

Collibra

Alation

Informatica EDC

Teradata

Job description

We are seeking a Senior Data Warehouse Consultant with 10+ years of hands-on experience in designing, building, and optimizing enterprise data warehouse solutions within the banking sector. The consultant will lead data warehouse architecture and delivery initiatives, translating complex business requirements into scalable, high-performance, and compliant data platforms that support regulatory reporting, risk analytics, customer analytics, and executive decision-making.

Key Responsibilities

• Lead data warehouse design, development, and optimization efforts across the enterprise data platform.
• Translate business and regulatory requirements into robust data models and ETL solutions.
• Perform performance tuning, capacity planning, and architecture reviews.
• Mentor junior engineers and enforce development standards and best practices.
• Coordinate with business units, risk, finance, and compliance stakeholders.
• Ensure solutions comply with the bank's data governance, information security, and Shariah-compliance-aligned policies.
• Support data migration, modernization, and cloud-transformation initiatives.

Qualifications & Experience

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field (Master's degree preferred).
• Minimum 10 years of progressive experience in data warehousing, BI, and data engineering.
• Minimum 7-10 years of that experience within the banking or financial services industry (retail, corporate, or Islamic banking preferred).
• Proven track record of delivering at least 2-3 end-to-end enterprise data warehouse implementations in a lead or senior capacity.
• Experience working with or within consulting/system-integrator environments is a plus.

Technical Skills (Required)

Data Warehouse Architecture & Modeling

• Expert-level knowledge of Kimball, Inmon, and Data Vault methodologies.
• Experience with industry-standard banking data models (e.g., Teradata FS-LDM, FIBO, or equivalent financial data frameworks).

Databases & Platforms

• Deep expertise in at least two enterprise RDBMS: Oracle, Microsoft SQL Server, Teradata, PostgreSQL.
• Familiarity with big data ecosystems (Hadoop, Spark) and data lake/lakehouse architectures.

BI & Reporting

• Experience with BI tools: Power BI, Tableau, OBIEE/OAC, MicroStrategy, or equivalent.
• Ability to design semantic layers, data marts, and executive dashboards for senior management.

Data Governance & Quality

• Solid understanding of data governance frameworks, metadata management, data lineage, master data management (MDM), and data quality monitoring.
• Knowledge of data catalog tools (e.g., Collibra, Alation, Informatica EDC) is a plus.

4. Banking Domain Knowledge (Required)

• Working knowledge of core banking systems (e.g., Flexcube, T24, or equivalent) and typical source-system landscapes (channels, cards, payments, loans, deposits, treasury).
• Understanding of banking regulatory and reporting contexts, including:SAMA regulatory reporting requirements (for Saudi-based institutions)
• Experience supporting Customer 360, profitability, CRM, and MIS reporting initiatives.

Certifications (Preferred)

• CDMP (DAMA Certified Data Management Professional)
• Informatica, Teradata, or Databricks certifications
• TOGAF or equivalent enterprise architecture certification is a plus

Soft Skills

• Excellent stakeholder management and communication skills (English required; Arabic is a strong plus).
• Strong analytical and problem-solving abilities.
• Ability to work independently in a consulting capacity while integrating with internal teams.
• Leadership and mentoring capability for multi-member delivery teams.