Asset Information Services – Senior Data & Analytics Engineer
- Pay Rate: $68.83 hour, depending on experience
- Contract Length: 4 Months
- Location: Burnaby, British Columbia
Raise is currently hiring an Asset Information Services – Senior Data & Analytics Engineer on behalf of our client. They’re expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader. Our Client, is one of the largest electrical energy suppliers in Canada
Note: The primary pay rate is based on T4 classification; however, we will also consider applications from candidates interested in an INC classification, where applicable.
Description
The Senior Data & Analytics Engineer will play a critical role within the Asset Information Services (AIS) Analytics and Reporting team. This position is responsible for the design, development, and optimization of complex data architectures that support ’s asset performance and compliance reporting. You will lead the integration of disparate data sources into stable Oracle environments, ensuring high data integrity and providing the technical foundation for organizational decision-making.
Responsibilities
- Data Engineering & ETL: Design, build, and optimize robust ETL pipelines from multiple source systems into Oracle databases. Perform complex data transformations to support quality assurance and asset inspection processes.
- Technical Leadership: Act as a lead consultant, providing development oversight for Oracle database systems. Review functional specifications and present technical designs to development leads to ensure alignment with ’s architectural standards.
- System Maintenance & Optimization: Develop, test, and maintain SQL, PowerShell, and VBA/VBScript solutions. Resolve usage issues, perform system integration activities, and execute batch processing to ensure 24/7 operational effectiveness.
- Database Administration: Provide local DBA support, including managing access controls, user privileges, and ensuring the security of asset data.
- Stakeholder Engagement: Lead requirements gathering sessions with business units, translate needs into conceptual design models, and facilitate User Acceptance Testing (UAT).
- Documentation & Knowledge Transfer: Create detailed process flows, job aids, and standard operating procedures (SOPs) to build long-term capability and capacity within the organization.
Qualifications
- 9 years of consulting experience in reporting and analytics (or equivalent).
- 5 years (minimum 3 years with proven practice) of hands-on development in Oracle SQL, Oracle PL/SQL, and PowerShell.
- Technical Skills
- Database Expert: Advanced proficiency in Oracle SQL and PL/SQL; experience with performance tuning and designing stable, integrated data architectures.
- Scripting & Automation: Strong PowerShell skills for process automation; additional experience in VBA/VBScript for legacy system support.
- ETL/Data Modeling: Expert skills in data models and the construction of information architectures that enable integrated reporting.
- Tooling: Familiarity with Web Intelligence, Dashboarding tools, and Analysis frameworks.
- Problem Solving: A proactive approach to sourcing technical solutions (searching/integrating) rather than simple copy-pasting.
- Professional Competencies
- Analytical Thinking: Ability to translate complex business requirements into feasible technical options.
- Change Management: Advanced knowledge of organizational change management procedures and policies.
- Communication: Excellent written and verbal communication skills, capable of providing guidance to technical teams and status updates to leadership.
- Education and Certifications
- Bachelor’s degree or Technical Diploma in Computer Science, Engineering, or a related field.
- Nice to have Certifications (Oracle Database SQL Certified Associate, Oracle PL/SQL Developer Certified Professional, Microsoft Certified: Power Platform Functional Consultant Associate, ITIL 4 Foundation Ect)
Additional Information
- Candidates in this role will be working a a Hybrid Schedule (Monday and Tuesday in office days and Wed-Friday remote)
- Every contractor must supply their own Windows 11 Laptop computer for the duration of the assignment.
- Every contractor must supply their own “Smart Phone”. This is needed to gain access to the Organizations network.
Looking for meaningful work? We can help!
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: https://raise.jobs/accommodations/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or any other Raise job posting (or have any other questions), please contact us at +1 800-567-9675 or hello@raiserecruiting.com.
#WES
#LI-SC1