Data Analyst

Smith Arnold Partners; Stamford (CT); Hybrid; USD 100,000 - 115,000; Full time

Job summary

Smith Arnold Partners in Stamford, CT is seeking a Data Analyst to join a fast-paced financial services environment. This hybrid role combines data analysis, regulatory reporting oversight, and compliance controls to improve processes and testing.

You will review regulatory data, develop data-driven controls, and automate routines with SQL and scripting. Strong Excel and UNIX experience are valued, with eligibility for bonus and equity.

Qualifications

• Bachelor’s degree is required, preferably in a quantitative or analytical field.
• 1–3 years of experience in data analysis, compliance, operations, audit, or finance.
• Experience in an analytical role, preferably in the financial sector.
• Strong data analysis, investigation, and problem-solving skills.
• Experience performing data analysis using programming languages (e.g., Python, Perl, or Go) and database queries (e.g., SQL).
• Regulatory research and interpretation skills preferred.
• UNIX experience, or ability to learn the operating system.
• Experience using Atlassian systems (e.g., Confluence and JIRA) is a plus.
• Strong Excel skills (e.g., pivot tables, CAT/OATS)

Responsibilities

• Review regulatory data to identify root causes and remediation needs.
• Use UNIX command tools to correct records.
• Develop surveillance for regulatory reporting and operational data.
• Automate the CAT business system.
• Follow up with software developers/management on errors.
• Gather facts to assist examinations and inquiries.
• Propose improvements to controls over regulatory reporting.
• Perform ad hoc analysis and supervisory reviews as needed.

Skills

Data analysis

Problem solving

Investigative skills

Education

Bachelor’s degree

Tools

Python

Perl

Go

SQL

UNIX

Confluence

JIRA

Excel

Job description

Are you a data analyst who enjoys investigating data issues, solving complex problems, and working in a fast-paced financial services environment? Would a role combining data analysis, regulatory reporting oversight, compliance controls, and process improvement be appealing to you? If so, this role could be for you!

See what people are saying about working here:

• “Senior Management is top shelf!”
• “Great opportunity to work with successful publicly traded company”
• “Located in attractive Fairfield County environs.”
• “Excellent training on new technologies!”, “Great fringe benefits!”

Title: Data Analyst - Hybrid

Salary: $100,000 - $115,000 + Bonus & Equity Eligible

Location: Stamford, CT

A successful and growing publicly traded financial services organization is seeking an experienced Data Analyst with data analysis experience, preferably from a similar industry. This is an operational and oversight function involving evaluating regulations, researching, and analyzing data, understanding technical implementations of systems, and creating control procedures to test compliance.

Responsibilities

• Responsibilities for the Data Analyst will include reviewing regulatory data to identify root causes and necessary remediation for errors
• Utilizing UNIX command tools to make corrections to records as needed
• Developing surveillance for regulatory reporting and operational data
• Automating the Consolidated Audit Trail (CAT) business system.
• Following up with software developers and/or management on any errors or exceptions that arise
• Gathering facts to assist the firm in responding to examinations and formal inquiries
• Proposing improvements to, or additional controls over, regulatory reporting
• Perform ad hoc analysis and supervisory reviews as needed.

Qualifications

• Bachelor’s degree is required, preferably in a quantitative or analytical field.
• 1-3 years of experience in data analysis, compliance, operations, audit, or finance.
• Experience in an analytical role, preferably in the financial sector.
• Strong data analysis, investigation, and problem-solving skills.
• Experience performing data analysis using programming languages (e.g., Python, Perl, or Go) and database queries (e.g., SQL)
• Regulatory research and interpretation skills preferred.
• UNIX experience, or ability to learn the operating system.
• Experience using Atlassian systems (e.g., Confluence and JIRA) is a plus.
• Strong Excel skills (e.g., pivot tables, FINRA Consolidated Audit Trail (“CAT”) / Order Audit Trail (“OATS”) systems.