Login


New to IMS? Register Now

Forgot Your Password?

Enterprise Data Administrator

Toronto
Job Order: SE-6939

Job Responsibilities and Duties:

  • The Enterprise Data Administrator is responsible for setting standards and modeling operational and analytical data; structured and unstructured data; data in motion and data at rest.
  • The Enterprise Data Administrator plays a data stewardship role, and is a key participant in the Information Lifecycle Management.
  • The Enterprise Data Administrator is expected to assess new technologies and techniques that can drive improvements in reliability, agility, and business performance.
  • Participate and contribute to team's data governance strategy including Data Architecture Management, Data Development, Database Operations Management, Data Security Management, Reference and Master Data Management, Data Warehousing and & BI Management, Document & Content Management, Meta-data Management, Data Quality Management.
  • Design, construct and deploy database solutions by analyzing client requirement, operations, applications, and programming.
  • Identify and evaluate current data management technologies. Integrate technical functionality (e.g. scalability, security, performance, data backup and recovery, reliability, etc.)
  • Collaborate with the team to guide them through the actualization of the data architecture.
  • Facilitate the establishment of data standards and enforce the implementation.
  • Support developers in the application of data models and standards to ongoing projects.
  • Work with DBA to instantiate physical data models and optimize performance of queries and stored procedures.
  • Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
  • Installs database systems by developing flowcharts; applying access techniques; coordinating installation actions; documents actions.
  • Provides database support by coding utilities, responding to user questions, and resolving problems.
  • Participates in Business Intelligence projects, and works with analytical group and IT to ensure implementation.
  • Frames and conducts complex analysis and experiments using various statistical techniques.
  • Establish taxonomy to manage unstructured data. Developing strategies to analyze unstructured data.
  • Ensure that compliance and security standards are reflected in the development of data architecture assets.
  • Constantly monitor, refine and report on the performance of data management systems.
  • Implement measures to ensure data accuracy and accessibility.
  • Research new opportunities for data acquisition and build an inventory of data needed to implement the architecture.
  • Maintain a corporate repository of all data architecture artifacts and procedures.
  • Identify sources of enterprise master data and implement master data management strategy, ensuring compliance and proper protection.
  • Work with the team and business data stewards to maintain data integrity by data scrubbing and setup the rules to guide business data entry.
  • Coordinate and facilitate consultation with stakeholders to define business and process requirements.
  • Creates discover-access-distill ("DAD") strategies to bring significant value data understanding.
  • Create a fluid, end-to-end vision for how data will flow through an organization.
  • Accomplish information systems and organization mission by completing related results as needed.
  • Assessing new industry and technology trends and making recommendations on technology direction.
  • Follow standard processes and be constantly aware that the execution of work supports the ultimate goal of providing excellent service to the Company's current and potential customers, including internal customers.
  • Perform other duties as assigned.

 

