You will design, prototype, and optimize complex data workflows and architectures, focusing on SQL optimization, Python development, and data-driven analysis.…
Have a minimum of 5 years of experience in software development, with a strong focus on Python programming. Senior Machine Learning Engineer is responsible for……
Hold a degree in Computer Science, Software Engineering, or a related field. The person in this role plays a key part in the design and development of……
Bachelor’s degree in Computer Science, Software Engineering, or equivalent professional experience. Familiarity with AI-assisted development (e.g., GitHub……
The program is replacing tightly coupled legacy integrations with a modern, API-first and event-driven architecture, delivering a set of enterprise-grade REST……
Expertise in software tools development Software tools development expertise. Expertise in low-level input/output driver development and debugging.…
The program is replacing tightly coupled legacy integrations with a modern, API-first and event-driven architecture, delivering a set of enterprise-grade REST……
Demonstrated experience leading solution design for complex systems: facilitating architecture sessions, producing design documentation, and driving teams from……
Support certification and compliance testing, primarily UL and CE. The Senior Hardware Designer is fully competent in digital and analog hardware design and……
Benefits Summary: Regular full-time and part-time employees (working at least 20 hours per week) will have access to health, dental, and vision plans, a……
html body { background: var(-token-05ee8afc-e0e3-4af6-a6d4-6e4138265c20, rgb(18, 18, 38)); }
Database Engineer
Design and build scalable, high-performance systems that enhance our decision-making platform’s efficiency and reliability.
About the job
We are seeking a Senior Database Engineer with 6+ years of experience to join our Data Platform team. You will design, prototype, and optimize complex data workflows and architectures, focusing on SQL optimization, Python development, and data-driven analysis. This role requires advanced technical expertise and the ability to work collaboratively with the product manager and software architect.
Key Responsibilities
Design, develop, and optimize complex SQL queries and Python macros for data transformations within the DuckDB framework.
Implement advanced data normalization and denormalization strategies to ensure data integrity and performance.
Perform data pipeline transformations 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's functionality.
Ensure high performance and scalability of database operations through performance tuning and effective indexing strategies.
Manage changes that need to ripple across tables in the dataset, leveraging efficient update processes and monitoring tools.
Write platform-grade Python code while adhering to best practices and coding standards.
Mentor junior developers, sharing expertise in database design and SQL transformations.
Job Requirements
6+ years of relevant work experience
Expertise in Database Design, Query Engine Design, Database storage engines
Excellent ability to map business domains to data models
Excellent written and spoken communication skills
Advanced SQL Development: Optimize complex queries (CTEs, window functions, pivots, grouping sets) in DuckDB and PostgreSQL.
Data Pipeline Design: Build and optimize data workflows using Python and modern tools like Spark, DBT, Kafka, Dagster, and Flink.
Exploratory Data Analysis (EDA): Apply statistical methods and machine learning principles to derive insights and drive decision-making.
Integration of GenAI Tools: Work seamlessly with tools in IDE environments (Visual Studio Code, Jupyter Notebook).
DataOps and DevOps: Design and optimize pipelines, manage Git-based version control, and implement CI/CD workflows.
Collaboration: Document requirements and analysis, communicate effectively with clients, and contribute to a user-centric development process.
Our office is located in Collingwood, Ontario. You must be willing to come to the office twice a week.
How To Apply
Please send your cover letter and resumé to Nathalie Burstein at info@liquidanalytics.com. Be sure to include the title of the job you’re applying to.
The minimum salary is $102K and the max salary is $113K.
$102K – $113K/yr (Glassdoor Est.)
$107K
/yr Median
Collingwood
If an employer includes a salary or salary range on their job, we display it as "Employer provided". If a job has no salary data, Glassdoor displays a "Glassdoor estimate" if available. To learn more about "Glassdoor estimates", see our FAQ page.
Working here doesn’t have to be a secret
Sign in to browse authentic reviews, anonymous ratings and salary data before you apply.