Apply For This Job


Job Description

PRAL is looking for an experienced Data Warehouse Architect who has both broad and deep knowledge of Data Warehouse to join a team of experts.


  • Must have 6+ Years of Experience for Data Warehouse Architect
  • Architecture and design of enterprise Data Warehouse while providing technical leadership for Data Warehouse implementations, with design and coding standards
  • Data Modeling experience for Relational (ERD), Dimensional (Star Schema), Columnar and Big Data solutions
  • Deep experience with Data Architecture, Database Design including Data Quality and Master Data Management (MDM) tools, processes and governance
  • Experience with the BI / DW lifecycle components including Source data analysis, ETL, ODS, DataMarts, Reporting, Dashboards, Analytics)
  • Developing solution architecture using business stakeholders' requirement and transforming into conceptual data models, including socializing and implementing logical and physical DW/data mart data models; identifying data sources and metadata (including business rules, definitions, attributes, etc.) to deliver analytic requirements
  • At least two full lifecycle implementations, BI/SQL, DW/SQL/ETL/Modeling tools and other related technologies involving:
  • BI and enterprise DW data management, modeling, integration and/or synchronization, quality, security, conversion and analysis, star schema and relational reporting models, enterprise data management policies, procedures, compliance and risk management and/or database administration,
  • Design and development of data models, extraction code and cleansing routines utilizing typical data quality functions, i.e. standardization, transformation, rationalization, linking and matching that leverages data standards, processes and technology management for data, master data, and metadata; and, data security (including data masking and related data protection techniques)
  • Providing support for planning and performing database migrations, upgrades and updates
  • Big Data experience with data architecture, design and deployment. Hadoop experience a big plus
  • Experience with oracle platforms: Oracle OBIEE оr Exadata, Oracle Analytic Workspace Manager (AWM) and Oracle Essbase

Job Details

Total Positions:
1 Post
Job Shift:
First Shift (Day)
Job Type:
Job Location:
No Preference
18 - 50 Years
Minimum Education:
Degree Title:
4 years Bachelors in Computer Science / Information Technology, from some reputed foreign or HEC-recognized institution.
Career Level:
Experienced Professional
Minimum Experience:
6 Years (6+ Years of Experience for Data Warehouse Architect)
Apply Before:
Dec 12, 2019
Posting Date:
Nov 27, 2019
Show fewer details Read full job description

What is your Competitive Advantage?

Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Try Rozee Premium

Pakistan Revenue Automation (Pvt) Ltd

Information Technology · 1001-1500 employees - Islamabad

Pakistan Revenue Automation (Pvt.) Ltd. (acronym – PRAL) has extensive experience of working with federal and provincial tax and revenue agencies to provide wide variety of tax and revenue collection solutions. Since its incorporation in June, 1994, PRAL has been involved in the development of wide ...Read More