Full Stack Data Engineer

Closing Date: September 24, 2024

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 an experienced Full Stack Data Engineer to join our growing team.  This is an exciting time to be a part of a centralized team delivering data engineering, analytics, data science, and data governance. Come join us in our beautiful downtown Vancouver office.

WHO YOU WILL WORK WITH

The Corporate Data & Operations department is a central hub that delivers essential business services across all departments within BCI. The department is comprised of three branches: Data & Analytics, Workplace Services, and Business Planning. The department facilitates BCI’s corporate strategy and plays an integral role in its execution by ensuring staff have high-quality data, advanced analytics for decision-making, and well-appointed global offices for collaboration. The department is a critical part of how BCI delivers long-term value for our clients.

THE OPPORTUNITY

Reporting to the Manager, Data & Analytics Engineering, the Full Stack Data Engineer is responsible for the design, development, and implementation of the end-to-end full stack of data and analytics, including data engineering, analytics/dataset engineering, BI engineering, data science and machine learning engineering, and data platform engineering. The Full Stack Data Engineer drives data modernization, analytics solutions, machine learning models, and innovation for BCI.

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

This position is based in Vancouver and has three career progression levels.

WHAT YOU BRING

• Bachelor’s or Master’s degree in Big Data/Data Science, Science, Technology, Engineering, Mathematics, or a related field

• A minimum of 5 years of experience as a Data Engineer, Analytics Engineer, Data Scientist, BI Engineer, or Analytics Full Stack Engineer

• Experience gathering business requirements, conducting business analysis, and solution design for end-to-end data solutions (e.g. data ingestion, reusable datasets, analytics solutions, ML models)

• Experience with cloud-based data warehouse, data lake, and data lakehouse design, development and sustainment

• Coding skills and deep proficiency with SQL

• Experience in database management and data processing performance optimization

• Experience in data modeling (e.g. star, snowflake, denormalized designs), data architecture and data structures

• Must be proficient with wireframing, designing complex data visualization solutions, whilst taking into account solution user experience, and developing analytics solutions using modern data visualizaiton tools (e.g. Power BI, Tableau)

• Experience developing low-code/no-code applications and workflows (e.g. PowerApps, Power Automate)

• Experience administering and configuring cloud and on-premise data and analytics platforms

• Experience with scripting, version control systems (e.g. Git), cloud platforms, Agile and DevOps, including CI/CD technologies and practices

• Must have excellent listening, communication, collaboration and problem-solving skills

• Must have skills of the Azure cloud fundamentals, M365, and Azure data analytics and Power Platform stack is an asset (e.g. Azure Data Factory, Azure Data Lake Store, Azure SQL MI/DB, Azure Synapse, Power BI/Power Apps/Power Automate, Azure ML, Azure Databricks, Microsoft Fabric)

• Knowledge or experience in master data management is an asset.

• Knowledge of the data opportunities within the investment management industry is an asset

WHAT YOU GET TO DO

• Collaborates with team members, other IT teams, and customers to understand the organization’s business objectives, data and data platform, data science, and analytics solution needs

• Engages with stakeholders to understand business problems and opportunities that can be supported through data by conducting requirements gathering and analysis

• Applies knowledge of DevOps, DataOps, and MLOps practices including continuous deployment, continuous integration, test-driven development and automated testing

• Designs, develops, implements, and supports scalable and production grade data integration, data transformation, and machine learning model production pipelines

• Uses statistical and mathematical techniques to undertake analysis and build machine learning models including forecasting, segmentation, predictive modelling, deep learning, natural language processing, other machine learning areas

• Communicates data science complexities in plain language to technical and non-technical audiences and develops reports and presentations

• Designs and develops business intelligence solutions (e.g. reports and dashboards) which solve business problems, with a focus on user experience and design

• Conducts quality assurance testing, to ensure solutions built are accurate, high functioning, performant, and meet client requirements

• Provides training and support to end-users of business intelligence software and solutions

• Configures and supports analytics data platforms and ensures platforms high performance and designed to support security, privacy, audit, data governance requirements

• Manages data & analytics platforms by performing upgrades, feature reviews and implementations, change management control, cost control, environment management, inventory management, platform roadmap, and disaster recovery planning

• 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

• Mentors junior engineers, follows best practices, performs code reviews and architects resilient infrastructure

• Solves challenging problems about scale, statistics, infrastructure reliability, latency and more

• 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’

• Keeps up to date with the latest data and technology trends and methods by staying abreast of state-of-the-art literature in the fields of big data, data platforms, data engineering, analytics solutions, deep learning, operations research, machine learning, statistical modeling, statistical process control and mathematical optimization

• Undertakes special projects or assignments as required

• Performs other related duties as required

SALARY RANGE

BCI offers a competitive total rewards package which includes a performance-based incentive plan, comprehensive health & dental benefits, a defined benefit pension plan and paid time off.

The annualized base salary range this role is C$100,000 to C$120,000. The base salary offered to the successful candidate will consider a wide array of factors including but not limited to the individual’s skill set, level of experience applicable to the role they are being offered and consideration to internal equity.

We pay our people competitively in the markets in which we compete for talent and with consideration to internal equity and job structure. We aim for actual pay to be around the median of the market for target or expected levels of performance, and around the upper quartile of the market for excellent performance.

Actual salaries may vary and may be above or below the range based on various factors, including, but not limited to, experience and expertise.

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 fifth consecutive year - and has built programs and benefits to support all our employees, including;

• Extended health and dental coverage, start on your first day of work. We have you covered!

• Our telehealth provider Dialogue connects you and your family to virtual healthcare appointments

• Eligibility to 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

• Four days in office (666 Burrard St, Vancouver BC) with the option to work from home once a week, promoting both a collaborative work culture and a healthy work-life balance

• Annual wellness allowance provided to support an active lifestyle and promote physical well-being while working from home

• On-going learning through our in-house mentoring program, professional dues support, tuition reimbursement, and online and in-house learning

• 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

At BCI, we value diversity and believe in fostering an inclusive culture where all employees can be successful.

We are performance-focused, 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 hr@bci.ca.