AI Jobs DB

The fastest and lightest job board for artificial intelligence / machine learning engineers, specialists, and scientists to find a new career

Senior Data Engineer (data warehouse/data lake design, development etc.) at British Columbia Investment Management Corporation (BCI)

Reporting to the Director, Data & Analytics, the Senior Data Engineer is responsible for the design, development and implementation of the data and analytics products and projects that enable data science efforts in the organization. The Senior Data Engineer will deliver business value to multiple business areas across the organization and works closely with internal Technology and business area stakeholders. S/he will drive data modernization and innovation, and contributes to a strong data and analytics competency for BCI.

The position can be based in either Vancouver or Victoria with travel between the two cities.



  • Bachelor’s Degree in Technology, Computer Science, Mathematics or a related discipline
  • A minimum of 5 years of experience as a Data Engineer or Software Engineer professional
  • Experience with data warehouse and data lake design, development and sustainment
  • Coding skills and deep proficiency with SQL, Python, etc.
  • Competent with general scripting/software development
  • 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 Agile and DevOps, including CI/CD technologies and practices
  • Excellent listening, communication, collaboration and problem-solving skills


  • Knowledge of the investment management industry


  • Collaborates with team members, other IT teams, and customers to understand the organization’s business objectives, data needs and infrastructure needs
  • Provides technical leadership and creates a culture of customer-centricity, accountability and high performance
  • Designs, develops and implements the data pipelines and ETL tools and workflows that enable data science efforts within the organization
  • Works with Data Architects and Data Scientists on the design, development and implementation of operational, transactional and analytical modeling
  • 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
  • Robustly 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
  • Helping the business interpret the results of analyses to determine the appropriate course of action
  • 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

Please let the company know you found this position via so we can keep providing you with quality jobs.

by Tsutomu Narushima