Business Intelligence Developer

Lotlinx; Winnipeg, Oakville, Vancouver; On-site; CAD 70,000 - 80,000; Full time

Job summary

A leading automotive technology company in Winnipeg is seeking a Business Intelligence Developer to transform data into insights and drive strategic decisions. This role involves building BI solutions, analyzing data performance, and ensuring data quality through collaboration across teams. Ideal candidates have strong SQL and Looker proficiency along with experience in data governance and visualization. Competitive salary of $70,000 - $80,000 plus bonuses offered.

Benefits

Competitive compensation

Flex time off

Career development opportunities

Qualifications

• 2+ years of hands-on experience in Business Intelligence or Data Engineering.
• Strong proficiency in SQL for complex data querying.
• Experience with large datasets and cloud databases.

Responsibilities

• Transform raw data into actionable insights.
• Design and maintain reports and dashboards in Looker.
• Perform routine data quality checks.

Skills

Looker proficiency

SQL

Problem-solving

Data visualization

Education

Degree in Data Analytics, Computer Science, or related field

Tools

LookML

Git

Airflow

BigQuery

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.

Role Summary

As a Business Intelligence Developer, you will play a key role in driving a data-driven culture across the organization. You will transform raw data into powerful, actionable insights that guide strategic decisions while ensuring the accuracy and integrity of our data assets.

Reporting to the Product Manager, you’ll leverage your technical expertise to build and maintain sophisticated BI solutions within Looker. You will empower teams with the insights they need to make smarter, faster decisions. If you are passionate about operational excellence and telling stories with data, we want to hear from you!

Key Responsibilities

Business Intelligence & Data Analysis:

• Translate business requirements from stakeholders into technical specifications and sustainable BI solutions, including reports, dashboards, and data models.
• Design, develop, and maintain visually appealing and easy-to-understand reports and dashboards in Looker.
• Design, develop, and version control robust and scalable LookML models using GitLab to serve as the single source of truth for key business metrics.
• Analyze product performance and key KPIs, delivering actionable insights to improve outcomes.
• Utilize data orchestration tools, particularly Airflow, to schedule, monitor, and troubleshoot data pipelines and ETL/ELT processes.
• Proactively monitor data integrations and workflows to ensure continuous, error-free data flow.
• Perform routine data quality checks and audits to identify and resolve anomalies, ensuring accuracy and adherence to best practices.

Data Governance:

• Develop and enforce data governance policies to maintain data integrity, confidentiality, and compliance.
• Champion data governance best practices across the organization.
• Establish clear documentation for data sources, LookML models, processes, and workflows.

Cross-Functional Collaboration:

• Partner with product, engineering, and marketing teams to support product launches and onboarding.
• Act as a subject matter expert, assisting internal teams by troubleshooting data, reporting, or integration issues with a solution-oriented mindset.

Qualifications

• Degree or diploma in Data Analytics, Computer Science, Information Systems, Business, Statistics, or a related field.
• 2+ years of hands-on experience in a Business Intelligence, Data Engineering, or similar technical role.
• Proven experience with BI tools, with strong proficiency in Looker and LookML.
• Strong proficiency in SQL for complex data querying, manipulation, and optimization.
• Experience with version control systems (e.g., Git, GitLab) for managing code and BI projects.
• Experience with data orchestration tools (e.g., Airflow) is a strong asset.
• Hands-on experience with large data sets and cloud databases (e.g., BigQuery, MySQL, or similar).
• Familiarity with web analytics platforms (e.g., Google Analytics 4, Google Tag Manager).
• Excellent problem-solving skills with a meticulous, detail-oriented mindset.
• Strong communication skills, with the ability to convey technical concepts to non-technical audiences.

Why You'll Love Working With Us

• Impact: Your expertise will help us make critical data-driven decisions that drive growth and improve business performance.
• Ownership: Your impact will be felt across the organization as you create customized BI solutions that drive understanding and action.
• Collaboration: You'll have the opportunity to work with a diverse group of talented professionals in a fun, dynamic, and collaborative environment.

The salary range for this position is $70,000 - $80,000 with an annual target bonus.

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.