data engineer Victoria

British Columbia Investment Management Corporation

Full Time Victoria 94454 - 58531 CAD ANNUAL Today

Job description

Closing Date: June 22, 2023

Are you someone who believes that better data equals better outcomes and are currently seeking your next rewarding opportunity with an organization that uses data to drive change and transformation? BCI is looking for a new Data Engineer to join our newly formed and growing Corporate Data & Operations department for a 12-month, fixed term role. This is an exciting time to be a part of a centralized team delivering data engineering, advanced analytics, data science, and data governance. Come join us in either our Victoria or Vancouver office!

Reporting to the Manager, Data & Analytics Engineering, the Data Engineer is responsible for the design, development and implementation of data pipelines, datasets, analytics data stores, and analytics data platforms. The Data Engineer drives data modernization and innovation and contributes to a strong data foundation for BCI.

The Data Engineer works closely with internal team members, such as the Data Product Manager, Data Governance Lead, BI Engineers, and Data Scientists, and collaborates with the business and technology teams.

This position can be based in either Vancouver or Victoria and has the flexibility to work from home the majority of the time if desired.

WHAT YOU BRING

Bachelor’s degree in Data, Science, Technology, Engineering, Mathematics, or a related field
A minimum of 3 years of experience as a Data Engineer or Analytics Engineer
Experience with data warehouse, data lake, and data lakehouse design, development and sustainment
Coding skills and deep proficiency with SQL and Python
Competent with general scripting and software development best practices
Understanding of data processing performance concerns and issues (configuring database server/data schema for performance, optimizing SQL)
Experience with reporting tools (e.g. Excel, Power BI, Tableau)
Experience with version control systems (e.g. Git)
Experience with cloud platforms
Strong knowledge of data modeling, data architecture and data structures
Strong understanding of Agile and DevOps, including CI/CD technologies and practices
Must have excellent listening, communication, collaboration and problem-solving skills
Knowledge of the investment management industry is an asset

WHAT YOU WILL DO

Designs, develops, implements, and supports data integration pipelines to bring data into analytics data stores
Designs, develops, implements, and supports reusable curated datasets suitable for human and machine analytical use-cases
Configures analytics data stores to ensure high performance and positive data user experience
Configures and supports analytics data platforms and ensures platforms are designed to support security, privacy, audit, and data governance requirements
Collaborates with team members, other IT teams, and customers to understand the organization’s business objectives, data and data platform needs
Provides technical leadership and creates a culture of customer-centricity, accountability and high performance
Proactively identifies risks and issues and proposes solutions to remove barriers
Applies knowledge of DevOps practices including continuous deployment, continuous integration, test-driven development and automated testing
Mentors junior engineers, follows best practices, performs code reviews and architects resilient infrastructure
Solves challenging problems about scale, statistics, infrastructure reliability, latency and more
Leads data mining and collections procedures
Sources, structures, profiles, validates and transforms data for reporting, analysis and data science purposes
Engages with stakeholders to define, design and deliver data sourcing, analysis and reporting solutions
Makes recommendations about the methods used to collect, analyse and manage structured and unstructured data to drive outcomes
Develops solutions (and code) to automate and productionize data sourcing, data structuring and analytical modelling
Analyzes data sources, evaluating and remediating data quality, designing and implementing data sets that can be consumed and re-used by the analytics community across BCI
Proactively identifies opportunities to utilize data and analytics to business advantage and prototyping for ‘proof of value’
Assists in troubleshooting and guiding resolution of data analytics related problems in a timely and accurate fashion
Undertakes special projects or assignments as required
Performs other related duties as required

WHY APPLY TO JOIN BCI:

With our values as our anchor, it’s our people that help shape employee-focused initiatives and who create the environment we work in each day – all of which further strengthens our culture. BCI has been recognized as one of Canada’s Top 100 Employers – for the fourth consecutive year – and has built programs and benefits to support all our employees, including:

Extended health and dental coverage starting on your first day of work. We have you covered!
Eligibility for the defined benefit BC Public Service Pension Plan, providing you with a secure retirement income.
Time off includes: 20 days' vacation, 6 paid sick days, 6 paid personal days, and 2 paid days for volunteering – to support physical, mental, and community health.
A hybrid schedule offering you the flexibility to work from home up to two days a week and fully remote for some technology roles.
Annual wellness allowance to support an active lifestyle well as physical well-being when working at home.
Ongoing learning through our in-house mentoring program, professional dues support, tuition reimbursement, and online and in-house learning.
As a pilot program in 2023, we are offering the opportunity to work from anywhere in the world for up to 1 month.
Our telehealth provider Dialogue connects you and your family to virtual healthcare appointments.
Relocation support is available if a move to one of BCI’s locations is required.
Invested in your Learning: BCI investment professionals lead a monthly Investment Club to share industry knowledge with employees who work in other departments.

TO APPLY:

Apply online with a copy of your resume. We encourage timely submissions of applications as candidates will be actively reviewed and the interview process may advance earlier.

At BCI, we value diversity and believe in fostering an inclusive culture where all employees can be successful. We are performance and client focused and value integrity; if you share these values, we want to know you. We recognize that some skills can be learned on the job and encourage all to apply.

If you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations), contact us at

[email protected]

. We would like to hear from you!