Data Analyst

Pakistan Revenue Automation (Pvt) Ltd Verified

Karachi , Pakistan

Posted Oct 01, 2019 688 views

PKR. 50,000 - 100,000/Month

Apply For This Job


Job Description

  • Develop simple to complex database solutions for OLAP (Online Analytical Processing) environments.  This experience utilizing SQL/PLSQL within an enterprise-class Relational Database Management System (RDMS) with Strong working knowledge of Microsoft SQL.
  • Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks).
  • Analyze & functional specifications & transform OLTP datasets into analytical structures.
  • Develop complex PL/SQL scripts to perform various database related
  • Under the complex Business Processes to find the required dimensions for data analysis.
  • Design DWH architecture and Cube Processing.
  • Estimate storage requirements for an application.
  • Establish an application's security requirements during development.
  • Works with technical team to define conceptual, logical and physical data models
  • Recommends and takes action to solve database or business intelligence related problems.
  • Develops designs and scripts for the extraction, transformation, and loading of data from external sources.
  • Presentation of result oriented data analysis for decision purpose to the decision makers with the help of tools like Microsoft Power BI, SPSS and MS Excel including data models and Charts etc.
  • Monitors project progress by tracking activity; resolving problems; publishing progress reports; recommending actions.
  • • Prepares technical reports by collecting, analyzing, and summarizing information and trends.
  • Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats.


  • Proficient in MS SQL (Functions, Procedures, SPSS, SAS, Packages etc.)
  • Proven Development Experience in Microsoft SQL 2008/2014/2016.
  • Experience working with tools like MS Power BI/ Cognos, OBIEE etc.
  • Enforced data integrity and Knowledge of processes for Data Governance using integrity constraints, DHW concepts and Kimball’s concepts.
  • Experience working with tools like Visio/ ERWIN etc.
  • Technical expertise with statistical tools and concepts like SPSS Statistics, MATLAB etc.
  • Usage of several formulae such as Index, Match, VLookup, conditional and logical formulae etc.
  • Technical expertise regarding data models, database design development, data mining and segmentation techniques.
  • Use of Warehouse techniques Star Schema, Snow Flake Schema, Dimension and Fact table.
  • Use of Cubes & Rollups for making cross-tabular reports.
  • Expertise in handling errors using Exceptions.
  • Experience in working high-transacted OLTP systems.
  • Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.
  • Have worked in fast-paced AGILE environment.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
  • Strong problem identification and analytical skills.
  • Creativity with an eye to develop new and innovative solutions.
  • Excellent analytical and logical skills, including the proven ability to adapt to a dynamic project environment and manage multiple concurrent projects. 

Job Details

Functional Area:
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:
3 Years
Apply Before:
Oct 15, 2019
Posting Date:
Oct 01, 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 - Karachi

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

Similar Job Titles

Data Analyst

Atheneum, Lahore, Pakistan
Posted Oct 17, 2019

Data Analyst

Cyber System (Pvt) Ltd, Lahore, Pakistan
Posted Oct 12, 2019

Data Analyst

Syfaa Textiles, Karachi, Pakistan
Posted Oct 04, 2019

Data Analyst

The Hunar Foundation, Karachi, Pakistan
Posted Oct 01, 2019
View All