Data Modeler

Driving business and technical discussions to define/design/deliver the data model to support the required analytics.

MAIN DUTIES & RESPONSIBILITIES:

• Plays lead role on external/internal IT projects/programmes and ensure that the specified results are achieved within the agreed time, budget and of the required quality

• Analyzing and translating business needs into long-term solution data models

• Working with the development team to create conceptual data models and data flows.

• Implementing data strategies and developing physical data models

• Daily management of the group’s data warehouse infrastructure including support planning, issue resolution and critical process monitoring

• Develop monitoring dashboards, automate and optimize key data integration processes.

• Provide subject matter expertise and represent IT/MIS as resource on JMMB projects as assigned   

• Own efforts to integrate new data sources into the group data warehouse and manage projects to migrate existing reports from legacy platform to the group data warehouse. Develop complex highly technical solutions to satisfy the reporting and analytical needs the business

• Lead code review and deployment sessions

• Establishes standards and guidelines for coding, performance optimization, documentation, quality assurance and production support.

• Advocates continuous improvement including identification of opportunities, adoption of best practices and standards.

• Follows process and project methodology, ensuring proper implementation and adoption.

• Work closely with business functional teams in designing and implementing Business Intelligence (BI) solutions that will support short and long term reporting and analysis goals

• Assist in the refinement of processes to increase the efficiency and quality of analyzing business data to meet current and future business needs

• Form effective relationships with a broad cross-section of personnel in order to effectively accomplish the position's tasks. These relationships include, but are not limited to the following teams: Marketing, FACT, Product Development, Client Care, Branch Operations, Trading, Risk and Senior Managers

• Promotes the JMMB’s philosophy of the Vision of Love and its unique culture and Is engaged in the transformation process for the continuous improvement of JMMB.

   

  EDUCATION, TRAINING & WORK EXPERIENCE REQUIRED:

• Masters’ degree in Computer Science, and Information Technology or equivalent qualification from a recognised tertiary institution.

• Six (6) years’ experience in physical and relational data modelling, and software design principles

• Training or experience in key JMMB technologies, data warehousing tools and concepts, business intelligence and business performance analysis and reporting

• Deep understanding of the financial sector laws, regulations, ethics and professional jargon. Working knowledge of local and overseas investment instruments also desired

• Ability to translate complex user requirements to systems requirements and complete system design and documentation

• Expertise in standard databases, query tools, and programming languages such as SQL, and Extraction tools

• Demonstrated extraction/transformation/load (ETL) process performance tuning skills

• Strong data analysis skills including the ability to manipulate and interpret large datasets

• Experience with reporting / OLAP tools such as: Business Objects, Balance Scorecard, Crystal Reports and SSRS

• Strong oral and written communication skills

• Experience with complex system environments

• Project management experience a definite plus

• Strong business analytical and documentation skills

• Working knowledge of financial sector instruments, laws, regulations, ethics and professional jargon

• Experience with team management

• Excellent understanding of Data Warehousing concepts

• Balancing technical and business focused stakeholder demands while prioritizing action and outcomes.

• Good understanding of technical data forensics, able to independently research data structures (relational SQL, semi-structured, Excel, Csv, etc.

• Strong networking skills and ability to work across multiple organizations to accomplish diverse goals