Analytics Manager, Remote

The company

Mortgage brokers in Washington send us loans to underwrite, close and fund. Since 2012, the firm has administered 401(k) and profit-sharing plans for employers in Washington.

Overview

PKC Financial is looking for an Analytics Manager, Remote to join a small, steady team. We want an analyst who is comfortable pushing back when the numbers don't support the conclusion. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. Our team is spread across 9 countries. Headquarters is in Seattle. We engage team members in Sri Lanka as full-time contractors. Most of our contractors have been with us for more than two years. You will need at least 3 hours of overlap with US Pacific time. Equipment is provided, including a laptop.

Main duties

• Analyse trends, cohorts and funnel drop-off and summarise findings in plain language.
• Prepare weekly and monthly KPI reports for department leads.
• Define metric logic with stakeholders and document it.
• Automate recurring Excel reports with Power Query, Python or scheduled SQL.
• Clean and reconcile data from CRM, ERP and spreadsheet sources.

What we're looking for

• 7+ years of experience in a data or reporting analyst role.
• Strong SQL (joins, CTEs, aggregations, window functions)
• Habit of checking your own numbers before anyone else sees them.

What you get

• Monthly internet allowance.
• Paid time off.
• Flexible hours.

Duration: 6 months. Start: Within 30 days.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at PKC Financial.