J
Data Analyst
Job Description
Data Analyst role in New York, NY (onsite) focused on collecting, cleaning, and analyzing data to support business decisions.
Responsibilities
- Collect and clean data from multiple sources
- Write SQL queries and produce reporting outputs
- Create dashboards and visualizations using Tableau and/or Power BI
- Identify trends and present data-backed insights to stakeholders
- Maintain data accuracy and data quality
Requirements
- Master’s degree in a related quantitative field: Statistics, Mathematics, Computer Science, Economics, Business Analytics, Data Science, or similar
- Strong academic record with coursework in statistics, databases, or data analysis
- 0-2 years of experience in data analysis
- Internships, academic projects, capstones, and research work count
- Strong command of SELECT, JOINs, GROUP BY, subqueries, and CTEs
- Experience with window functions including ROW_NUMBER, RANK, and LAG/LEAD
- Ability to write clean, optimized SQL on large datasets
- Familiarity with relational databases such as PostgreSQL, MySQL, SQL Server, or Oracle
- Advanced Excel formulas including XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS
- Proficiency with pivot tables, pivot charts, and conditional formatting
- Experience with data validation, Power Query, and basic macros
- Knowledge of descriptive statistics: mean, median, variance, standard deviation
- Probability distributions and hypothesis testing including t-test and chi-square
- Understanding of correlation, regression basics, and A/B testing concepts
- Ability to interpret results and communicate them in business terms
- Ability to build clear, accurate charts and dashboards
- Knowledge of visualization best practices and storytelling with data
- Strong written and verbal communication
- Ability to explain technical findings to non-technical stakeholders
- Comfort preparing reports and presentations
Technologies
- SQL, Tableau, Power BI
- PostgreSQL, MySQL, SQL Server, Oracle
- Excel, Power Query
- Python, pandas, NumPy, Matplotlib, Seaborn
- R, tidyverse, ggplot2
- Jupyter notebooks, Git
- Looker
- ETL/ELT
- AWS, Azure, GCP
- Snowflake, BigQuery
Preferred Skills
- Python (pandas, NumPy, Matplotlib, Seaborn) or R (tidyverse, ggplot2)
- Experience with Jupyter notebooks and Git
- Tableau, Power BI, or Looker experience
- Understanding of ETL/ELT processes and data pipelines
- Data cleaning techniques including handling missing values, duplicates, and outliers
- Basic knowledge of data warehousing such as star schema and fact/dimension tables
- Finance or banking data experience including transactions, risk, or customer analytics
- Cloud platforms (AWS, Azure, or GCP) and tools like Snowflake or BigQuery
- GitHub, Kaggle, or personal projects demonstrating end-to-end analysis
Benefits
- 401(k)
- Dental insurance
- Family leave
- Health insurance
- Health savings account
- Life insurance
- Paid holidays
- Parental leave
- Partner benefits
- Relocation assistance
- Visa sponsorship
- Vision insurance
Work Authorization
- F-1 visa holders (OPT/CPT) are eligible to apply
Compensation
- USD 150,000 - 300,000 per year
Core Competencies
- Analytical thinking and structured problem-solving
- Strong attention to detail and commitment to data accuracy
- Ability to manage multiple tasks and meet deadlines
- Collaboration across teams in a fast-paced onsite environment
- Curiosity and willingness to learn new tools and technologies
- Integrity and careful handling of confidential data