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.

Server Administrator

Montreal
Job Order: MM-6997
Job Description: Provide technical expertise and works autonomously; Establish and implement policies, procedures, and technologies to ensure server security; Serve as the cornerstone for escalating server issues; provide timely response to customer escalations; Plan and implement server upgrades, maintenance fixes, and vendor-supplied patches; Monitor and test system performance and provide...
DATE POSTED 2019-04-09

Software Developer

Toronto
Job Order: SE-7003
Job Descriptions:   Designs and develops new software and modifies and enhances existing software for clients’ systems, and for the company base software. Communicates directly with the clients to ensure that requirements and specifications are understood fully. Reviews completed software designs or prototypes with clients. Tests software and ensures that completed work correctly...
DATE POSTED 2019-03-06

Sr. IT Administrator

Markham
Job Order: GD-7007
Job Description: Manage daily IT operations at company headquarters and branch offices including general technical support (Helpdesk support, tele/video conferences, WebEx meetings, photocopier and fax machines, unified communications systems, etc.), data backup/recovery, vendor management, system monitoring and access control. Participate in the development, maintenance, and monitoring of...
DATE POSTED 2019-03-28

EndPoint Infrastructure Administrator

Montreal
Job Order: MM-7008
Job Description: •    Plan and implement end point & server upgrades (SCCM), maintenance fixes, and vendor-supplied patches; •    Establish and implement policies, procedures, and technologies to ensure end point security; •    Monitor and test system performance and provide performance statistics and reports; •  ...
DATE POSTED 2019-04-09
Warning

Please, enter a valid value

Thank you.

Your password successfully changed.