Role in brief
Alpaca, a financial services company, is hiring a Data Analyst to translate business questions into analytical outputs. This role involves building and maintaining data models, creating dashboards, and exploring data to provide insights into brokerage operations. Candidates with strong SQL skills, experience with analytics engineering tools like dbt, and proficiency in Python for data analysis should apply.
About the role
This Data Analyst position focuses on transforming business and operational inquiries into actionable analytical insights. The role involves close collaboration with various teams to understand their needs and deliver clear, useful data-driven solutions. A key part of the work will be developing and owning analytics data models to support core financial metrics and analytical workflows.
The successful candidate will be responsible for building and iterating on metrics and tables using dbt, then visualizing these through dashboards in Metabase. This includes writing clean, maintainable SQL for different database environments. The role also requires deep data exploration using SQL and Python in notebook environments to answer open-ended business questions.
Success in this role means not only delivering insights but also identifying opportunities to standardize core business entities to operationalize data more effectively. The analyst will also contribute to improving reporting capabilities and automating report generation, ensuring data is accessible and useful across the organization.
The annual salary for this position is between $68,000 and $112,000 USD.
Skills that matter here
- SQL: This role requires strong SQL fundamentals for building data models, querying diverse databases, and performing in-depth data exploration.
- dbt: Familiarity with dbt is needed for building and iterating on metrics and tables as part of analytics engineering workflows.
- Python: Python, along with libraries like Pandas and NumPy, will be used in notebook environments for data exploration and analysis.
- Metabase: The analyst will use Metabase to surface metrics and tables through dashboards for various stakeholders.
- PostgreSQL: Experience with PostgreSQL is required for writing SQL against this database to power financial metrics and analytical workflows.
- Jupyter Notebooks: Proficiency with Jupyter Notebooks is necessary for conducting data exploration using SQL and Python.
Who this role suits
- A person who thrives on translating ambiguous business problems into clear, data-driven solutions.
- Someone with a strong analytical intuition who can thoughtfully explore data and synthesize well-reasoned conclusions.
- An individual who can communicate complex insights effectively to both technical and non-technical audiences.
- A candidate eager to quickly learn and adapt to the intricacies of a broker-dealer environment.
From the employer
What You'll Do
- Translate questions into insight. Partner and embed with cross-functional teams to turn ambiguous business and operational questions into clear, useful analytical outputs.
- Build and own analytics data models. Write clean, maintainable SQL against PostgreSQL, Trino, and Apache Iceberg to power core financial metrics, dashboards, and analytical workflows.
- Build and iterate on metrics and tables using dbt, surfacing them through dashboards in Metabase.
- Explore data deeply to answer open-ended questions using SQL and Python in a notebook environment like Jupyter.
- Help operationalize data by identifying structural opportunities for standardizing core business entities.
- Assist with reporting capabilities and streamline report automation.
What We're Looking For
- Strong SQL fundamentals. Comfortable with joins, CTEs, window functions, and clear query structure across diverse database environments.
- Analytics Engineering Familiarity. Prior exposure to building analytical data models or metrics tables using dbt or similar analytics-engineering workflows.
- Deep Analytical Intuition. Able to ask the right questions, explore data thoughtfully, and synthesize clear, well-reasoned conclusions.
- Python & Notebook Proficiency. Comfortable using SQL as the primary analysis tool, with the ability to use Python (Pandas, NumPy) and Jupyter Notebooks.
- Clear Communicator & Collaborator. Can share insights effectively with technical and non-technical partners.
- Domain Agility. A strong desire to quickly learn the intricacies of a broker-dealer environment.
How We Take Care of You
- Competitive Salary & Stock Options
- Health Benefits
- New Hire Home-Office Setup: One-time USD $500
- Monthly Stipend: USD $150 per month via a Brex Card
Alpaca is proud to be an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce.
Questions about this role
What is the remote work policy for this role?
This is a fully remote position.
What is the salary range for this position?
The salary for this role ranges from $68,000 to $112,000 USD annually.
What are the key technical skills required?
Key technical skills include strong SQL, familiarity with analytics engineering tools like dbt, and proficiency in Python with Pandas and NumPy for data analysis in Jupyter Notebooks.