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 . We would like to hear from you!
About British Columbia Investment Management Corporation
Revenue: Unknown / Non-Applicable
Size: Unknown
Type: Company - Private
Website: www.bci.ca
British Columbia Investment Management Corporation
www.bci.ca
Victoria, Canada
Unknown / Non-Applicable
Unknown
Company - Private
