Associate Data Analyst

Bank of Puget Sound is looking for an Associate Data Analyst 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. On site, Los Angeles.

Job duties

• Support A/B test readouts with basic statistical checks
• Define metric logic with stakeholders and document it
• Present results to managers and answer follow-up questions
• Prepare weekly and monthly KPI reports for department leads
• Field ad hoc requests through a ticket queue and prioritize them with your manager
• Write SQL queries against the data warehouse to pull and join data for analysis
• Create forecasts and simple models in Excel or Google Sheets
• Investigate data quality issues and work with data engineering to fix them at the source

Qualifications

• 1-2 years of experience in a data or reporting analyst role
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Bachelor's degree in statistics, economics, business, math or a related field
• Strong SQL (joins, CTEs, aggregations, window functions)
• Clear written and verbal communication with non-technical stakeholders
• Able to juggle several requests and say when a deadline isn't realistic

What you get

Pay: $71,000 - $86,000/year

• Health, dental and vision coverage starting on day one
• Life insurance
• Medical, dental and vision insurance
• Paid time off
• Annual bonus
• Paid sick leave
• Employee assistance program

A bit about us

Our president works out of the main branch and knows most business customers personally. Every teller is cross-trained on new accounts, cashier's checks and safe deposit boxes. New tellers spend two weeks in classroom training before working a drawer.

Bank of Puget Sound is an Equal Opportunity Employer, including disability and protected veteran status.

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Bank of Puget Sound.