Price, Promotion & Trade Analyst

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

Job summary

LG Electronics Canada is seeking a Price, Promotion & Trade Analyst to support the BS Sales Division in achieving targets while optimizing promotions and pricing strategies. The role involves budget forecasting, profitability simulations, bid management, and data-driven insights using Power BI, Python and SQL tools.

Ideal candidates hold a Bachelor's degree with 2-5 years of financial analysis or sales data analysis experience, and are proficient in Excel, PowerPoint, Power BI, VBA and Python.

Qualifications

• Bachelor’s degree with 2-5 years' experience in Financial analysis, Forecasting or Sales data analysis.
• Proficiency in Excel, PowerPoint, Power BI, VBA and Python.
• Detail oriented with strong data handling and organizational skills.
• Ability to work on multiple projects in a fast-paced environment with tight deadlines.

Responsibilities

• Development and management of promo planner on SQL server (OLAP).
• Manage and forecast spending budget and PSI for BS products on a monthly basis.
• Assess profitability simulation on promotion activities.
• Review sales program and provide guideline on registration.
• Manage RFPs by bid number and simulate expected costs for bids, prepare proper budget accordingly, and update and maintain bid information in Claim portal.
• Assist with new product launch activities.
• Investigate market trends and competitors’ behavior in the market.
• Maintain Power BI dashboard for market insights based on NPD monthly result.
• Maintain Python web scrapping tool for online price tracker.
• Ensure data accuracy for sales strategy and planning; Support sales pricing and promotion simulation.
• Ad hoc analysis as required.
• Additional duties as assigned.

Skills

Detail oriented

Multi-tasking

Time management

Communication skills

Education

Bachelor's degree in Finance/Analytics

Tools

Excel

PowerPoint

Power BI

VBA

Python

Job description

Department: Finance - Price, Promotion & Trade

Work Hours: Monday-Friday, 8AM-5PM

At LG, we create Innovation for a Better Life.

We design products and services that make life better, easier, and more enjoyable. Whether it’s through smart functionality, design, or innovative technology, our home appliances, including kitchen, laundry and lifestyle solutions, media entertainment products including televisions, sound bars, projectors, computer monitors and laptops, to cutting-edge business solutions in IT, digital signage, and HVAC, we’re driven by one simple idea: to make Life Good.

As a global leader in consumer electronics, LG is committed not only to enriching the lives of our customers, but also to create rewarding experiences for our employees. We offer meaningful challenges, continuous learning opportunities, and a workplace culture that recognizes collaboration and rewards excellence.

Across our global network, LG employees share a common mission: to bring the Life’s Good promise to our customers by creating a better life for people, and a better future for our planet through our smart life solutions. Our relentless drive for innovation, combined with our culture of challenge and change, enables us to lead in today’s dynamic market.

At LG, Life’s Good.

POSITION SUMMARY:

LG Electronics is looking for a Price, Promotion & Trade Analyst, who will contribute to assist in the day-to-day operation of the Business Solutions (BS) Sales Division to ensure the sales goals and objectives are met, while supporting the needs of both LG and its customers alike.

PRINCIPAL RESPONSIBILITIES:

• Development and management of promo planner on SQL server (OLAP)
• Manage and forecast spending budget and PSI for BS products on a monthly basis
• Assess profitability simulation on promotion activities
• Review sales program and provide guideline on registration
• Manage RFPs by bid number and simulate expected costs for bids, prepare proper budget accordingly, and update and maintain bid information in Claim portal
• Assist with new product launch activities
• Investigate market trends and competitors’ behavior in the market
• Maintain Power BI dashboard for market insights based on NPD monthly result
• Maintain Python web scrapping tool for online price tracker
• Ensure data accuracy for sales strategy and planningSupport sales pricing and promotion simulation
• Ad hoc analysis as required
• Additional duties as assigned

KNOWLEDGE, SKILLS, AND ABILITIES:

• Bachelor’s degree with 2-5 years' experience in Financial analysis, Forecasting or Sales data analysis
• Advanced Excel & PowerPoint, Power BI, VBA, Python
• Detail oriented and good at handling data
• Good organization skills and able to multi-task
• Ability to work on multiple projects in a fast-paced environment with tight deadlines
• Time management and superior communication skills

Nice-to-have:

• Budgeting and Planning experience
• Experience with ERP systems
• Business to Business (B2B) experience

Note:

This posting is for an existing vacancy. The expected base salary range for this position is $50,000 – 55,000.Actual total compensation may include variable incentive pay. The determination of an applicant's base salary is based on the applicant's skills, competencies, location, and unique qualifications.

Artificial intelligence will be used in sourcing, reviewing and communicating with candidates for this position.

This job description is not intended to be all-inclusive. Employee may perform other related duties as negotiated to meet the ongoing needs of the organization.

The organization offers an attractive compensation package that encompasses a competitive salary and excellent benefits.

Conditions of Employment:

It is the candidate’s sole responsibility to obtain any work permits/visas or other authorizations which may be required to legally work in Canada prior to commencing employment.

Equal Opportunity Employer:

LG Electronics Canada, Inc. is strongly committed to diversity and inclusion and aims to create a healthy, accessible, and rewarding work environment which highlights employees’ unique contributions to our company’s success. As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve. LG Electronics Canada, Inc., will provide accommodations throughout the recruitment, selection and/or assessment process to applicants with disabilities. If selected to participate in the recruitment, selection and/or assessment process, please inform LG’s Human Resources staff of the nature of any accommodation(s) that you may require in respect of any materials or processes.

LG Electronics Canada, Inc. thanks all candidates for their interest, however, only those selected to continue in the process will be contacted.