Data Analyst - SQL / BI (H/F)

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.
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.

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.
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.
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.
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.) 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.

Relevant industry certifications are a plus for example AWS or Azure cloud certifications or data platform certifications like Fabric Snowflakes or Databricks.

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

• 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
• 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.With roots in the dental wholesale and distribution industry Frontier Dental Supply Inc. was formed in 2016. Excellence in Customer Service 2023.

Learn more about what its like to work at Frontier Dental Supply Inc. from our very own employees on our Glassdoor page.
Here at Frontier Dental we are a diverse team that nurtures an inclusive environment. 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.

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.

Senior IC