Data Analyst / Modeler

Opportunity Data Modeler • Develop data architecture solutions to unlock the data and insights necessary to support business users and strategic planning, monitoring Mortgage and Savings Portfolio. • We are looking for someone with strong technical skills as well as stakeholder management. Key Skills/Knowledge: • 5 years of hands-on experience with physical and relational data modeling. • Knowledge of mathematical foundations and statistical analysis. • Data Analysis and Modelling • Creating Conceptual, Logical and Physical Data Models • Stake Holder management • Functional knowledge in Mortgages • Advanced troubleshooting skills Key responsibilities • Engage with business users to assess their information needs and review the business process and conceptualize the entities. • Determine/Develop ER diagrams, logical data model. • Transform the logical data model into physical model and work with DBA team to instantiate and manage the data. • Collaborate with the BI and Analytics teams on creating the optimized, reusable semantic model, complete with metadata and lineage information. • Optimize the model to ensure predictable performance. • Maintain the metadata and its structure • Recommend and establish standards, guidelines, and procedures for design and maintenance. • Strong working skills in SQL, understanding of the basic principles of data warehousing and multi-dimensional data modelling. • Has the ability to present data in a range of formats, while understanding the audience. • Strategic thinker and able to make decisions based on sound judgement. • Adaptable and willing to learn new skills. • Experience in Erwin would be beneficial but not essential • Experience in BFS would be beneficial but not essential