- Salary
- Salary not disclosed
- Experience
- Fresher friendly
- Job type
- Full-time
- Location
- New York City, United States (Hybrid)
Allegheny FinancialVerified companyNew York City, United States (Hybrid)19 Nov 2026
This job includes an online test
You'll take it right after applying — about 60 minutes. It is proctored: you'll need a camera and must stay on the test screen.
The company
Mortgage brokers in New York send us loans to underwrite, close and fund. Founded in 1983, we now have 170 employees.
Overview
We need a Data Analyst II. This is a full-time position based in New York City, New York. The Revenue Operations team needs someone who can write SQL, build dashboards and explain what changed and why. We work hybrid out of New York City, usually three days in, two days remote.
Your responsibilities
Clean and reconcile data from CRM, ERP and spreadsheet sources. Investigate data quality issues and work with data engineering to fix them at the source. Analyze trends, cohorts and funnel drop-off and summarize findings in plain language. Create forecasts and simple models in Excel or Google Sheets.
Skills and experience
3+ years of experience in a data or reporting analyst role. Bachelor's degree in statistics, economics, business, math or a related field. Strong SQL (joins, CTEs, aggregations, window functions). Clear written and verbal communication with non-technical stakeholders. Basic statistics: averages vs. medians, distributions, significance.
Why work with us
Compensation: $96,000 - $113,000 a year
Medical, dental and vision insurance. 401(k) with 4% match. Paid time off. Profit sharing. Employee assistance program. Paid holidays.
Allegheny Financial is an Equal Opportunity Employer, including disability and protected veteran status.
Start: Flexible.
Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Allegheny Financial.
Allegheny Financial · Financial Services
Nair BenefitsVerified company
Fishers AssociatesVerified company
Thomas PlumbingVerified company
JH DataVerified company
BisonhookVerified company
Russetloop Media LLCVerified company