Sql data analyst Jobs in Markham, ON

Come work with us to do what you love and stay for the Frontier TRACK

Team Centric : We each take responsibility for fostering an environment of personal and professional growth. We are eager to help support and collaborate with one another recognizing that we are better when we work together.

Respectful and Inclusive : We treat everyone the way we want to be treated and accept everyone on the team just as they are.

Autonomous and Accountable : We are entrusted with and given the space to do our work and in turn hold ourselves accountable for results.

Committed to Excellence : We are fueled by the desire to be our best and to make an impact now and tomorrow.

Keep it Real : We lead with integrity and genuineness in our work interactions and relationships.

Were looking for a hands-on Senior Data Analyst who will own our end-to-end analytics process from data collection and preparation to insight delivery turning raw data into actionable strategies that improve customer retention and drive business growth.

Key Responsibilities :

Sales & Business Insights

ML / AI Apply machine learning and AI to accelerate decision-making and identify opportunities for increased revenue : customer segmentation churn / retention propensity next-best-offer and promo uplift modeling demand / forecast refinement price elasticity insights and anomaly detection for sales operations.

Insight generation Analyze sales trends customer behavior and market data to identify opportunities for increased revenue.

Campaign analysis Evaluate the performance of marketing campaigns and promotional initiatives providing data-driven recommendations to maximize ROI and customer engagement.

Forecasting & strategy Partner with sales and marketing leadership to develop data-informed sales forecasts pipeline analyses and pricing strategies that drive growth and operational efficiency.

Cross-functional collaborator Work closely with teams across the organization (sales marketing purchasing etc.) to understand business needs manage stakeholder expectations and ensure that insights are translated into actionable business decisions.

Data Analysis & Reporting

Data wrangler Leverage data from multiple sources (e.g. ERP CRM web analytics etc.) to create a single source of truth for analysis.

Dashboard & reporting Design and maintain interactive dashboards and reports (using tools like Power BI or similar) to monitor key performance indicators and communicate trends to stakeholders in real time.

Pipeline automation Develop and automate reliable ETL / ELT workflows using SQL and Python scripts to ensure timely availability of accurate data for analysis.

Data quality & governance Implement data validation checks documentation and version control to uphold data integrity security and compliance with governance standards.

Technical Skills :

Experience : 5 years in data analysis business intelligence or a related analytics field preferably in a fast-paced or high-growth ecommerce environment.

End-to-end analytics : Demonstrated success owning analytics projects from start to finish from gathering business requirements and extracting data to building dashboards and presenting insights that influenced key decisions.

Ecommerce domain knowledge : Proven experience working with sales and customer data to produce insights that improved customer retention guided revenue growth or informed successful sales / marketing strategies.

SQL & Python : Expertise in writing complex SQL queries for data extraction and transformation along with proficiency in Python for data analysis and automation (e.g. using pandas NumPy or scripting ETL workflows and other statistical libraries).

Data visualization : Hands-on experience with modern BI tools especially Power BI (or similar platforms like Tableau / Looker) to create interactive dashboards and reports. Ability to craft insightful data visualizations and DAX measures (if using Power BI) is a strong plus.

Data ecosystem : Familiarity with cloud-based data warehouses and tools (AWS Azure or GCP ecosystems) and comfort working with large datasets. Knowledge of data modeling and data pipeline frameworks (dbt Airflow etc.) is advantageous.

Strategic mindset : Ability to translate high-level business objectives into analytical questions and to interpret data findings in the context of business strategy. Demonstrated skill in communicating actionable recommendations to both technical and non-technical stakeholders.

While experience with the tools listed is a plus we strongly encourage applicants with expertise in comparable technologies to apply. Relevant industry certifications are a plus for example AWS or Azure cloud certifications or data platform certifications like Fabric Snowflakes or Databricks.

Why join us (Brace yourself)

We offer competitive compensation

Extended Health and Dental Benefits Plan (100% Employer-paid Premiums on eligible benefits)

Continuous Learning Assistance Program reimbursing up to $1500 per calendar year

Group RRSP (Non-match)

15 Vacation Days to start and scale to 20 Vacation Days.

Paid Religious Holidays and Volunteer Days

Flexibility to help you balance work and life

Corporate GoodLife Fitness Membership Discount

Supportive leadership team and Culture Committee that works to maintain a positive culture

Fully stocked snacks team BBQs and other company paid meals (we love to eat!)

What are we at the frontier of

Providing quality and top brand dental supplies to dental practices all across North America. Our customers trust our deep knowledge of the dental trade and our ability to provide the right products at competitive prices all through simple and efficient channels. We currently sell and distribute more than 30000 unique products to 3000 dental offices in Canada and the U.S. Were on the cusp of something big.

With roots in the dental wholesale and distribution industry Frontier Dental Supply Inc. was formed in 2016. We are headquartered in the Greater Toronto Area (GTA).

We are proud to have been certified and awarded the following :

Great Place to Work for four consecutive years.

The Best Workplaces in 2021.

Finalist for Fastest Growing Company 2021 and Startup Business of the Year 2021 by CanadianSME.

Excellence in Customer Service 2023.

Who is at the frontier of our success

Our people. Our people make it all possible. Thats why we seek to grow our team with individuals who desire to stay on course the Frontier TRACK.

Learn more about what its like to work at Frontier Dental Supply Inc. from our very own employees on our Glassdoor page.

Were rooting for you! We thank all candidates for taking the time to apply. However only those candidates selected to move forward in our recruitment process will be contacted.

Here at Frontier Dental we are a diverse team that nurtures an inclusive environment. We attribute our growth significantly to our ability to learn from one anothers perspectives. Frontier Dental values the unique skills and experiences of each of our candidates; recognizing that each prospective team member contributes to our efforts in building a diverse and inclusive place to work. We are committed to being an equal opportunity employer and are happy to provide accommodations upon request at all stages of the recruitment process. Should you require any disability-related accommodation to support your participation in our recruitment process please notify us and we will work with you to meet your accessibility needs.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities duties and skills required of employees so classified. All employees may be required to perform duties outside of their normal responsibilities from time to time as needed.

Frontier Dental uses an automated Applicant Screening Tool to assist in reviewing applications. This tool evaluates candidates based on job-related criteria including skills experience and qualifications listed in your application materials.

You may request an alternative non-automated assessment or an explanation of how the evaluation was conducted by contacting . All notices and candidate requests will be documented for compliance purposes

Required Experience :

Senior IC

Key Skills

Databases,Data Analytics,Microsoft Access,SQL,Power BI,R,Tableau,Data Management,Data Mining,SAS,Data Analysis Skills,Analytics

Employment Type : Full-Time

Experience : years

Vacancy : 1