> Markdown version of [/jobs/ext/1249336-associate-data-analyst](https://www.wearedevelopers.com/jobs/ext/1249336-associate-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Associate Data Analyst - **Company:** Firstrade Securities Inc. - **Location:** New York, NY, United States - **Experience:** Starter - **Salary:** $65,000.0 - $80,000.0 - **Contract:** Internship / Graduate position - **Skills:** Sql Data Warehouse, Microsoft Excel, BigQuery, Databases, Relational Databases, Database Queries, Python (Programming Language), PostgreSQL, MySQL, Pivot Tables, Power BI, Standard Sql, SQL Databases, Tableau (Software), Snowflake, Git, Pandas, Information Technology, Looker Analytics, Software Version Control - **Published:** July 12, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=66d884feda5da7e8 ## About the Role It's an ideal role for someone with 1-2 years of analytics experience - ideally in finance, brokerage, or fintech - who wants to sharpen their technical skills and learn the brokerage business from the inside., * Bachelor's degree in a quantitative or analytical field (e.g., statistics, mathematics, economics, finance, data science, computer science, or similar) * 1-2 years of experience in a data or analytics role (strong internship experience plus ~1 year will be considered) * Solid, demonstrable SQL skills - comfortable with joins, aggregations, and moderately complex queries * Proficiency with Excel or Google Sheets (pivot tables, lookups, formulas) * Strong attention to detail and a habit of double-checking data for accuracy * Ability to take an ambiguous business question and turn it into a concrete data pull * Clear written communication - can explain findings to non-technical stakeholders * Reliable and organized, comfortable managing multiple requests from different teams at once Nice to Have (Preferred) * Experience in finance, brokerage, fintech, or another regulated industry - or relevant coursework * Familiarity with brokerage/trading concepts (equities, options, order flow/PFOF, ACAT transfers, market data) * Python for data work (pandas), or a clear willingness to learn it * Experience with a BI/visualization tool (Tableau, Power BI, Looker, or similar) * Exposure to a relational database or cloud data warehouse (MySQL, PostgreSQL, Snowflake, BigQuery) * Bilingual English/Mandarin Chinese - valuable given our client base * Familiarity with version control (Git) ## Description Firstrade Securities is a U.S. retail brokerage serving investors globally. We're hiring an Associate Data Analyst to support data and reporting needs across the firm - product, marketing, operations, compliance, and executive leadership. This is a hands-on, execution-focused role reporting directly to our senior data analyst, who will mentor you closely. You'll own the recurring reports and dashboards that different teams rely on day to day, handle ad hoc data requests, and grow into more advanced analytical work over time., * Build, maintain, and automate recurring reports and dashboards used by teams across the firm (product, marketing, operations, compliance, and the executive team) * Respond to ad hoc data requests - translating business questions into SQL queries and delivering clear, accurate answers * Write and optimize SQL against the firm's databases, ensuring data is accurate, consistent, and well-documented * QA your own and shared reports, and investigate discrepancies when metrics don't reconcile * Maintain documentation of key metrics, data definitions, and report logic so outputs stay consistent and repeatable * Support the senior analyst on larger strategic, competitive, and regulatory analyses - a structured opportunity to learn higher-level work * Partner with stakeholders across departments to clarify requirements and turn data into something they can act on ## Related Videos - [Microservices architecture as a key element in building trading systems for global finance markets](https://www.wearedevelopers.com/videos/1196-microservices-architecture-as-a-key-element-in-building-trading-systems-for-global-finance-markets) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Advanced Typing in TypeScript](https://www.wearedevelopers.com/videos/496-advanced-typing-in-typescript) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Getting to Know Your Legacy (System) with AI-Driven Software Archeology](https://www.wearedevelopers.com/videos/1437-getting-to-know-your-legacy-system-with-ai-driven-software-archeology) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)