ETL/ Data Warehouse/ Report Senior Designer/ Developer

ETL/ Data Warehouse/ Report Senior Designer/ Developer

Location Ottawa, ON
Start Date November 15, 2018
Security Clearance Reliability Status
Duration 3+ months
Date Posted October 9, 2018
Job ID 11258

Maplesoft Group is currently seeking an ETL/Data Warehouse/Report Senior Designer/Developer to join one of our clients located in Ottawa.

Our client has a need for an experienced ETL/Data Warehouse/Report Senior Designer/Developer. Working closely with other team members including solution architects, data architects, data modelers, and business analysts, the Resource will be responsible to
perform in-depth analysis to support, enhance, and build the Extract, Transform, and Load (ETL) functionality and to design and develop business reports for the Auction solution as part of the Auction Modernization Initiative (AMI) program. The Resource may be required to work during nonstandard hours and this will require an estimated five (5) days of onsite effort weekly throughout the duration of the engagement.

Tasks include but are not limited to the following:

• Support the design, development, testing, deployment of the data interfaces between various internal application components
• Work alongside other initiatives to finalize the design, development, and implementation of the required data warehouse, ETL, and analytical and reporting processes and tools for the FMBO portfolio
• Design, develop, and implement the required analytical and reporting functionality (canned, on-demand, and ad-hoc reports) for the AMI program
• Collaborate as part of an Agile team
• Participate in peer-reviews of solution designs and related code.
• Ensure that changes are validated, tracked and released in a controlled manner
• Prioritize and complete projects/tasks to meet deadlines
• Respond to trouble tickets provided by service clients, including triage and resolution of technical and application problems.
• Monitor solution performance for potential bottlenecks and work collaboratively with the team to identify potential solutions
• Participate in all phases of the software development methodology cycle to support the portfolio information technology (IT) solutions
• Support the quality assurance and user acceptance testing
• Develop and maintain collaborative relationships with internal and external counterparts (partners, clients and suppliers) to support operational objectives
• Support the performance of functional and basic technical analysis, including root-cause and handle the communication with the users
• Help create working procedures and documentation on solutions and populate knowledge databases, testing plans, and results


•University degree or College diploma in computer science, engineering or business administration
• A minimum of three (3) years experience as ETL/ Data Warehouse/Report Developer
• A minimum of three (3) years of project-delivery experience in a large financial services or technology environment

Other Requirements
• Demonstrated understanding of the fundamentals of computer systems
• Demonstrated strong communication skills, both oral and written, must be able to communicate technical details clearly to multiple levels of the organization
• Demonstrated strong knowledge of principles and best practices in data warehouse design and development and reporting and analytics design patterns and frameworks
• Demonstrated knowledge of IBM DataStage/QualityStage
• Demonstrated Knowledge and understanding of BI Reporting, Analytics and Visualization Tools (i.e. Cognos, Qlik)
• Operational knowledge of ITSM Principles, Lean, Agile and Design Thinking
• Experience with a versioning control system (e.g., Apache Subversion (SVN), Concurrent Versions Systems (CVS or Rational ClearCase)
• Ability to meet Reliability Clearance requirements
• English essential, French will be considered an asset
Maplesoft Group prides itself on its distinct corporate culture and recognizes that success is a direct reflection of our most valuable asset - our people.  Therefore, attitude and ambition are key personality traits we seek out, along with skill and aptitude, in potential employees.

We thank you for your interest in Maplesoft Group and wish to advise that only candidates under consideration will be contacted.

Contact Recruiter: