Business Analyst

APR Staffing

Beaverton (OR)

On-site

USD 70,000 - 110,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

APR Staffing seeks a Business Analyst (BA) to review and validate complex allocation plans in securities and related financial documentation. You will translate requirements for developers, guide stakeholders, and mentor junior BAs while coordinating with Project Managers and Data Analysts.

The role requires 3+ years in BA or related roles with securities knowledge, strong Excel and SQL skills, and excellent communication to support client services and project teams in a fast-paced environment.

Qualifications

  • Four-year college degree in Finance or Economics.
  • 3+ years' experience as Business Analyst or related roles with securities knowledge.
  • Proficient in MS Office tools, particularly Excel.
  • Experience with relational databases and the ability to read/write SQL.
  • Understanding of data modeling and data organization.
  • Ability to meet deadlines in a dynamic environment.
  • Excellent verbal and written communication.

Responsibilities

  • Understand the lifecycle of a class action or settlement data and define data requirements for the Plan of Allocation.
  • Develop, publish and validate specifications for the calculation module.
  • Design documents detailing data mappings for electronic filers.
  • Investigate and review large or potentially fraudulent or invalid claims.
  • Query, assess and analyze data using Excel, SQL Server, Oracle.
  • Liaise between Client Services and Tech Ops to keep work flowing.
  • Lead or participate in testing and validation of the calculation module.
  • Interact professionally with team members and stakeholders.
  • Log time accurately against project work.

Skills

SQL proficiency
Data analysis
Communication skills
Time management

Education

Bachelor's degree in Finance or Economics

Tools

SQL Server
Oracle
Excel

Job description

The position Business Analyst (BA), Client Services is responsible for the review, and validation of both simple and complex plans of allocation in securities or antitrust administrations. The BA acts as a consultant to the Project Managers and Project Coordinators, providing insight and direction based on their experience and understanding of securities and financial instruments.

The BA has a working knowledge of securities, including how they can impact calculations and data used in the administration of a settlement. The BA will have familiarity with financial documentation and review documentation submitted in support of a claim. The BA is responsible for understanding the requirements of a particular case and determining the handling of those securities in relation to not only the Plan of Allocation, but also deficiency noticing and general class member and client communications. The BA will utilize their skill set to guide communication with with stakeholders to gather and document requirements for large institutional filers. The BA is responsible for communicating these scenarios to the Project Manager and Project Coordinators. The BA may be required to translate functional requirements into requests from which developers can program and update the Plan of Allocation and the Senior BA will test and validate the results of each calculation module to ensure that it is properly applying the Plan of Allocation. The BA works directly with Project Managers, Project Coordinators, Data Analysts, QC Analysts, other BAs, department Team Leads, and other operational teams to understand all aspects of the case and to determine and document the data oriented solution.

Job Responsibilities
  • Understand the entire lifecycle of a class action or similar matter, determine what data is required based on settlement requirements, and define how that data and business rules will translate to the Plan of Allocation applications. This may include the review of corporate SEC filings for activity which could affect trading history.
  • Develop, publish and validate specifications, requirements, and other documentation, as required, specifically as it relates to the calculation module.
  • Design or oversee design of documents which provide data mappings and procedural descriptions for use by electronic filers for loading of electronically filed data.
  • Independently investigate and provide critical review of large (either in number of transaction or size of loss), potentially fraudulent or invalid claims, including the review of underlying documents provided to validate the claim submission.
  • Using tools such as Excel, SQL Server, Oracle, and others, directly query, assess, and analyze data to ensure requirements are being met.
  • Serve as liaison between Client Services (business) and Tech Ops (technical) to keep production work flowing smoothly. Help guide and mentor less experienced BAs in this capacity.
  • Lead, conduct, or consult in testing and validation of the calculation module to ensure results are acceptable and meet requirements.
  • Interact and correspond professionally with team members, project management, and other stakeholders.
  • Account for and accurately log time against project work.
Required Qualifications & Characteristics
  • Four-year college degree in Finance or Economics
  • 3+ years' experience as Business Analyst, Data Analyst, Process Specialist, or other roles where knowledge in Securities products and building business functional requirements are captured and decomposed.
  • Proficient in MS Office tools, particularly Excel.
  • Experience with relational databases and the ability to read and write moderately complex SQL.
  • Understanding of data modeling and data organization. Ability to analyze data sets from external sources and map to an established relational data model.
  • Ability to work in an environment with deadlines and shifting priorities.
  • Excellent verbal and written communication skills with a professional, calm demeanor
Pre-Employment Requirement

All employment offers are contingent upon successful completion of our pre-employment screening that may include drug testing, background/criminal check, and if applicable, must meet eligibility requirements for access to classified information.

APR Staffing is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

About APR Staffing

APR Staffing was born from the merger of two well-respected technical staffing firms in Portland. ieSolutions and Data Resource Group. Both companies have been recent award winners for the Portland Business Journal's Fastest-Growing Private Companies. The two firms, now as APR Staffing, make for one of the fastest-growing and most-respected professional and technical staffing companies in Oregon and Southwest Washington.

Collaborating with our customers, we augment their workforce with technical and administrative professionals. We provide only high-caliber, professional-grade resources throughout the Pacific Northwest.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Business Analyst
Remote Business Analyst

Raise - find a more meaningful working experience • United States

Remote
USD 41,000 - 58,000
Business/Financial Analyst
Business/Financial Analyst

Paradigm Information Services • United States

Remote
USD 47,000 - 54,000
Medical
Dental
Vision
+4
Business/Financial Analyst
Business/Financial Analyst

Paradigm Information Services, Inc. • Portland (OR)

Remote
USD 41,000 - 58,000
Medical
Dental
Vision
+4
Technical Business Analyst 2
Technical Business Analyst 2

APR Staffing • Portland (OR)

Hybrid
USD 85,000 - 105,000
Flexible working hours
Career development opportunities
Health benefits
Business Analyst
Business Analyst

Artech LLC. • St. Louis (MO)

On-site
USD 80,000 - 100,000
Business Analyst
Business Analyst

PSG Global Solutions • Woodbridge Township (NJ)

On-site
USD 80,000 - 100,000
Business Analyst
Business Analyst

105 AllianceBernstein LP. • Nashville (TN)

On-site
USD 80,000 - 110,000
Business Analysis Manager
Business Analysis Manager

Plymouth Rock Assurance • Boston (MA)

On-site
USD 120,000 - 150,000
Business Analyst
Business Analyst

AllianceBernstein • Nashville (TN)

On-site
USD 70,000 - 110,000
Junior Business Analyst
Junior Business Analyst

PSG Global Solutions • Charlotte (NC)

On-site
USD 70,000 - 90,000