Clear Street
is hiring
Data Analyst
About Our Company
Clear Street is building financial infrastructure for today's institutions. Clients of all sizes use our clearing, custody, execution, and prime brokerage platform to operate their businesses.
The financial industry still relies on outdated technology developed in the 1970s. 50-year-old COBOL mainframes are still in use today , creating a number of complex problems. Over time, firms built new technology on top of antiquated technology. This process is not only frustrating and inefficient—it kills profit margins and can blow up a firm.
This is where Clear Street comes in.
Clear Street started from scratch by building a completely cloud-native, clearing and custody system designed for today’s complex, global market. Our mission is to build a modern, single source-of-truth platform capable of handling every asset class, in every country, and in any currency.
Products and services offered by Clear Street LLC, member FINRA and SIPC. Additional information about Clear Street is available on FINRA BrokerCheck including its Customer Relationship Summary. Copyright © 2023 Clear Street LLC. All rights reserved. CLEAR STREET and the Shield Logo are Registered Trademarks of Clear Street LLC.
Job Description & Responsibilities
We are looking for a Data Analyst to work in the Data Analytics team, a part of the engineering division. This role will be focused on working closely with business stakeholders, 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 empowers 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
The Team:
Our team is composed of highly motivated and capable information professionals. The team seeks to support data-driven decision making by providing information to key stakeholders. As a member of the DATA team, you will interact with colleagues across the firm, from engineering to the business. We strive to be collaborative and supportive of your personal and professional growth.
Requirements
Requirements:
- At least 2 years of professional 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:
Snowflake, Sigma Computing, SQL, Python
What we offer
We offer:
- The opportunity to join a small and growing team of self-driven and highly motivated individuals
- Chance to learn about the prime brokerage business and have an impact
- A meritocratic philosophy that champions collaboration
- Room to innovate, solve complex business problems and build new products
- Competitive compensation, benefits, and perks
The Base Salary Range for this role is $70,000- $110,000. This range is representative of the starting base salaries for this role at Clear Street. Where a candidate falls in this range will be based on job related factors such as relevant experience, skills, and location. This range represents Base Salary only, which is just one element of Clear Street's total compensation. The range stated does not include other factors of total compensation such as bonuses or equity.
At Clear Street, we offer competitive compensation packages, company equity, 401k matching, gender neutral parental leave, and full medical, dental and vision insurance. Our belief has always been that we are better as a business when we are all together in person. As such, beginning on January 2, 2023, we are requiring employees to be in the office 4 days per week. In-office benefits include lunch stipends, fully stocked kitchens, happy hours, a great location, and amazing views.
Our top priority is our people. We’re continuously investing in a culture that promotes collaboration. We help each other through challenges and celebrate each other's successes. We believe that modern workplaces succeed by virtue of having high-performance workforces that are diverse — in ideas, in cultures, and in experiences. We put in the effort to make such a workplace a daily reality and are proud to be an equal opportunity employer.
