Data Warehouse- Tech Specialist

Job Description - Data Warehouse
- Tech Specialist (CREQ
125382)

Location:

Canada

• 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

• 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