Project overview
About the Client: Our client is an independent, non-bank prime broker designed to solve the industry’s most neglected problem: legacy technology. They have a proprietary, cloud-native clearing and custody system from the ground floor to replace the outdated infrastructure used across capital markets. The role: We are looking for a Data Analyst for our client to work in their Data Analytics team, a part of the engineering division. This role will focus on working closely with business stakeholders and helping to facilitate their access to the firm’s data via cloud-based data warehousing and BI tools, Excel, and SQL. Basic Python knowledge is required for this role to help automate the running of SQL scripts. You will: Work closely with business stakeholders like Finance, Operations, Compliance, Sales & Trading to generate business insights that empower decision-making Build queries, reports, and interactive dashboards using the Sigma Computing BI tool Promote adoption of the BI tool and help build proficiency in it across the organization Query the Snowflake data warehouse using SQL Learn and adopt software engineering lifecycle best practices for creating and maintaining business critical reports Contribute to the growth, process improvement, and the general operation of the team and company Requirements: 2+ years of experience working with data, preferably in the finance sector Experience using BI tools to query data and create visualizations Experience with Snowflake data warehouse or a BI tool like Sigma Computing Experience with Excel or Google Sheets, specifically lookup functions, charting, and pivot table creation Understanding of data modeling and data warehousing principles Proficiency with SQL querying Familiarity with Python Bonus: Experience in prime brokerage Understanding of equities, options, fixed income, and other securities Familiarity with querying a REST API using a visual tool like Postman or Insomnia Basic familiarity with version control systems and tools like GitHub Tech Stack: Required: Snowflake, Sigma Computing, SQL, Python, DBT Can have experience with similar technologies like Tableau, Microsoft Power BI, etc.