Student Data Analyst supporting Sun Life’s financial security mission through stakeholder insights and Tableau KPI reporting. Building data analysis skills during a four - month hybrid campus placement.
About the role
- Data Analyst role at Alpaca utilizing SQL and Python to derive insights and build data models. Collaborating with cross-functional teams to support operations and compliance.
Responsibilities
- Translate 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 compliance.
- 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. 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 time.
- Explore 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 questions.
- Help operationalize data. Identify structural opportunities for standardizing core business entities, proactively transitioning ad-hoc analytical requests into intuitive, user-friendly self-serve environments.
- Assist 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 reports.
Requirements
- 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 without getting lost in rabbit holes.
- Python & 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 analysis.
- Clear Communicator & Collaborator. Can share insights effectively with technical and non-technical partners, acting as a bridge between data infrastructure and business operations.
- Domain Agility. A strong desire to quickly learn the intricacies of a broker-dealer environment, including clearing infrastructure, execution lifecycles, and financial accounting standards.
Benefits
- 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
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.
Data Analyst improving Instacart’s online grocery fulfillment quality through operational analytics. Monitoring retailer performance, diagnosing issues, and delivering recommendations to cross - functional stakeholders.
Web Analyst owning GA4, GTM, pixel, and conversion tracking for an education and nonprofit marketing agency. Ensuring accurate, privacy - compliant data across client campaigns and CRM systems.
Data Analyst supporting client data migrations and corporate actions for Computershare, a global financial administration and transfer agency leader. Ensuring data quality, mapping, validation, and operational sign - off.
Associate Director advancing UJA Toronto’s nonprofit fundraising through donor analytics, predictive modeling, and prospect intelligence. Leading data strategy, pipeline development, and a two - person analytics team.
Sales Force Effectiveness Specialist optimizing territories, targeting and dashboards for GSK, a global biopharma company. Translating sales and market data into actionable commercial insights.
Water and wastewater planning consultant analyzing infrastructure data, forecasting demand, and developing sustainable servicing strategies. Supporting KWL’s consulting engineering projects across Western Canada.
Data analytics intern supporting TD Insurance’s data governance, operational insights, datasets, dashboards, and reporting. Four - month Winter 2027 placement in Montréal or Toronto.