Data Analyst I (Operations)

Mortgage brokers in Kanagawa send us loans to underwrite, close and fund. Dress is business casual, and suits come out for client meetings.

We have an immediate opening for a Data Analyst I (Operations) in Yokohama. This role supports operations and finance managers with weekly reporting, ad hoc analysis and KPI tracking. Hybrid. You will need to be in Yokohama at least two days per week.

Day to day:

• Clean and reconcile data from CRM, ERP and spreadsheet sources
• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Write SQL queries against the data warehouse to pull and join data for analysis
• Investigate data quality issues and work with data engineering to fix them at the source

Skills and experience:

• 0-2 years of experience in a data or reporting analyst role
• Clear written and verbal communication with non-technical stakeholders
• Advanced Excel: pivot tables, XLOOKUP, Power Query
• Habit of checking your own numbers before anyone else sees them

Bonus points:

• Salesforce or NetSuite reporting
• Google Analytics 4 or Adobe Analytics
• Dbt or Snowflake

What we offer:

Compensation: ¥3,700,000 - ¥4,700,000 a year

• Flexible hours
• Remote work allowed

Duration: 6 months. Start: Immediately.

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