Senior Database Python Software Developer

2 weeks ago

The Blue Mountains, Canada Liquid Analytics Full time

**Job Title: Senior Database Python Software Developer**


**Location:** Blue Mountains, Ontario, Canada

**Remote Work:** You live where we work. You can come into our offices near Thornbury, Ontario, any day of the week as required.

**Job Type:** Full-Time


**About Us:**

At Liquid Analytics, we are committed to leveraging data-driven insights to enhance our longbow platform's capabilities. We are seeking a highly skilled and motivated **Senior Database Software Developer** to join our dynamic team. This role is critical in driving our streaming analytics initiatives using DuckDB and will be instrumental in shaping the future of our data processing workflows.


### **Key Responsibilities:**

  • Extensive experience building production-grade servers in Python.
  • 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.
  • 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.


### **Key Requirements:**

- **Expertise in SQL**: Proven experience in writing complex queries, performance tuning, and data transformations. Familiarity with advanced SQL features such as window functions, CTEs, and recursive queries.

- **Proficiency in Python**: Strong skills in Python for data processing, with experience in writing efficient and maintainable code.

- **Data Pipeline Transformations**: Experience in designing and implementing data pipelines, with a focus on streaming analytics.

- **Statistical and ML Methods**: Knowledge of applying statistical methods and machine learning techniques in SQL and Python.

- **DevOps Knowledge**: Experience in cloud development practices and CI/CD pipelines.

- **Business Logic Integration**: Ability to incorporate complex business logic into SQL transformations while maintaining transactional integrity and performance.

- **Analytical Mindset**: Strong problem-solving skills with the ability to analyze and optimize data workflows for performance and reliability.


### **Additional Skills and Knowledge:**

1. **Data Normalization**:

- Understanding the database normalization processes and the challenges associated with maintaining data integrity and performance during normalization.


2. **Data Denormalization**:

- Knowledge of when to denormalize for performance, understanding the trade-offs, redundancy, and data anomalies.


3. **Handling Data Types and Casting**:

- Experience with various data types, precision, and scale in numeric data and string manipulation.


4. **Performance Tuning**:

- Proficiency in reading execution plans, identifying performance bottlenecks, and implementing effective indexing strategies.


5. **Business Logic Integration**:

- Experience implementing complex business rules and ensuring transactional integrity across data transformations.


6. **Memory-Mapped Columnar Databases**:

- Familiarity with memory-mapped columnar databases and how memory mapping enhances performance and data accessibility.


7. **Managing Connections for Single-Process Analytics Databases**:

- Knowledge of memory management, connection management for read-write and read-only connections, and managing and publishing changes in a single-process analytics database like DuckDB.


### **Benefits:**

- Competitive salary and performance-based bonuses.

- Health, dental, and vision insurance.

- Flexible work hours and remote work opportunities.

- Professional development and continuous learning programs.

- Surrounded by nature in a beautiful environment with clean air and water.


### **How to Apply:**

You live where we work. You can come into our offices near Thornbury, Ontario, any day of the week as required.


Start by visiting our website and understanding the DuckDB database project.


You thrive in a fast-paced environment where delivering functional, user-centric features is key, and you’re comfortable with client interactions. Your development process begins with thorough requirement analysis and documentation, ensuring clarity and precision in every project. Experience with GitLab monorepos, build systems, and feature flagging is highly desirable.


