Login


New to IMS? Register Now

Forgot Your Password?

Enterprise Data Warehouse Developer

Toronto
Job Order: SE-6940

Job Skills and Requirements:

 

  • University degree or college diploma in the field of Computer Science
  • 10 years' experience in database development, operations, maintenance and data governance by determining structural requirements, developing and installing solutions.
  • Must be able to work with data sets throughout their life cycle, from development to transformation, storage and usage. This is a hands-on position throughout all project work.
  • This position requires a strong knowledge of ORACLE 12g, ODI, ERWIN, Business Objects 4.1.
  • 5 years in Report/Dashboard/Analytical solution development
  • A minimum of 5 years in developing solutions with Business Objects 4.x including universes, EBI, Crystal Reports and Tableau
  • A minimum of 5 years in writing ORACLE PL/SQL procedures and functions
  • Knowledge of Dimensional Data Warehouse objects and concepts
  • Understanding of ETL processes and dependencies
  • Create solution blue prints, perform unit testing and be able to develop technical documentation
  • Create end-to-end DW/BI solutions, individually as well as in collaboration with the team
  • Must assure work is in compliance with IT's governance
  • Must provide a set of requirements and documentation for all project work
  • Must be able to audit and diagnose systems in order to prevent failure or address system problems
  • Must participate in data modeling and extraction strategies, development, implementation, maintenance
  • Must be able to meet deadlines
  • A minimum of 5 years of data warehouse 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.
  • 5 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.

 

 

Job Responsibilities:

  • 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.
  • Consolidate and optimize data warehouse infrastructure
  • Conceive analytics and business intelligence platform architecture for  business units and third-party clients
  • Design and implement ETL procedures for intake of data from both internal and external sources, ensure data is verified and quality is checked
  • Design and implement ETL processes and data architecture to ensure proper functioning of analytics, as well as third-party reporting environments and dashboards
  • Collaborate with the business units and information technology team in ensuring data warehouse architecture development and utilization
  • Carry out monitoring, tuning, and database performance analysis
  • Perform the design and extension of data marts, meta data, and data models
  • Ensure all data warehouse architecture codes are maintained in a version control system
  • Perform other duties as assigned.
  • Translate business requirements into new and established data models, develop ETL's, build cubes, and validate results with the business units
  • Support implemented BI solutions by monitoring and tuning queries and data loads, addressing data integrity issues, monitoring performance and communicating functional and technical issues.
  • Establish and maintain storage vehicles for external and internal information
  • Provide support to business requirements in the application and consumption of information from the enterprise data warehouse or from other suitable source systems.
  • As part of the information technology team, review, analyze, modify, create ETL's, testing, debugging, integration and implementation processes.
  • Document technical needs for ETL processes and databases
  • Ensure optimal technical infrastructure is utilized
  • Deliver data integration projects leveraging best practice expertise and experience at implementation and know-how
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

NetSuite Administrator

Markham
Job Order: MG-6944
DUTIES AND RESPONSIBILITIES:   NetSuite Development Leverage existing NetSuite experience to help setup and improve NetSuite processes, including workflow design and process mapping Automate workflow processing, through use of NS workflows and scripts Maintain and improve existing SiteBuilder websites, integrating new functionality as required Complete and maintain website-specific...
DATE POSTED 2017-06-06

Full Stack Developer

Markham
Job Order: MG-6830
This crucial hands-on role is responsible for engineering & building complex Internet-exposed, security- focused, Cloud-based SaaS solutions with AngularJS front-end and .NET back-end technologies targeting modern browsers on desktop and mobile devices. Your passion for modern .NET-based web development is equally matched by high degree of skill acquired through substantial experience & expertise in...
DATE POSTED 2017-08-04

CoE Application Manager

Montreal
Job Order: MM-6945
Your challenges: Our client is looking for an experienced CoE Applications Manager that will manage SAP Operations within the Center of Excellence (CoE). The CoE Applications Manager is responsible to plan, coordinate and manage the tasks of the Operations team to ensure the live SAP solution functions as designed and continuously evolves to meet business needs.    Your main challenges will...
DATE POSTED 2017-08-10
Warning

Please, enter a valid value

Thank you.

Your password successfully changed.