Similar Jobs

Pakistan Single Window

BI Data Modeler Architect

Pakistan Single Window. Pakistan

Karachi, Pakistan

2025-01-21

Main Responsibilities:

  1. Design, develop, and maintain conceptual, logical, and physical data models to integrate data for PSW’s BI and analytics systems.
  2. Collaborate with business stakeholders to translate business requirements into data model designs.
  3. Ensure data models adhere to best practices for performance, scalability, and maintainability.
  4. Work closely with data engineers to define ETL pipelines and ensure seamless integration of data into BI platforms.
  5. Optimize data models for reporting tools such as Oracle Analytics Server, Power BI, or Tableau.
  6. Establish and enforce standards for data quality, consistency, and accuracy within the data warehouse.
  7. Implement data lineage and metadata management practices in dimensional data models.
  8. Analyze and optimize queries, indexes, and data structures to improve BI reporting and dashboard performance.
  9. Monitor and troubleshoot data models for potential performance issues.
  10. Maintain comprehensive documentation of data models, definitions, and relationships.
  11. Collaborate with business analysts, data scientists, and BI developers to align data models with reporting and analytics requirements.
  12. Stay updated with advancements in BI tools, database technologies, and data modeling methodologies.
  13. 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

Skills:

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

Salary 550000
Job Type First Shift (Day)
Qualification Bachelor
Experience 9 Years
Sectors Database Administration (DBA
Gender No Preference
Industry Information Technology
Career Level Experienced Professional
Job Expiry Date 2025-02-07