Located within 40 minutes of Thornbury, Ontario, this role offers the opportunity to work in an area surrounded by nature. You can enjoy clean air and water in a beautiful environment. You are willing to locate yourself within 40 minutes of our offices so that you can come into the office at any time.

  • Senior Database Python Software Developer

    2 weeks ago

    The Blue Mountains, Ontario, CA Liquid Analytics Full time

    **Job Title: Senior Database Python Software Developer****Location:** Blue Mountains, Ontario, Canada**Remote Work:** You live where we work. You can come into our offices near Thornbury, Ontario, any day of the week as required.**Job Type:** Full-Time**About Us:** At Liquid Analytics, we are committed to leveraging data-driven insights to enhance our...

  • Senior Database Software Architect

    2 weeks ago

    The Blue Mountains, Ontario, Canada Liquid Analytics Full time

    About the Role:We are seeking an experienced Senior Database Software Architect to join our dynamic team at Liquid Analytics. This is a critical role in driving our streaming analytics initiatives using DuckDB and shaping the future of our data processing workflows.Key Responsibilities:Design, develop, and optimize complex SQL queries and Python macros for...

  • Highly Skilled Python Developer for Data-Driven Insights

    1 week ago

    The Blue Mountains, Ontario, Canada Liquid Analytics Full time

    Job Title: Highly Skilled Python Developer for Data-Driven InsightsLocation: Blue Mountains, Ontario, CanadaRemote Work: Flexible work arrangements available with opportunities to collaborate with our team in Thornbury, Ontario.Job Type: Full-TimeAbout Us: At Liquid Analytics, we harness the power of data-driven insights to enhance our longbow platform's...

  • Senior Fullstack UI Developer

    2 weeks ago

    The Blue Mountains, Canada Liquid Analytics Full time

    Role SummaryBuild reactive database web applications Liquid Analytics is seeking a Senior JavaScript Svelte developer with at least 5 years of experience.You excel at creating pixel-perfect UI and have a deep understanding of colour, typography, layout, and user experience design.As a full-stack developer, you will own end-to-end features and build front-end...

  • Senior Fullstack UI Developer

    2 weeks ago

    The Blue Mountains, Canada Liquid Analytics Full time

    Role SummaryBuild reactive database web applications Liquid Analytics is seeking a Senior JavaScript Svelte developer with at least 5 years of experience.You excel at creating pixel-perfect UI and have a deep understanding of colour, typography, layout, and user experience design.As a full-stack developer, you will own end-to-end features and build front-end...

  • Senior Fullstack UI Developer

    2 weeks ago

    The Blue Mountains, Ontario, CA Liquid Analytics Full time

    Role SummaryBuild reactive database web applications Liquid Analytics is seeking a Senior JavaScript Svelte developer with at least 5 years of experience.You excel at creating pixel-perfect UI and have a deep understanding of colour, typography, layout, and user experience design.As a full-stack developer, you will own end-to-end features and build front-end...

  • Senior Frontend Engineer for Real-Time Web Applications

    1 week ago

    The Blue Mountains, Ontario, Canada Liquid Analytics Full time

    Liquid Analytics seeks a skilled Senior Fullstack UI Developer to join our team. With a focus on delivering functional, user-centric features, this role offers the opportunity to work in an area surrounded by nature.Job DescriptionWe are looking for a talented developer with at least 5 years of experience to own end-to-end features and build front-end and...

  • Senior Executive Chef

    4 weeks ago

    The Blue Mountains, Ontario, Canada Mcewan Full time

    Job TitleSenior Executive ChefAbout UsMcewan is a dynamic and innovative food service company that values teamwork, customer satisfaction, and employee development.Salary$60,000 - $80,000 per year, depending on experience.Job DescriptionWe are seeking a highly skilled and experienced Senior Executive Chef to join our team. As a key member of our culinary...

  • Senior Living Operations Director

    4 weeks ago

    The Blue Mountains, Ontario, Canada Southbridge Care Homes Full time

    Job Description:We are seeking an experienced Senior Living Operations Director to oversee the daily operations of two of our retirement homes in Shelburne and Thornbury, ON.Key Responsibilities:Coordinate and implement day-to-day operations, ensuring seamless resident care and service delivery.Exercise delegated authority for resident care planning and...

  • CEO (chief executive officer) - financial, communications and other business services

    3 weeks ago

    Blue Mountains, Canada Liquid Analytics Full time

    Durée de l'emploi: PermanentLangue de travail: AnglaisHeures de travail: 40 hours per weekEducation: Expérience: EducationMaster's degreeWork settingSalesTasksAllocate material, human and financial resources to implement organizational policies and programsAuthorize and organize the establishment of major departments and associated senior staff...

  • CEO (chief executive officer) - financial, communications and other business services

    3 weeks ago

    Blue Mountains, Canada Liquid Analytics Full time

    Work Term: PermanentWork Language: EnglishHours: 40 hours per weekEducation: Master's degreeExperience: 5 years or moreWork settingSalesTasksAllocate material, human and financial resources to implement organizational policies and programsAuthorize and organize the establishment of major departments and associated senior staff positionsEstablish objectives...

  • Ultimate Fullstack UI Expert Wanted

    2 weeks ago

    The Blue Mountains, Ontario, Canada Liquid Analytics Full time

    We are seeking a highly skilled Senior Fullstack UI Developer to join our team at Liquid Analytics.About the RoleThis is a full-time opportunity that requires strong expertise in both front-end and back-end development, with a focus on creating exceptional user experiences.The ideal candidate will have extensive experience with Python, JavaScript, and SQL,...

  • Care Coordinator for Seniors

    4 weeks ago

    The Blue Mountains, Ontario, Canada Southbridge Care Homes Full time

    Company OverviewWe are Southbridge Care Homes, a leading provider of quality care services for seniors. Our mission is to deliver exceptional care and support to our residents, enhancing their overall well-being and quality of life.Job Title: Unregulated Care ProviderSalary: $45,000 - $55,000 per year, depending on experienceAbout the RoleWe are seeking a...

  • Senior Living Operations Manager

    4 weeks ago

    The Blue Mountains, Ontario, Canada Southbridge Care Homes Full time

    Welcome to Southbridge Care Homes, a leading provider of senior living services in Ontario. We are currently seeking a highly skilled and experienced Senior Living Operations Manager to oversee the day-to-day operations of two of our retirement homes in Shelburne and Thornbury.As a member of our leadership team, you will play a critical role in ensuring the...

  • Senior Culinary Professional

    4 weeks ago

    The Blue Mountains, Ontario, Canada Mother Tongue Full time

    Job Title: Senior Culinary ProfessionalWe are seeking a skilled and experienced Senior Culinary Professional to join our team at Mother Tongue. As a key member of our kitchen staff, you will be responsible for preparing and cooking high-quality meals, supervising kitchen staff, and maintaining a clean and organized workspace.Required Skills and...

  • Senior Food Operations Manager

    4 weeks ago

    The Blue Mountains, Ontario, Canada New Orleans Pizza Full time

    About the RoleWe are seeking a skilled Senior Food Operations Manager to join our team at New Orleans Pizza. As a key member of our management team, you will be responsible for ensuring the highest standards of food quality and customer satisfaction.Key ResponsibilitiesOperations Management: Oversee all aspects of food preparation and service, including menu...

  • Home Manager

    3 months ago

    The Blue Mountains, Canada Southbridge Care Homes Full time

    Welcome Home! Southbridge Care Homes is looking for a Retirement Home Manager to manage the day to day between two of our homes in Shelburne and in Thornbury, ON. If working with seniors is a passion of yours, and you enjoy bringing joy and fun to the lives of others, and have strong leadership skills, you would be a great fit for this position and we...

  • Senior Culinary Team Leader

    3 weeks ago

    The Blue Mountains, Ontario, Canada Mcewan Full time

    Mcewan's Experienced Chef OpportunityWe are seeking a highly skilled Senior Culinary Team Leader to join our team at Mcewan. As a key member of our kitchen staff, you will be responsible for leading and managing a team of cooks and other kitchen workers.Job Description:Cooking and Preparation:Instruct cooks in preparation, cooking, garnishing, and...

  • Senior Culinary Specialist

    4 weeks ago

    The Blue Mountains, Ontario, Canada MJ BYRNE'S IRISH PUB Full time

    We are seeking a highly skilled and experienced Senior Culinary Specialist to join our restaurant operations team at MJ Byrne's Irish Pub. In this role, you will be responsible for preparing and cooking complete meals or individual dishes and foods to the highest standards.The ideal candidate will have a strong background in culinary arts, with a minimum of...

  • Italian Kitchen Senior Sous Chef

    4 weeks ago

    The Blue Mountains, Ontario, Canada Magnone's Italian Kitchen Full time

    About the RoleWe are seeking a highly skilled Italian Kitchen Senior Sous Chef to join our team at Magnone's Italian Kitchen. This is an exciting opportunity for an experienced culinary professional to take on a leadership role and contribute to the success of our restaurant.Key ResponsibilitiesMaintain accurate records of food costs, consumption, sales,...