Business Analyst or Data Analyst

Role: Data Scientist Location: NYC, NY | Toronto, ON Duration: Long Term Specification: We’re looking for a contractor who sits between a Business Analyst and a Junior Data Scientist, focused on product analytics, financial analysis, and ad-hoc data reporting for card programs. This is not a Data Engineer or senior DS role; we need someone who is strong in SQL, analytical thinking, and building usable insights—not designing pipelines or doing ML research. This person will support product strategy and client-facing analytics with tasks. Ideal Candidate should have experience on the below:.- • 5-8 years of experience in analytics roles • Worked as a Product Analyst, Business Analyst, Data Analyst, or Junior Data Scientist • Significant time writing SQL and working with real-world messy datasets • Some exposure to financial or transaction data (ideal but not required) • Strong communication skills—they should be able to explain what the numbers mean Required Skills 1. SQL (must-have, non-negotiable) • Strong hands-on SQL for data analysis (joins, window functions, aggregations, date/time logic) • Experience working in a cloud data warehouse (Snowflake, Redshift, BigQuery, etc.) 1. Analytical & Business Problem-Solving • Comfortable turning fuzzy product questions into structured analyses • Ability to interpret financial/card-program data (transactions, declines, fees, etc.) Preferred Skills (Nice-to-Have) Snowflake experience • Exposure to Snowflake-specific SQL or warehouse concepts is ideal but not required Python for analytics • Useful for deeper explorations, forecasting, or lightweight data modeling • Not a requirement BI visualization tools • Tableau or Looker strongly preferred • Experience building dashboards, simple visualizations, or metric tracking reports Payments / Card Programs domain knowledge • Experience working with banking data, card transactions, or fintech analytics • Understanding of digital wallets, auth flows, or settlement data is a plus