BI Developer: Data Pipelines, Dashboards & Analytics

LG Electronics Canada; Toronto; On-site; CAD 55,000 - 70,000; Full time

Job summary

LG Electronics Canada, Inc. is seeking a Business Intelligence Developer to advance our data-driven strategy. You will build robust data pipelines, perform ETL with SSIS, model data, and support analytics across sales, marketing, and demographics.

Expertise in Python for automation and experience with BI tools such as Tableau or Power BI will help craft insightful dashboards and reports. You will collaborate with cross-functional teams and help define KPIs to improve decision making.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 2+ years’ experience with data engineering principles and data integration techniques across various systems and platforms.
• 1+ year experience with Python for automation, data processing, and data analysis.
• 1+ year experience with Data Visualization BI Tools like Tableau or Power BI.
• Strong proficiency in Microsoft SQL Server, including database administration, T-SQL, ETL (SSIS), and data modeling.
• Knowledge of eCommerce KPIs, analytics, and customer journey mapping.

Responsibilities

• Develop and maintain data pipelines, ETL processes, and data integrations using Microsoft SQL Server (SSIS).
• Create and optimize data models to facilitate efficient data retrieval and analysis.
• Process and transform data using Python to automate tasks and data pipeline.
• Use Tableau or Power BI to develop dashboards and reports showing trends and insights.
• Collaborate with cross-functional teams to define KPIs and reporting mechanisms.

Skills

SQL Server

ETL (SSIS)

Python scripting

Data modeling

Tableau

Power BI

GA360

Data visualization

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

Microsoft SQL Server

SSIS

SSAS

Tableau

Power BI

Python

GA360

Job description

LG Electronics Canada, Inc. is seeking a Business Intelligence Developer to advance our data-driven strategy. You will build robust data pipelines, perform ETL with SSIS, model data, and support analytics across sales, marketing, and demographics.

Expertise in Python for automation and experience with BI tools such as Tableau or Power BI will help craft insightful dashboards and reports. You will collaborate with cross-functional teams and help define KPIs to improve decision making.