Associate Data Analyst

Who we are

Everyone here does the work. There is no layer of partners selling and juniors delivering. Small projects are welcome, including one-day workshops and short assessments. Training starts with a two-week bootcamp, then continues on the job.

Our Pasadena team is growing and we are hiring an Associate Data Analyst. The operations team needs someone who can write SQL, build dashboards and explain what changed and why. Hybrid: two days in the office in Pasadena, the rest from home.

Main duties

• Prepare weekly and monthly KPI reports for department leads.
• Clean and reconcile data from CRM, ERP and spreadsheet sources.
• Support A/B test readouts with basic statistical checks.
• Investigate data quality issues and work with data engineering to fix them at the source.
• Write SQL queries against the data warehouse to pull and join data for analysis.
• Create forecasts and simple models in Excel or Google Sheets.
• Field ad hoc requests through a ticket queue and prioritize them with your manager.
• Define metric logic with stakeholders and document it.

What we're looking for

• 0-2 years of experience in a data or reporting analyst role.
• Advanced Excel: pivot tables, XLOOKUP, Power Query.
• Experience with at least one BI tool such as Tableau, Power BI or Looker.
• Habit of checking your own numbers before anyone else sees them.

Compensation and benefits

Rate: $73,000 - $85,000 a year

• Health insurance.
• 401(k) with 4% match.
• Paid time off.
• Gym membership reimbursement.
• Free parking.

Interview process: a phone call, a meeting with the hiring manager, and a final conversation with the team.

Start: Within 30 days.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Wright Advisory, LLC.