| Position Details |
Job order - J0717-1377 - Permanent Full Time
|
| Title |
Data Analyst Modeller |
| Category |
Database Administration |
| City |
Ottawa, Ontario, Canada |
|
| Job Description |
Data 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
• bachelor’s 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 documentation
Assets
• previous experience working in a dynamic and agile environment
• experience with managing metadata for data models
• experience in mentoring and coaching other data modellers
Additional information
• Priority will be given to Canadian citizens and permanent residents
• Eligible for secret clearance
• English and French essential
o linguistic requirement (minimum starting level): intermediate in second official language (training may be provided to help the selected candidate reach the required level of functional)
Build your career with us.
It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change—supporting our clients’ digital journeys and offering our professionals exciting career opportunities.
At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.
Be part of building one of the largest independent technology and business services firms in the world.
Learn more about CGI at www.cgi.com.
No unsolicited agency referrals please.
CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation. Please let us know if you require a reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.
|
|
| Skills |
|
|
| Reference |
560994 |
|
|
Click here to apply
|
|
|
|