BI Data Modeler Architect

Pakistan Single Window

۳ گھنٹے پہلے شائع ہوئی 5 نے دیکھا Report Job

PKR. 450,000 - 550,000/Month

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

مہارتیں

Communication Skills PosstgreSQL SQL Erwin Data Models Oracle PowerBI BI Platforms ETL Tools

نوکری کی تفصیلات

صنعت:

انفارمیشن ٹیکنالوجی

شعبہِ افعال:

ڈیٹا بیس انتظام (DBA)

کل عہدے:

1 اشاعت

نوکری کی شفٹ:

پہلا پہر

نوکری کی قسم:

مستقل

محکمہ:

Technology Solution

نوکری کا مقام:

کراچی, پاکستان

جنس:

کوئی ترجیح نہیں

کم از کم تعلیم:

بیچلرز

ڈگری کا عنوان:

Bachelor’s degree in computer science, Information Systems, Data Analytics, or a related field.

کیریئر کی سطح:

تجربہ کار پیشہ ور

کم از کم تجربہ:

9 سال

اس سے پہلے درخواست دیجیۓ:

فروری ۰۷, ۲۰۲۵

تاریخِ اِشاعت:

جنوری ۲۰, ۲۰۲۵

Pakistan Single Window

انفارمیشن ٹیکنالوجی · 101-200 ملازمین - کراچی

پیروی کریں

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.