Warehousing and Analytics Developer (Oracle PL / SQL

United Software Group Inc.; Vancouver; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading technology firm in Vancouver is seeking a Warehousing and Analytics Developer to oversee multiple development projects. This role demands expertise in both front-end and back-end solutions, and team leadership skills are essential. The ideal candidate will possess a strong background in computer science and proven experience in systems development, ensuring high-quality deliverables that meet client objectives.

Qualifications

• Minimum 5 years as Full Stack Developer or related role.
• Experience with API integration and agile methodologies required.
• Master’s degree preferred, or equivalent experience.

Responsibilities

• Manage systems development projects, defining objectives and priorities.
• Lead a team, ensuring client requirements are met through project lifecycle.
• Develop front-end and back-end solutions using modern design processes.

Skills

API development

Frontend and backend development

Analytical skills

Problem-solving skills

Agile software development

Education

Master’s degree in computer science

Bachelor’s degree in computer science

Diploma in computer science

Certificate in computer science

Tools

HTML

CSS

JavaScript libraries

Git

Relational databases

Non-relational databases

Job description

Job Title: Warehousing and Analytics Developer (Oracle PL/SQL, Power BI, DW, ETL)

Location: Vancouver, CA (Hybrid Onsite)

6+ Months Contract

Position Summary:

• Plans and manages multiple, simultaneous systems development projects, including defining objectives, priorities, timelines, and resource requirements.
• Leads a team of professionals, defining work assignments, and verifying and reviewing code produced by others.
• Provides advice to executive and senior management on alternatives and solutions, product evaluation, risk assessment and cost benefit analysis of existing and future applications.
• Determines the most appropriate development tools and database configurations for applications, coordinating required product upgrades and enhancements.
• Manages multi-year mission-critical database development projects, and designs and implements data warehouse architecture, and strategies and methods for complex data models.
• Advises executive on business or organizational issues and collaboratively establishes strategic plans and budgets that involve development of new systems that will affect other ministries and external organizations.
• Conducts high-level analysis of possible program/systems solutions including developing new concepts, identifying impacts and internal and external linkages, and consulting with internal and external systems professionals.
• Ensures client requirements and priorities are understood and met throughout the life cycle of the development project.
• Determines need for contract resources, develops contract specifications, and estimates costs.
• Develops front-end (user interface) and back-end (database) enterprise solutions on a variety of platforms using mobile-first and test-driven design processes.
• Conducts analysis, design, and implementation of applications to meet user requirements and design specifications.
• Interprets client requirements and underlying infrastructure applications, systems, and processes, and prepares a system design plan.
• Implements repeatable automated processes for building applications, testing, documenting, and deploying at scale.
• Collaborates with other teams in and across the organizational agile environment to accomplish goals.
• Communicates technical concepts to a non-technical audience to gain consensus on changes to requirements and specifications.
• Functions as subject matter expert on working groups and committees.
• Other duties as assigned.

Required Experience:

• Minimum 5 years’ experience as either a Full Stack Developer, Software Engineer, in Automation, or Conformance Testing.
• 3 years’ experience using a variety of modern development tools, such as HTML, CSS and JavaScript libraries, relational and non-relational databases.
• 3 years’ experience with API development and integration and continuous development environments.
• Knowledge in frontend and backend development.
• Knowledge of version control technologies such as subversion and Git and development in an open- source environment.
• Knowledge of relational and non-relational databases.
• Knowledge of agile software development methodologies.
• Analytical, interpretative, and problem-solving skills.

Education:

• Master’s degree in a computer science or related field and 3 years of related experience; OR
• Bachelor’s degree in a computer science or related field and 4 years of related experience; OR
• Diploma in a computer science or related field and 5 years related experience; OR
• Certificate or coursework in a computer science or related field and 6 years related experience; OR
• An equivalent combination of education and experience may be considered.