Financial Data Analyst - Operations

MISCHLER; Irvine (CA); On-site; USD 90,000 - 110,000; Full time

Benefits offered by this job

401(k)

Medical, Dental, Vision, LifeInsurance

Employee Assistance Program (EAP)

Job summary

Mischler Financial Group, Inc. in Irvine, CA is seeking a Financial Data Analyst - Operations to join our in-office team.

You will perform data analysis and reporting to support business decisions, develop reports, and maintain trading and operations data platforms. The ideal candidate has strong Excel, Access/SQL, and Python skills, familiarity with FINRA/SEC reporting, and experience in broker-dealer operations.

Qualifications

• Bachelor's degree in computer programming, finance, business administration, or MIS.
• 5+ years of experience in operations, information technology, or finance in the broker-dealer or financial services sector.
• Advanced IT and programming skills.
• Knowledge of FINRA, SEC, MSRB, NFA regulations.
• Strong analytical skills to interpret complex data and identify trends.
• Ability to work independently and in a fast-paced environment with integrity.

Responsibilities

• Provide data analysis and reporting to support informed business decisions.
• Collaborate to define requirements for new reports and enhance existing ones.
• Create and enhance daily/monthly reports using Access/SQL, Excel, and other tools.
• Develop and maintain software and scripts for automation.
• Support operations team and systems with technical guidance.
• Develop advanced tools for trade clearing and settlement.
• Provide internal reporting for operations, accounting, and management.
• Prepare reporting for FINRA, SEC, MSRB, NFA regulators.
• Support and maintain critical trading platforms and information systems.
• Lead special projects like business process reviews and automation.

Skills

Advanced Excel (pivot, vlookup, macros

MS Access & SQL Server

Python

Instinet

Bloomberg TOMS

FINRA TRACE/TRAQS reporting

MS Office

Trade processing, clearing, settlement

Excellent verbal and written skills

Time management and prioritization

Attention to detail and follow-through

Education

Bachelor's degree in computer programming, finance, business administration, or MIS

Tools

Instinet

Bloomberg TOMS

FINRA TRACE/TRAQS reporting

MS Office

Job description

Financial Data Analyst - Operations

Mischler Financial Group, Inc.

Irvine, CA 92612

Benefits

• 401(k)
• Medical, Dental, Vision, Life Insurance
• Employee Assistance Program (EAP)

Title: Financial Data Analyst - Operations

Status: Exempt, Full-time - In-office position

Location: Irvine, CA 92612

Reports To: CFO, Co-CCO

General Description: Established in 1994, Mischler Financial Group, Inc. (MFG) is the securities industry’s oldest diversity-certified broker-dealer owned and operated by service-disabled veterans (SDVs). Our core competencies include securities sales and trading (equities, options, fixed income, FX), investment banking and underwriting services for primary debt and equity capital market transactions. Our mission is to preserve and protect the interests of those that we serve. We leave no client behind.

Essential Duties and Responsibilities: MFG is seeking a detail-oriented Financial Data Analyst to join the firm. In this role, you will perform various operations, data aggregation, data analysis, and software programming projects and functions. Additional responsibilities may include business process review and automation, as well as various operations and compliance projects as assigned.

The ideal candidate will have experience in the securities industry with a broker-dealer and understand fundamental reporting and regulatory requirements.

Responsibilities

1. 1. Perform data analysis and reporting to support effective business decisions
2. 2. Collaborate to develop requirements for new reports and enhance existing reports
3. 3. Create and enhance daily/monthly reports using Access/SQL, Excel, and other tools
4. 4. Develop and maintain various software and scripts
5. 5. Provide technical support for the operations team and systems
6. 6. Develop advanced tools for trade clearing and settlement
7. 7. Provide internal reporting for operations, accounting, and management
8. 8. Provide reporting for various regulatory agencies, including FINRA, SEC, MSRB, NFA
9. 9. Support and maintain critical trading platforms and information systems
10. 10. Perform special projects such as business process review and automation

Job Skills & Qualifications

1. 1. Preferred, not required, FINRA licenses: SIE, 7, and 63
2. 2. Advanced proficiency in:
   • Microsoft Excel (pivot, vlookup, macros, VBA)
   • MS Access and SQL Server
   • Python
3. 3. Proficiency in:
   • Instinet, Bloomberg TOMS
   • FINRA TRACE/TRAQS reporting
   • MS Office
   • Trade processing, clearing, settlement
4. 4. Excellent verbal and written communication skills.
5. 5. Ability to respond promptly, organize tasks, manage time, and prioritize requests.
6. 6. Attention to detail and follow-through skills.

Qualifications

1. 1. Bachelor's degree in computer programming, finance, business administration, or management information systems.
2. 2. 5+ years of experience in operations, information technology, or finance in the broker-dealer industry or financial services sector.
3. 3. Advanced information technology and programming skills.
4. 4. Knowledge of securities regulations, including FINRA, SEC, MSRB, NFA.
5. 5. Excellent analytical skills with the ability to interpret complex data sets and identify trends, patterns, and anomalies.
6. 6. Ability to work independently and collaboratively in a fast-paced and dynamic environment, with a commitment to professionalism, integrity, and ethical conduct.

Compensation: Range $90K to $110K based on experience.