Ottawa job board updated daily with only local opportunities!

Data Analyst Modeller


This is a Contract position in Ottawa region, ON posted August 9, 2017.

Job DescriptionData Analyst Modeller Position Description CGI currently has a requirement for a Data Analyst Modeller for a full-time/permanent OR long term contract opportunity in the Ottawa area. The successful candidate will work closely with colleagues in the Financial Markets and Banking Operations (FMBO) portfolio teams in the Information Technology Services Department, interacting with clients on a regular basis to model and document data requirements. Your primary responsibility is to ensure a holistic view of all data-related functions and the data architecture of the FMBO portfolios. You will achieve this by defining the data architecture as well as designing, developing, managing and updating data models, including physical and logical models serving databases for online, transaction-based applications and specialized data-warehouse applications. Your future duties and responsibilities As a Senior Data Analyst/Modeller, you provide advice and guidance on IT concepts, architectures, policies and standards to management, colleagues and clients. You also contribute to the solution architectures, business requirements, process models, functional designs, micro design specifications and delivery strategies. You develop and sustain relationships with business partners and stakeholders in ITS and share technological trends and recommendations with colleagues, domain architects, and the leadership team. You develop the data architectures for FMBO solutions by analyzing system integration challenges related to the data and proposing appropriate solutions. You contribute to performance measurement strategies and solution deliverables related to the data protection and recovery strategy, threat risk assessment, security sensitivity, and audit. You oversee all components of database solutions as core to the data domain (including quality assurance, documentation completeness and transition to the operation support area). You contribute to the delivery strategy including new system components, overall performance measurements and standards, decommissioning of legacy systems and integration of data conversion components, to align with the cutover strategy and plans. You also provide the database analysis and design expertise to build the conceptual, logical and physical data models to support the solution components, which includes all data services within the data architecture. Following delivery of these solutions, you support day-to-day business transaction operations, business analytics, data discovery and reporting capabilities for data visualization. You champion the portfolio data architecture framework and continue to build foundation components of the reference data architecture, which include standards, policies and guidelines supporting data governance, data architecture, the data lifecycle, data quality and protection, metadata management and master data management. In addition to this, you foster professional growth within the community of data modellers to evolve and promote the data management function. Required qualifications to be successful in this role Your education and experience bachelors degree in computer science, mathematics, management of information systems or a relevant field a minimum of seven years of relevant experience in the IT field, focused in the data architecture domain a minimum of five years of experience in data modelling and data analysis in application development projects or initiatives ranging from six months to three years in duration or an equivalent combination of education and experience may be considered Your knowledge and skills You are a self-starter who can manage multiple, concurrent responsibilities; meet deadlines; work independently or as part of a team; and communicate effectively. You have strong analytic and problem-solving skills with the ability to make sound decisions and recommendations. You have experience with: establishing the foundation components of data architectures to support operational and analytic reporting solutions, including the development and application of enterprise standards for data modelling, data architecture principles and best practices for transactional and data warehouse designs analyzing complex issues and diagnosing multi-dimensional problems data modelling and query tools, preferably Embarcadero ER/Studio, Erwin relational databases, Oracle 12C Database and SQL Server 2012 developing, validating, publishing and maintaining conceptual, logical and physical data models and all associated database documentationAssets previous experience working in a dynamic and agile environment experience with managing metadata for data models experience in mentoring and coaching other data modellersAdditional information Priority will be given to Canadian citizens and permanent residents Eligible for secret clearance English and French essential olinguistic requirement (minimum starting level): intermediate in second official language (training may be