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

Functional SAP Consultant - Sales & Distribution and Logistics Execution

Montreal
Job Order: BJ-6931
Job Description Collaborate with key business resources, in providing SAP ECC SD (Sales & Distribution) and LE (Logistics Execution) module. Detect the problems and find solutions with the developers, business analysts and other functional analysts on projects/support, and also to offer the requested support to users. Find and configure solutions where applicable Create the tests scenarios...
DATE POSTED 2017-04-24

Software Developer

Toronto
Job Order: SE-6934
Job Description:  Designs and develops new software and modifies and enhances existing software for clients’ systems, and for our client’s base software. Communicates directly with our 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...
DATE POSTED 2017-06-23

Functional SAP Consultant - Finance and Product Costing

Montreal
Job Order: BJ-6932
Job Description: Find and configure solutions where applicable Create the tests scenarios and execute appropriate test cases, ensuring the integrity of the solution prior to business unit and user acceptance testing Support, maintain and enhance existing SAP solutions Collaborate with appropriate business units, production support team members, and developers on requirements gathering, solution...
DATE POSTED 2017-04-25

Functional SAP HCM HR/Payroll Resource

Montreal
Job Order: BJ-6933
Job Description: Find and configure solutions where applicable Create the tests scenarios and execute appropriate test cases, ensuring the integrity of the solution prior to business unit and user acceptance testing Support, maintain and enhance existing SAP solutions Collaborate with appropriate business units, production support team members, and developers on requirements gathering, solution...
DATE POSTED 2017-04-25

Sr. Web Developer

Toronto
Job Order: MG-6935
Job Responsibilities: Develop and refine site features in Python, Django, React, Angular, and other modern languages and frameworks Integrate 3rd party APIs in a fail-safe manner Maintain and continuously improve reliability and efficiency of code Implement new features that help grow the company website Conduct research and technical feasibility reports relating to potential new features ...
DATE POSTED 2017-05-15
Warning

Please, enter a valid value

Thank you.

Your password successfully changed.