Posted 2 hours ago 5 views Report Job
Main Responsibilities:
- Design, develop, and maintain conceptual, logical, and physical data models to integrate data for PSW’s BI and analytics systems.
- Collaborate with business stakeholders to translate business requirements into data model designs.
- Ensure data models adhere to best practices for performance, scalability, and maintainability.
- Work closely with data engineers to define ETL pipelines and ensure seamless integration of data into BI platforms.
- Optimize data models for reporting tools such as Oracle Analytics Server, Power BI, or Tableau.
- Establish and enforce standards for data quality, consistency, and accuracy within the data warehouse.
- Implement data lineage and metadata management practices in dimensional data models.
- Analyze and optimize queries, indexes, and data structures to improve BI reporting and dashboard performance.
- Monitor and troubleshoot data models for potential performance issues.
- Maintain comprehensive documentation of data models, definitions, and relationships.
- Collaborate with business analysts, data scientists, and BI developers to align data models with reporting and analytics requirements.
- Stay updated with advancements in BI tools, database technologies, and data modeling methodologies.
- Evaluate and recommend tools or frameworks to enhance PSW’s BI and data modeling capabilities.
Qualifications, Experience and Skills:
- Bachelor’s degree in computer science, Information Systems, Data Analytics, or a related field.
- 9+ years of experience in data modeling, BI, or data warehousing.
- Strong experience in designing and implementing data warehouses or data lakes.
- Expertise in data modeling tools (e.g., Erwin, SQL Developer Data Modeler, Toad Data Modeler).
- Proficiency in SQL for data querying and manipulation.
- Experience with BI platforms such as Oracle Analytics Server, Power BI, or Tableau.
- Familiarity with database technologies like Oracle, SQL Server, or PostgreSQL.
- Strong analytical and problem-solving abilities.
- Excellent communication and documentation skills.
- Ability to work collaboratively in a cross-functional team environment
Job Details
Pakistan Single Window
Pakistan Single Window (PSW) is an ICT-based system in Pakistan providing a single window for trade. PSW is a facility that allows parties involved in trade and transport to lodge standardized information and documents at a single-entry point to fulfill all import, export, and transit-related regulatory requirements. If information is electronic, then individual data elements need to be submitted only once. PSW will connect relevant government departments with each other and with economic operators like importers, exporters, customs agents, shipping agents, transporters etc, in Pakistan for efficient management of cross border trade. It will provide the ease and transparency in achieving compliance with relevant regulatory requirements, through an on-line facility, that will intelligently handle the information for each transaction without the need to provide same information more than once or to physically visit such government departments. Pakistan has committed to implement various provisions of World Trade Organization’s (WTO) Trade Facilitation Agreement that includes implementation of a National Single Window (NSW) system before February, 2022. Pakistan also needs PSW implementation to overhaul management of its external trade for reducing time, cost and complexity involved to improve its position in various global rankings on competitiveness and ease of doing business. Guiding vision and mission objectives: VISION: Pakistan will establish a world-class automated hub by 2022, offering services and creating efficiencies, to reduce cross border trade related costs, time and complications for improved trade facilitation and compliance. MISSION: Improve cross-border trader processing by providing centralized ICT based services, simplified processes, effective and reliable automation, harmonized data exchange and risk-based selectivity in enforcement of government’s regulations.
What is your Competitive Advantage?
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Zohaib Ali
Marketing Manager
Digital Online Devices
Muzammil Baig
Digital Marketing Manager
IT Services Group
Aqib Irshad
Head of HR, Training & OD
FINCA
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Ali Aziz
CEO
Shopistan
Mona Sharif
Senior Team Lead
Konext PVT. LTD
