Senior Analytics Engineer

Lotlinx; Hamilton, Vancouver, Winnipeg; Hybrid; CAD 103,000 - 157,000; Full time

Job summary

A leading company in the automotive technology sector is seeking a Senior Analytics Engineer to enhance their data infrastructure. The role involves architecting data models, developing pipelines, and collaborating with cross-functional teams to support data-driven decision-making. Ideal candidates will have extensive experience in SQL, data modeling, and cloud data warehousing, particularly with Google BigQuery.

Benefits

Competitive compensation and benefits

Flex time off

Career development opportunities

Qualifications

• 4+ years in Analytics Engineering or Data Engineering.
• Expertise in SQL and performance optimization for large datasets.
• Experience with cloud data warehouses, preferably BigQuery.

Responsibilities

• Architect and build scalable data models in Google BigQuery.
• Develop and optimize ELT/ETL pipelines for high-volume data.
• Collaborate with data analysts and stakeholders to meet data needs.

Skills

SQL

Data Modeling

Data Analysis

Python

Performance Optimization

Problem-Solving

Communication

Education

Relevant degree in Data Engineering or related field

Tools

Google BigQuery

Apache Pinot

Job description

Since our founding in 2012, Lotlinx has consistently pioneered advancements in the automotive landscape. We specialize in empowering automobile dealers and manufacturers by providing cutting-edge data and technology, delivering a distinct market advantage for every single vehicle transaction. Today, we stand as the foremost automotive AI and machine learning powered technology, excelling in digital marketing, risk management, and strategic inventory management.

Lotlinx provides employees with a dynamic work environment that is challenging, team-oriented, and full of passionate people. We offer great incentives to our employees, such as competitive compensation and benefits, flex time off, and career development opportunities.

Position Summary

We are seeking an experienced Senior Analytics Engineer to join our growing Data team. You will play a pivotal role in architecting, building, and optimizing the data foundations that power analytics and data-driven decision-making across LotLinx. Reporting to the Director of Data Analytics, you will collaborate closely with Data Analysts, Data Engineers, and Product Managers to translate business needs into robust, scalable, and reliable data models and pipelines that are incorporated into our product portfolio. This is a key position where you'll have significant ownership and impact on our data infrastructure and strategy.

This is a hybrid role and requires 3-4 days a week in either our Winnipeg or Hamilton office.

Responsibilities

• Architect & Build Data Models: Design, develop, and maintain scalable and performant data models in our data warehouse (Google BigQuery, Apache Pinot) to serve as the single source of truth for analytics.
• Data Analysis: Conduct data validation and exploratory analysis across massive datasets (billions of rows, terabytes) to ensure the integrity of data pipelines and the accuracy of downstream reporting.
• Develop Large Data Pipelines: Develop, monitor, and troubleshoot ELT/ETL pipelines processing high-volume data streams, ensuring reliability and performance at the terabyte scale.
• Optimize Pipeline Performance: Optimize complex SQL queries and data transformation logic for maximum performance and cost-efficiency using multi-terabyte datasets within Google BigQuery.
• Enhance OLAP performance: Analyze Apache Pinot query performance logs and usage patterns across terabyte-scale datasets to identify optimization opportunities and troubleshoot complex data access issues.
• Enable Data Consumers: Partner with data analysts, data scientists, and business stakeholders to understand their data requirements, providing clean, well-documented, and easy-to-use datasets.
• Champion Data Quality & Governance: Implement data quality checks, testing frameworks, and documentation standards to ensure the trustworthiness and usability of our data assets.
• Collaborate & Mentor: Work effectively within a collaborative team environment. Potentially mentor junior team members and share best practices in analytics engineering.
• Stay Current: Keep abreast of new technologies, tools, and best practices in the analytics engineering space and advocate for their adoption where relevant.

Qualifications

Experience: 4+ years of relevant professional experience in Analytics Engineering, Data Engineering, or a highly related role, with a proven track record of building and managing complex data systems.

• Expert SQL: Deep expertise in writing complex, highly performant SQL for data transformation, aggregation, and analysis, particularly within a cloud data warehouse environment like BigQuery.
• Performance Optimization: Demonstrated experience writing, tuning, and debugging complex SQL queries specifically for large-scale data warehouses (multi-terabyte environments), preferably BigQuery or Apache Pinot.
• Data Modeling Mastery: Strong understanding of data modeling concepts (e.g., Kimball, Inmon, Data Vault) and practical experience designing and implementing warehouse schemas.
• ETL/ELT & Orchestration: Proven experience building and maintaining data pipelines using relevant tools and frameworks. Python proficiency for scripting and data manipulation is essential.
• Cloud Data Warehousing: Significant experience working with cloud data warehouses, specifically Google BigQuery. Understanding of underlying architecture and optimization techniques.
• Problem-Solving: Excellent analytical and problem-solving skills, with the ability to troubleshoot complex data issues independently.
• Communication & Collaboration: Strong communication skills, capable of explaining complex technical concepts to both technical and non-technical audiences. Proven ability to collaborate effectively across teams.

Nice-to-Haves

• Previous experience in the Automotive or AdTech industry.
• Familiarity with workflow orchestration tools like Apache Airflow.
• Experience with Apache Pinot.
• Experience with data quality and testing frameworks.
• Familiarity with Google Cloud Platform (GCP) services beyond BigQuery.
• Cloud/Warehouse: Google Cloud Platform (GCP), AWS, Google BigQuery, Apache Pinot
• Transformation: SQL, Python
• Ingestion: Custom Scripts, Pub/Sub, Lambda

The salary range for this position is $103,000 - $157,000

Lotlinx is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Lotlinx is not currently able to offer sponsorship for employment visa status.

Lotlinx is headquartered in Peterborough, NH and has locations in Holmdel NJ, Manitoba, Ontario and British Columbia, Canada in addition to a large team spanning from the US to Canada.

Our success relies heavily on our customers but also our dedicated talent that continuously moves our platform forward. We value our employees, their abilities and seek to foster an open, cooperative, dynamic environment where the team and company alike can thrive.

Apply for this job

*

indicates a required field

First Name *

Last Name *

Email *

Phone *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

LinkedIn Profile

Website

Are you authorized to work in Canada? * Select...

Can you work in the Winnipeg or Hamilton office location? This is a hybrid position. * Select...