Sr Visual Basic (VB) Developer / Analyst

Citizens Bank; United States; On-site; USD 105,000 - 140,000; Full time

Benefits offered by this job

Comprehensive medical, dental, and vision coverage

Retirement benefits

Maternity/paternity leave

Education reimbursement

Wellness programs

Job summary

Citizens Bank is hiring an MSR Senior Analyst to support the Mortgage Servicing Rights (MSR) Portfolio Management team. In this role, you will provide critical analytical support for MSR Risk Management, ensuring quality data and resolving issues. Strong experience in finance, data analysis, and programming in SQL and Visual Basic is required.

This full-time position offers a salary between $105,000 and $140,000 per year plus a discretionary bonus, along with comprehensive benefits.

Qualifications

• 3-5 years of experience in Banking or Finance with data analysis.
• Strong computer skills with SQL, VB, and Excel.
• Experience managing cross-functional relationships.

Responsibilities

• Data preparation, modeling, and reporting for MSR Hedge.
• Support MSR transaction data preparation and proforma reporting.
• Ensure data quality and resolve analysis biases.

Skills

Data analysis

Financial modeling

SQL programming

VB programming

Excel proficiency

Problem-solving

Project management

Education

Bachelor’s Degree in Business or quantitative field

Tools

QRM

BlackRock Aladdin

Job description

4 Days in the office from any of our locations in Johnston RI, Iselin NJ, Dallas TX, Nashville TN. Westwood or Medford MA, or Phoenix AZ and couple other locations

Role is not relocation eligible.

The MSR Senior Analyst, reporting to the Mortgage Servicing Rights (MSR) Portfolio Manager, applies prior experience in banking and finance to provide a wide array of analytical support required for strong MSR Risk Management. You're the key player providing data input to the MSR valuation model and distributing mission-critical MSR Hedge results to leaders on a daily basis. Your proficiency with fundamental computer tools such as SQL, Visual Basic Programming/Scripting, Excel-based Macros, and Python (preferred) will ensure quality data with swift troubleshooting of issues. Your role is collaborative with support from our seasoned MSR team with external partnership with several supporting lines (Finance, Accounting, Treasury, Market Risk, Model Validation, and Technology).

Primary Responsibilities

• Data preparation, modeling, analysis, and reporting including daily MSR Hedge P&L.
• MSR Transaction support to include data preparation, PMSR bid preparation, MSR sale selection, proforma reporting of deal impact on MSR P&L and forecast.
• Ensure accuracy of results and analytic methods through testing and validation of underlying report data.
• Ensure bias and data quality issues are resolved or explained.
• Work with team of MSR Valuation Managers to identify and execute process improvements including automation.
• Create, synthesize and present customized data requests, transforming data into a story that informs both high level strategy and tactical decision-making.
• Manage many priorities with minimal oversight. Plan and prioritize to meet deadlines in conditions that may change rapidly or involve ambiguity.

Qualifications, Education, Certifications and/or Other Professional Credentials

• Required Qualifications
  • Bachelor’s Degree in Business or quantitative field (Finance, Science, Engineering, or Math)
  • 3-5 years of professional experience in a Banking or Finance role consisting of data analysis, financial modeling, and reporting.
  • Strong computer skills including basic ability to program in SQL, VB, and Excel
  • Strong problem-solving skills with experience providing insights and recommendations from large data sets
  • Ability to work effectively in a dynamic environment and to adapt while focusing on key goals and objectives
  • Ability to manage and develop cross-functional relationships
  • Project management skills, including the ability to handle multiple projects in a fast-paced environment
• Preferred Qualifications
  • 5+ years professional experience in MSR or mortgage secondary marketing role.
  • Direct experience with MSR or Mortgage Risk Management platforms such as QRM and BlackRock Aladdin.

Hours & Work Schedule

• Hours per Week: 40
• Work Schedule: Monday - Friday

Pay Transparency

The salary range for this position is $105,000 - $140,000 per year plus an opportunity to earn an annual discretionary bonus. Actual pay is based on various factors including but not limited to the work location, and relevant skills and experience.

We offer competitive pay, comprehensive medical, dental and vision coverage, retirement benefits, maternity/paternity leave, flexible work arrangements, education reimbursement, wellness programs and more. Note, Citizens’ paid time off policy exceeds the mandatory, paid sick or paid time-away policy of very local and state jurisdiction in the United States. For an overview of our benefits, visit https://jobs.citizensbank.com/benefits.

Equal Employment Opportunity

Citizens, its parent, subsidiaries, and related companies (Citizens) provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to age, ancestry, color, citizenship, physical or mental disability, perceived disability or history or record of a disability, ethnicity, gender, gender identity or expression, genetic information, genetic characteristic, marital or domestic partner status, victim of domestic violence, family status/parenthood, medical condition, military or veteran status, national origin, pregnancy/childbirth/lactation, colleague’s or a dependent’s reproductive health decision making, race, religion, sex, sexual orientation, or any other category protected by federal, state and/or local laws. At Citizens, we are committed to fostering an inclusive culture that enables all colleagues to bring their best selves to work every day and everyone is expected to be treated with respect and professionalism. Employment decisions are based solely on merit, qualifications, performance and capability.

Equal Employment and Opportunity Employer

Job Applicant Data Privacy Policy

Background Check

Any offer of employment is conditioned upon the candidate successfully passing a background check, which may include initial credit, motor vehicle record, public record, prior employment verification, and criminal background checks. Results of the background check are individually reviewed based upon legal requirements imposed by our regulators and with consideration of the nature and gravity of the background history and the job offered. Any offer of employment will include further information.