Senior Data Analyst, Operations

A bit about us:

Clients range from single-location retailers to franchise groups with hundreds of stores, all running our point-of-sale and loyalty software. Ottawa Valley Systems builds scheduling and dispatch software for field service companies, from two-truck plumbing outfits to regional HVAC contractors. Releases go out Tuesday mornings, never on Fridays.

The role:

Ottawa Valley Systems is looking for a Senior Data Analyst, Operations to join a small, steady team. This role supports operations and finance managers with weekly reporting, ad hoc analysis and KPI tracking. The company is based in Calgary, Canada. We are a distributed team spread across a few time zones. You will join as an independent contractor on a long-term agreement. Payment is monthly in USD. You will need at least 4 hours of overlap with US Central time. A stable internet connection and a backup power option are required.

What you'll do:

• Define metric logic with stakeholders and document it
• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Investigate data quality issues and work with data engineering to fix them at the source
• Analyse trends, cohorts and funnel drop-off and summarise findings in plain language
• Build and maintain dashboards in Tableau, Power BI or Looker
• Clean and reconcile data from CRM, ERP and spreadsheet sources

Minimum qualifications:

• 5+ years of experience in a data or reporting analyst role
• Strong SQL (joins, CTEs, aggregations, window functions)
• Experience with at least one BI tool such as Tableau, Power BI or Looker

Desirable:

• Python (pandas) or R for analysis
• Tableau Desktop Specialist or Microsoft PL-300 certification

Why work with us:

Salary range: $1,250 to $1,600 per month

• Monthly internet allowance
• Paid in USD

Duration: 6 months. Start: Within 30 days.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Ottawa Valley Systems.