Data Analyst

Job Summary

To support Alpaca's data-driven initiatives, the remote Data Analyst will collaborate with cross-functional teams to develop data models, dashboards, and analyses that inform business decisions.

Key responsibilities

• Translate business questions into analytical insights by partnering with cross-functional teams
• Build and maintain analytics data models using SQL and dbt to support financial metrics and dashboards
• Explore data to investigate trends and anomalies, connecting findings to business questions

Required qualifications

• Strong SQL fundamentals, including experience with joins, CTEs, and window functions
• Familiarity with analytics engineering and experience building data models using dbt or similar tools
• Proficiency in Python and Jupyter Notebooks for programmatic data analysis
• Ability to effectively communicate insights to both technical and non-technical stakeholders
• Willingness to learn about the broker-dealer environment and financial accounting standards