Job Summary
A Senior Data Modeler at PBT Group is responsible for designing and implementing data models that effectively capture, integrate, and display corporate data. The role involves working closely with key stakeholders to translate business requirements into robust scalable data architectures to support business intelligence and data warehousing solutions.
Duties/Responsibilities:
- Develop comprehensive logical and physical data models.
- Conduct detailed data analysis to design the data model for the data warehouse or BI solution.
- Participate in defining project requirements by working closely with Business Analysts and other stakeholders.
- Assist ETL Analysts and Business Analysts in defining source-to-target data mappings.
- Support business requirement definition activities, requiring a strong understanding of business rules.
- Collaborate with Business Analysts, ETL Analysts, Solution Architects, and Database Administrators to execute data modeling tasks.
- Review and evaluate data models developed by others, ensuring integration and alignment with company standards.
- Ensure the integrity, accuracy, and completeness of data models.
Skills and Experience Required:
- Extensive knowledge of existing corporate data models and the business environment.
- Proficiency in traditional and modern data modeling techniques, including normalized, dimensional, and multi-dimensional modeling.
- Experience in full life cycle data warehousing projects is essential.
- Understanding of data warehousing, data mart architectures, and front-end data analysis/reporting tools.
- Ability to abstract and conceptualize data models quickly and efficiently.
- Strong attention to detail, ensuring precision in the data modeling process.
- Proficient in conceptual, logical, and physical data modeling.
- Strong SQL querying skills and familiarity with DBMS tuning.
Qualifications/Certification:
- Training in data warehouse design methodologies and data modeling (both normalized and dimensional).
- Experience with industry-standard data modeling tools.
- B.Sc. in Computer Science, Information Systems, Business Administration, Commerce, or a related field is advantageous.
Additional Information: The ideal candidate will have a proactive approach to data modeling, capable of anticipating future needs and challenges. They should be meticulous in their work and possess the ability to engage with and understand complex business requirements to develop effective data management solutions.