MaxSys is a professional staffing and solutions firm, offering the best in innovative and creative professional service needs.

Job Search

Development Lead (Data & Reporting) (39583

Information Technology - Toronto

Must provide own laptop and cell phone.
Resource Profile:
The Technical Development Lead is responsible for leading the development and technical implementation of a new or revised data warehouse and business intelligence solution as part client’s Program.
Knowledge & Skills:
The Development Lead is responsible for the successful development and implementation of data and reporting solutions as well as contributing to the strategy, architecture design, standards, and guidelines as prescribed by WSIB. The successful candidate will provide hand-on expertise and direction in the ETL development, testing, classification of information, taxonomies, data architectures, data models, tools, and applications used to design data-centric solutions. The required skillset is required immediately.
• Knowledge and hands-on experience with industry best practices for data warehousing modeling, data integration and testing
• Mastery of knowledge of data quality, master data management, and data integration including exception handling and cleansing
• Working knowledge and demonstrated experience with enterprise solution architecture and implementation methodology best practices
• Demonstrated leadership skills and experience to supervise and direct multi-disciplinary “on-shore” and “offshore” project teams
• Exemplary communication skills; Ability to liaise between the business and information technology clients within the organization, frame complex technical concepts in simple business terms, and defend ideas appropriately
• Hands on experience with SAS programming, JCL, PL SQL, and ETL data warehousing concepts.
• Knowledge of IBM Enterprise DataStage (ETL developer tool, minimum version 8.5) and thorough knowledge of its stages, routines and utilities with ability to develop robust and re-usable ETL jobs and routines with scalability.
• Expertise with ETL methodologies and job design with a sound knowledge and experience of integrating input/jobs from disparate systems and be able to maintain the Boards standard of ETL best practices.
• Technology mastery: IBM mainframe(TSOD), IBM Datastage, Cognos
• Technical skillsets to include: optimization of complex SQL scripts, develop complex procedures using IBM DataStage, as well as, knowledge of similarities and differences between Oracle SQL engine and MS SQL Server T-SQL engine
• Deep dive modeling skills spanning both application and data warehousing
• Mastery of data integration processing and toolsets
• Experience with data warehouse and business intelligence solution delivery including advanced analytics, performance management / dashboards, formatted reporting, and ad-hoc analysis and the related toolsets
• Tangible examples of large program development of an enterprise-wide data warehouse solution including technical design, development, delivery and operations support.
• Superior relationship management and teamwork skills to engage, motivate and work with multi-disciplinary teams and project stakeholders

• Leads the development and technical implementation of new or revised data warehouse and business intelligence reporting solutions
• Supports ETL environments by monitoring their performance to ensure functionality, integrity and security of the environments and compliance with WSIB information security and change management processes. Identify and troubleshoot problems as they arise which may involve interacting with other areas within WSIB and external vendors for resolution.
• Design and build data model for Enterprise ODS, New Enterprise Data Warehouse, and IM Catalogue components based on user requirements and applying appropriate system development methodology. This includes identifying user requirements, analyzing data systems, designing/creating ETL, developing test criteria, testing programs, and reviewing test results; maintaining metadata consistency, implementing the programs into production, providing installation support (on-site/on call as required) and preparing/maintaining appropriate documentation.
• Provide technical assistance, advice and guidance to Business Technology Services (BTS) staff and WSIB business users in response to enquiries on the functionality of BI/ETL tools, and data in EIW and related datamarts to ensure efficient and un-interrupted IM services to the business users.
• Author detailed technical design documents, options and supporting documentation
• Serve as a data warehouse and business intelligence subject matter expert that executes on  design and delivery of solution(s)
• Supporting project managers and business analysts in preparing high level resource requirements and timelines estimates, identifying functional work areas and continually helping to remove technical hurdles;
• Understand how data modeling and code design impacts data loading and reporting performance
• Provide quality assurance testing assistance and guidance to ensure viability and accuracy of the test strategy
• Ensures standards, guidelines, and best practices for governance and development are met by the project teams.
• Testing strategies for data-centric or business intelligence projects
• BS or MS in Computer Science, Computer Engineering, Electrical Engineering, or related field
• Hands-on experience in designing and leading enterprise-level data strategies and data management transformations – with emphasis on Master Data Management, Governance / Data Quality and Data Integrity approaches, Data Access and Privacy Principles
• Experience working in Public sector organizations, working on large and complex IT projects such as Guidewire Claim Center, Policy Center, and Billing Center experience preferred

Rate is up to a maximum of $72 / hour depending on experience.



Position Type


Application Deadline

June 15, 2014

Experience Required

10+ years

Job Duration

1 year

Education Required

College Diploma

Our Services

  • Analytics


    MaxSys is committed to providing the quality, experience and resources you've come to expect from an ISO certified company.

  • The Team

    Professional Consulting

    With MaxSys, you gain the benefit of our commitment to: quality, flexibility, experience and cost effective business practices.

  • The Team

    IT Consulting

    Since 1990 MaxSys has been the innovative leader in staffing solutions, outsourcing and consulting services for Canada’s technology sector.

  • Our Services

    Permanent Placement

    The experienced recruiters at MaxSys work with our clients to effectively find the top talent for all your permanent placements.

Client Testimonials

No words can express my appreciation for the time and effort Jude invested in me. I would like to thank MaxSys for helping me obtain a great opportunity in the Travel Industry. Your support and coaching were key to my success! Thank you very much for everything!

Nathalia Gauto

Thank you Amanda for considering me for this position, I hope it works out for me.  I know it is different for me but today you have to go with the job market and expand your resources.  Work out side of the box!  I’ll let you know how I make out!  Really happy to be employed by MaxSys best Agency I have worked for!


It is imperative I work with a company who can provide me with the service and the level of staffing I require. I also need to be able to contact their senior staff day or night. No matter what time I call there is always someone at the other end of the line. I have absolutely no reservations about providing a recommendation for MaxSys Atlantic. They have become my one stop shop for temporary labor.

Gary Brimble, Building Services Supervisor, Trade Centre Limited

MaxSys Atlantic contributes to our bottom line by constantly handling all different jobs and duties with the utmost enthusiasm and consistency. The management is highly motivated and has excellent communication skills with their clients and their own staff. MaxSys Atlantic is a valuable resource to have, if we require urgent help they are always there for us. If their performance with our company is any indication of how well they should perform in yours MaxSys Atlantic would be a positive asset to any corporation.

Greg MacVicar, Operations Manager

MaxSys has a proven track record of providing reliable service and meeting client needs both broad and specific. Your greatest value added is a large roster of available resources and an excellent knowledge of both the private and public sector markets, and the variety of government contracting mechanisms that are applicable to our requirements.

Jack Pagotto, Head/ESEC* S&T, Centre for Security Sciences

No matter what the need and no matter what time of day or night, and no matter how short of notice it is, MaxSys is right there to find solutions for us. You just don’t find that elsewhere these days. We both work in industries where all too often it is thankless where only the things that don’t go right stand out. However, I would like to sincerely thank Chris and his team for all the hard work and dedication that they bring to ensuring our needs are met.

James W. Horsman, Sameday Worldwide

MaxSys has become our “Go-To” recruitment agency for hiring temporary and permanent placements. I am impressed with the professionalism of the consultants, prompt response time and the caliber of the candidates.

Brenda Baird, Human Resources, Cantwell Cullen & Company Inc.

We’ve been working with MaxSys for over a year now and the level of great service has not waivered, it’s a pleasure to work with consultants who understand our hiring needs.  Thank you for all of your help!

Melanie LeeLook, CHRP, Human Resources, Goway Travel Ltd.