Data Analytics Engineer

Salary Range: $91,295.85 to $104,132.83 per annum (salary includes a 9.9% temporary market adjustment)

Why choose us?

There is more to Pension Corporation than you might think. We are an award-winning organization with meaningful purpose-driven work, where staff have impact and create peace of mind for those we serve. We have cultivated an outstanding community rooted in respect, where employees are inspired to have courage, take action, and be at their best every day.

Our nine-year strategic plan, Plan 20|30: Our Future is Insight, will guide us from 2021 to 2030. To learn about our aspirations and objectives and how you can be a part of a people-focused organization that is grounded in operational excellence, visit bcpensioncorp.ca.

What we offer:

• Flexible work options (modified workweek, on-campus work, or a hybrid of home/on-campus)
• Comprehensive extended health and dental benefits for you and your family
• Defined benefit pension program
• Health & wellness programs - lunchtime seminars, community activities and a comprehensive Employee & Family Assistance Program
• Incredible campus with collaboration spaces, sit/stand desks, and lots of natural light
• Ongoing training, professional development opportunities, and scholarship programs
• Opportunities to give back to the community and support not-for-profits
• Seasonal events and socials
• A robust awards/recognition program
• Discounts on BC Transit passes, travel and accommodation, cell phones and plans, and more

Hybrid Work Model

This position is located in our Victoria, BC office. You will have the opportunity to work part of the time on-campus and part of the time off-campus. Guidelines and requirements for in-office presence are determined by operational need and vary according to the unique needs of each business area.

We are seeking a Data Analytics Engineer to join our team in VICTORIA, British Columbia, Canada.

The Data Analytics Engineer reports to the Assistant Director, (AD) Solution Engineering within the Information Technology Services branch. Working with both internal and external providers, this position provides technical guidance, consultation, development and implementation to enable data analytics and insights across the enterprise. This position will develop and implement governance, standards and practices for the technology supporting analytics in the corporation. This position will also provide hands-on support to deliver the required data to the analytics team while remaining compliant to the corporation's responsibility to protect personal information. This position has broad technical expertise across multiple technology stacks related to data acquisition and transformation.

Must have

• Bachelor’s Degree in Software or Computer Engineering or related field required. An equivalent combination of education, training and experience may be considered.
• Demonstrated recent experience that includes: Data warehousing, database creation and on-going maintenance, and establishing Exchange-Transfer-Loads (ETLs) between data sources.
• Systems design, architecting and defining and implementing data strategy.
• Developing data models, data marts, and writing queries in an enterprise data warehouse environment including MS SQL Server and Oracle.
• Experience utilizing Microsoft Power BI.
• Experience in designing, developing, and managing data integration solutions using Azure Data Factory (ADF).
• Architecting, developing, and/or maintaining technical solutions in virtualized environments.
• Determining appropriate use of various problem structuring methods and statistical methods for sampling, distribution assessment, bias and error.
• Using programming languages, such as Python, Visual Studio (C#) for data transformation and automation tasks.
• Data validation, cleansing and normalization of structured dataset, performing data lineage and aggregation, data replication, and data manipulation.
• Leveraging large structured and unstructured data sources.
• SQL server tools such as SSRS and SSIS.
• Proficiency in using GitHub for version control, collaboration, and code management.

Nice to have

• Experience with data governance principles and practices, including data quality, metadata management, and data security.
• Experience with cloud-based data solutions, particularly Azure SQL Database and Oracle Cloud Infrastructure (OCI).

To learn more about the Delivery Lead position and to apply, please visit our website: Data Analytics Engineer - BC Pensions Career Site Careers

We thank you for your interest in working with us. You will be informed of your status in this competition as soon as possible.