DataJobs.io
← Back to all jobs

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

Similar Jobs