Job Skills and Requirements:

  • University degree or college diploma in the field of computer science, statistics or data science.
  • 10 years' experience in database development, operations, maintenance and data governance by determining structural requirements, developing and installing solutions.
  • A minimum of 10 years of database development, operations, maintenance experience, during which both professional and management capabilities have been clearly demonstrated.
  • Extensive expertise in data architecting, development, security management, master data management, data mining, data modeling (physical and logical) and data grooming.
  • 8 years of working experience in relational SQL database Oracle (including but not limited to SQL, PL/SQL, Stored Procedure, Views, Functions).
  • Solid experience in ETL (Extract, Transform, Load) processes and tools is a must.
  • Ability to fine tune PL/SQL queries with strong trouble shooting skills.
  • Proven skills to design Data Warehouse schema and define ETL for DW. Knowing SAP Business Objects 4.1 (Webi,Universes) is an asset.
  • Extensive experience providing practical direction on information and analytics platforms in conjunction with EDW tools and technologies.
  • Good understanding in SDLC and Agile/Waterfall methodologies.
  • Strong experience in Business Process Modeling (BPM).
  • Extensive experience for collecting business requirement from customers, and transform the requirements into DB data processes and data schema.
  • Experience in and understanding of a wide variety of analytical processes (governance, measurement, information security, etc.).
  • Structured thinker and effective communicator, comfortable with interacting with customers.
  • Proven communication skills (written and verbal) for negotiating and consensus building.
  • Strong interpersonal skills - demonstrate a positive attitude, able to work effectively as part of a project team and foster team collaboration.
  • Superior organizational skills; prioritization, planning and time management.
  • Develops specific metrics for quality and consistency reviews of data.
  • Attention to detail and maintaining high quality standards is a must.
  • Draws conclusions and effectively communicates findings with both technical and non-technical team members, providing feasible solutions to project team and business community.
  • Ability to work independently, establishing strategic objectives, project plans and milestone goals.
  • Determine impacts and remediation migrating to new target schema/instance environment.
  • Ability to comprehend complex technical and logical concepts and adapt quickly to change.
  • The ability to work efficiently, under pressure and to deadlines.
  • Up-to-date knowledge of technology and the Data Protection Act.
  • Ability to work well in a fast paced environment, where the technology is constantly changing.

 

 

DATE POSTED 2017-06-23

Shown below are the latest jobs from this category.

Java Web Developer

Toronto
Job Order: CP-6825
Responsibilities Deliver exceptional client results and project success. Learn our client's business, their organization, systems, challenges and goals. Work directly with the client to define and clarify requirements. Work with your team to create accurate project and task estimates. Consistently develop and deliver high-quality, low-defect features on schedule....
DATE POSTED 2016-03-30

DevOps Engineer

Toronto
Job Order: SE-6980
JOB RESPONSIBILITIES:  Take ownership of our test, staging and production delivery pipelines. Evaluate new technologies and make recommendations on how to streamline or improve our systems Monitors and tunes the performance of the infrastructure Identify and correct bottlenecks in the system, while working with development teams on optimizations and best-practices Improves operation and...
DATE POSTED 2018-03-20

Senior Citrix Administrator

Montreal
Job Order: MM-6982
Job Description: Provide Level 3 support on Citrix technologies, such as: XenApp 4.0,6.5,7.6 & 7.15 XenDesktop, Provisioning services and Netscaler. Manage/support Citrix application builds & release cycles; Assist in the design and/or upgrade of Citrix; Create and install GPO's Install & upgrade Domain Controllers; Create and manage scripting tools (ie: Powershell)...
DATE POSTED 2018-03-20

Database Administrator (MS-SQL)

Montreal
Job Order: MM-6983
Job Description: Provide Level 3 support on MS-SQL; Detect and troubleshoot SQL Servers related CPU, memory, I/O, disk space and other resource contention; Manage backups, restores, recovery models, database shrink operations, DBCC commands, database mirroring, replication; Work efficiently on indexes, integrity checks, configuration, patching; Work efficiently with SQL Server tools (...
DATE POSTED 2018-03-20

Server Team Lead, IT Operations

Montreal
Job Order: MM-6984
Job Description: Provide technical expertise and guidance to his team in a lead capacity and works autonomously; Acts as an internal expert resource in the exchange of technical information for project teams, and provides technical insight and recommendations to the business; Grow team expertise to meet demand and to support technology direction; always look for ways to enhance value delivered; ...
DATE POSTED 2018-03-21

IT Systems and Compliance Administrator

Toronto
Job Order: SE-6987
Job Responsibilities: Installing & maintaining Windows Servers in a VMware environment Patch management for Windows computers Administer cloud-based systems including Office 365, OpenDNS/Cisco Umbrella, Symantec Anti-virus and Total Uptime. Fortinet VPN administration Administration of Active Directory, Group Policy, DHCP and DNS Administration of SMTP Servers Head Office WIFI network...
DATE POSTED 2018-05-14
Warning

Please, enter a valid value

Thank you.

Your password successfully changed.