Data Warehouse- Tech Specialist

Toronto, ON, CA

Data Warehouse- Tech Specialist - (CREQ125382)


Location: Canada

Specific Responsibilities
Identifies and documents the business partners functional and data requirements based on a business process description to ensure that the final deliverable coincides with the context of the business operations
Manages and documents the translation of business needs into requirements to communicate to the project team activities, resources, and deliverables necessary to meet business objectives
Participates in investigations, interviews, and formal or informal requirements gathering sessions to understand stakeholder needs
Recognizes discrepancies between business needs and deliverables, when reviewing and validating requirements, and communicates these discrepancies to stakeholders to ensure that they understand and either accept these discrepancies or identify a need to change project direction
Analyses technical problems for senior management development teams, and business partners in order to identify the technical approach and solution options for the given problem; this includes collaborating with project teams to resolve technical road blocks, performing solution proof of concept POC, and examining third party product offerings
Provides application design and development costing estimates to senior management that are used in determining business initiative feasibility and priorities, and or used by the banks IT Project Managers for project planning
Reviews project documents e. g. , High Level Requirements Document HLRD, High Level System Design Documents HLSD, and application code received from other Technical Specialists, Business Technical Specialists, and Project Managers to ensure quality, completeness, and adherence to Capability Maturity Model Integration CMMI documentation standards, as well as identifies synergies between project initiatives in order ensure the efficiency and effectiveness of the development process
Provides technical and application expertise to senior management and project teams, including the areas of governance methodologies and processes, for purposes of ensuring the architecture and applications are consistent with the design framework, Enterprise industry standards, and the BMO strategic direction
Provides technical coaching to team members on design patterns, development processes, and application functions in order to improve their technical skills
Manages operational aspects of governance forums to ensure meeting productivity
The Technical Specialist I is a technical subject matter expert for one or more applications or platforms. The Technical Specialist I is accountable for providing technical guidance and specialized support for development and implementation of applications.
Knowledge Skills
Must possess a university degree college diploma
Must have with proven experience building data warehouse environments from conception to production full project lifecycle in Waterfall approach Agile approach
Strong experience with business system analysis in a complex data warehousing environment running on UNIX platform.
Strong experience gathering business requirements from client groups and lines of business and converting these into functional specification documents deep documentation experience is required
Proficient using SQL statements to query data
Ability to read a data model perform data mapping

Primary Location

: CA-ON-Toronto


: Full Time

Job Type

: Experienced


: No

Job Posting

: 19/03/2022, 8:43:13 AM

Apply Now Back to Results