Database Engineer
Posted Updated
Description
Liquid Analytics in Collingwood, Ontario, is hiring a Senior Database Engineer to design, optimize, and scale complex data workflows using DuckDB, PostgreSQL, and Python. The role focuses on data modeling, performance tuning, and integrating ML methods into data pipelines.
The position requires 6+ years of experience, strong communication skills, and collaboration with product managers and software architects. Office presence is expected twice weekly at our Collingwood office.
Design, develop, and optimize SQL queries and Python macros for data transformations in DuckDB. Implement data normalization/denormalization to ensure data integrity and performance. Transform data pipelines and integrate statistical and ML methods into SQL and Python workflows. Collaborate with cross-functional teams to define data architecture and enhance the lb_duckdb_manager functionality. Ensure high performance and scalability of database operations through performance tuning and indexing strategies. Manage changes that ripple across tables with efficient update processes and monitoring. Write platform-grade Python code following best practices and coding standards. Mentor junior developers in database design and SQL transformations. Work with GenAI tools in IDE environments (Visual Studio Code, Jupyter Notebook). 6+ years of relevant work experience. Expertise in Database Design, Query Engine Design, and storage engines. Excellent written and spoken communication skills. Experience with DuckDB and PostgreSQL. Experience with data pipelines and ML/EDA concepts.Skills
Sign in to read and join the discussion.