Senior Data Warehouse Consultant

About the Role

Nextwo Co. is seeking a Senior Data Warehouse Consultant to join our team in Riyadh, Saudi Arabia. This full-time role requires over 10 years of experience in designing, building, and optimizing enterprise data warehouse solutions, specifically 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.

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 and 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

• Data Warehouse Architecture & Modeling: Expert-level knowledge of Kimball, Inmon, and Data Vault methodologies. Strong dimensional modeling: star/snowflake schemas, SCD (Type 1/2/3), fact/dimension design, conformed dimensions, and slowly changing dimension strategies. Experience with industry-standard banking data models (*, 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 (*, Collibra, Alation, Informatica EDC) is a plus.

Banking Domain Knowledge and Certifications

• Banking Domain: Working knowledge of core banking systems (*, 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.
• Preferred Certifications: CDMP (DAMA Certified Data Management Professional), Cloud certifications (Azure Data Engineer / AWS Data Analytics / Snowflake), 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.