Associate Data Analyst

Company Overview Firstrade Securities Inc. is a leading online investment firm dedicated to empowering investors with a comprehensive suite of investment products and innovative tools. Since 1985, Firstrade has prioritized delivering high-quality services, combining cutting-edge trading technology, user-friendly interfaces, and exceptional customer support to meet the diverse needs of investors worldwide. About the Role 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. 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. What You'll Do 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 What We're Looking For (Required) 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) Pay: $65,000.00 - $80,000.00 per year Benefits 401(k) 401(k) matching Dental insurance Disability insurance Employee discount Flexible spending account Health insurance Health savings account Life insurance Paid parental leave Paid time off Parental leave Referral program Vision insurance Application Question(s) Do you need sponsorship in the future? Ability to Commute Flushing, NY 11354 (Preferred) Work Location In person #J-18808-Ljbffr Socket.dev