Remote Data Analyst: Brokerage Analytics & SQL

AlpacaJapan Co., Ltd; Rosemont (IL); Remote; USD 70,000 - 100,000; Full time

Benefits offered by this job

Competitive Salary & Stock Options

New Hire Home‑Office Setup: One‑time USD $500

Monthly Stipend: USD $150

Job summary

AlpacaJapan Co., Ltd in Rosemont, Illinois is seeking a Data Analyst to drive data analysis and reporting within the company. The ideal candidate will collaborate closely with various teams, focusing on building data models and providing actionable insights.

Strong SQL skills are essential, along with experience in analytics engineering and Python. Benefits include a competitive salary, stock options, and stipends for home office setup. Join a mission-driven team dedicated to democratizing financial services worldwide.

Qualifications

• Strong SQL fundamentals with joins, CTEs, and window functions.
• Prior experience in building analytical data models or metrics tables.
• Ability to forecast and explore data insights effectively.

Responsibilities

• Translate ambiguous questions into analytical insights.
• Build and own analytics data models using SQL.
• Automate reporting capabilities and streamline processes.

Skills

Strong SQL fundamentals

Analytics Engineering Familiarity

Deep Analytical Intuition

Python & Notebook Proficiency

Clear Communicator & Collaborator

Domain Agility

Tools

PostgreSQL

Trino

Apache Iceberg

dbt

Jupyter Notebooks

Python (Pandas, NumPy)

Job description

AlpacaJapan Co., Ltd in Rosemont, Illinois is seeking a Data Analyst to drive data analysis and reporting within the company. The ideal candidate will collaborate closely with various teams, focusing on building data models and providing actionable insights.

Strong SQL skills are essential, along with experience in analytics engineering and Python. Benefits include a competitive salary, stock options, and stipends for home office setup. Join a mission-driven team dedicated to democratizing financial services worldwide.