Data Warehouse- Tech Specialist

Virtusa; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A technology consultancy firm is seeking a Data Warehouse- Tech Specialist to identify business requirements and provide technical guidance. You will manage the translation of business needs into deliverables, analyze technical problems, and contribute to developing data warehouses. Ideal candidates should possess a degree, proven experience in the full project lifecycle in both Waterfall and Agile approaches, and strong SQL skills. Join a dynamic team in Toronto, Ontario, and take your career to the next level.

Qualifications

• Proven experience in full project lifecycle for data warehouse environments.
• Strong experience in a complex data warehousing environment on UNIX platform.
• Deep documentation experience converting business requirements into functional specifications.

Responsibilities

• Identify and document business and data requirements.
• Manage translation of business needs into requirements.
• Participate in requirements gathering sessions.
• Analyze technical problems and collaborate with teams.
• Provide design and development costing estimates to management.
• Review project documents for quality and completeness.
• Provide expertise on governance methodologies and processes.

Skills

Building data warehouse environments

Business system analysis

SQL proficiency

Data model reading and mapping

Education

University degree or college diploma

Job description

Job Description

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.