Jr. Data Analyst

Pakistan Revenue Automation (Pvt) Ltd Verified

Multiple Cities, Pakistan

Posted Feb 03, 2020 997 views

PKR. 30,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 (RDBMS) with Strong working knowledge of Oracle and Microsoft SQL.
  • Strong knowledge of and experience with OBI EE, 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 Oracle Business Intelligence (BI) and 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 Oracle / MS SQL (Functions, Procedures, Packages, SPSS, SAS etc.)
  • Proven Development Experience in Oracle Business Intelligence Suite.
  • Experience working with tools like OBIEE, MS Power BI/ Cognos 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

Total Positions:
6 Posts
Job Shift:
First Shift (Day)
Job Type:
Development - II (MIS)
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:
Fresh (Relevant Experience will be preferred.)
Apply Before:
Feb 17, 2020
Posting Date:
Feb 03, 2020
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, 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

Curiato, Lahore, Pakistan
Posted Feb 24, 2020

Data Analyst

Blackstone Financial, Karachi, Pakistan
Posted Feb 19, 2020

Project Coordinator / Data Analyst

Powersoft19, Lahore, Pakistan
Posted Feb 19, 2020

Data Analyst

Samsons Group of Companies, Lahore, Pakistan
Posted Jan 16, 2020
View All