Mid-Level Financial Data Analyst

Location: New York City, New York | Duration: 30 Months | Client: NY State - Department of Financial Services | Job ID: SLG - 26 - 12448 | Respond by: 10/13/26 5:00 PM

About the role

Analyst will use Excel, and if needed, statistical packages, to conduct background research related to climate/regulatory topics and support data cleaning and analysis, to analyze New York's climate risk and its impacts to DFS regulated entities and the communities they serve. Analyst will also track Division-wide project progress and completion. These tasks will inform and support policy development.

Responsibilities

• Source, clean, structure data to import to R, Excel; use MS Excel/ statistical packages (R, Stata, python/pandas) to analyze and manipulate data, synthesize and summarize findings in Word for briefing memos.
• Leverage excel and other tools to track and follow-up on division projects.
• Interact/collaborate with DFS staff, and other partners.

Requirements

• Experience (8+ Years) Analyzes an organization or business domain (real or hypothetical) and documents its business or processes or systems, assessing the business model or its integration with technology with distinct deliverables to a solution.
• This is an 100% Onsite.
• 36 months of experience cleaning and organizing data, using Excel.
• 36 months of experience working with large datasets (100K to 1M+ rows) using MS Excel or similar tools.
• 36 months of experience with sourcing publicly available data.
• 24 months of experience using statistical packages, like R, Stata, pandas to analyze data.
• 36 months experience with MS Microsoft Office Suite and Adobe software.
• 24 months of experience tracking and/or coordinating projects.
• Bachelor's Degree in economics, statistics, public policy, climate, or related disciplines.
• 36 months experience working collaboratively in matrixed teams, while managing stakeholder relationships. For example: working on or owning a component of a project with multiple owners, requiring sign-off from separate divisions.
• 12 months of experience in climate-related topics or climate-related financial risks.
• 12 months of experience in financial services (banking, insurance, etc.) related topics.
• Resume
• Copy of Candidate Identification (i.e., Driver s License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)