[Remote] Data Analyst

Note: The job is a remote job and is open to candidates in USA. Alpaca is a US-headquartered self-clearing broker-dealer and brokerage infrastructure company. They are seeking a Data Analyst to help make data-driven decisions by building data models, dashboards, and conducting analyses in collaboration with various departments.ResponsibilitiesTranslate questions into insight. Partner and embed with cross-functional teams to turn ambiguous business and operational questions into clear, useful analytical outputs. You will quickly assimilate subject matter expertise across brokerage operations, ledger systems, and complianceBuild and own analytics data models. Write clean, maintainable SQL against PostgreSQL, Trino, and Apache Iceberg to power core financial metrics, dashboards, and analytical workflowsBuild and iterate on metrics and tables. Build and iterate on metrics and tables using dbt, surfacing them through dashboards in Metabase to help teams understand transaction volumes, revenue streams, and system performance over timeExplore data deeply to answer open-ended questions. Use SQL as your primary tool, with Python in a notebook environment like Jupyter when helpful, to investigate trends, anomalies, complex profit and loss (P&L) calculations, and trading behaviors, connecting analyses back to real business questionsHelp operationalize data. Identify structural opportunities for standardizing core business entities, proactively transitioning ad-hoc analytical requests into intuitive, user-friendly self-serve environmentsAssist with reporting capabilities and streamline report automation, including servicing requests in a timely manner, cataloguing recurring reports, and driving conversations around standardization and productization of data reportsSkillsStrong SQL fundamentals. Comfortable with joins, CTEs, window functions, and clear query structure across diverse database environmentsAnalytics Engineering Familiarity. Prior exposure to building analytical data models or metrics tables using dbt or similar analytics-engineering workflowsDeep Analytical Intuition. Able to ask the right questions, explore data thoughtfully, and synthesize clear, well-reasoned conclusions without getting lost in rabbit holesPython & Notebook Proficiency. Comfortable using SQL as the primary analysis tool, with the ability to use Python (Pandas, NumPy) and Jupyter Notebooks for deeper, more efficient programmatic analysisClear Communicator & Collaborator. Can share insights effectively with technical and non-technical partners, acting as a bridge between data infrastructure and business operationsDomain Agility. A strong desire to quickly learn the intricacies of a broker-dealer environment, including clearing infrastructure, execution lifecycles, and financial accounting standardsBenefitsCompetitive Salary & Stock OptionsHealth BenefitsNew Hire Home-Office Setup: One-time USD $500Monthly Stipend: USD $150 per month via a Brex CardCompany OverviewAlpaca is a financial system platform that allows developers and businesses to build apps, embed investing, and trade algorithms. It was founded in 2015, and is headquartered in Tokyo, Tokyo, JPN, with a workforce of 201-500 employees. Its website is https://alpaca.markets/jp/.Company H1B SponsorshipAlpaca has a track record of offering H1B sponsorships, with 2 in 2020. Please note that this does not guarantee sponsorship for this specific role.