Reporting and Business Analyst

Socket.dev; Elmwood Park (NJ); On-site; USD 75,000 - 115,000; Full time

Benefits offered by this job

Holidays

Vacation

Health/Dental

Vision Service Plan

Short Term Disability

Long Term Disability

Life Insurance

Flexible Spending Accounts

401k Savings Plan

Tuition Reimbursement

Employee Assistance Program

Free Employee Checking Account

Job summary

Socket.dev in New Jersey is seeking a Reporting and Business Analyst to develop, maintain, and analyze financial and management reporting that supports informed decision-making across the Bank.

The role partners with Reporting, Treasury, and Information Technology in gathering, processing and translating business requirements, validate data, improve reporting processes, and deliver reliable reporting and insights.

Qualifications

• Bachelor's degree in finance, accounting, economics, MIS, or related field.
• Two to four years in accounting, treasury, financial reporting, or banking preferred.
• Strong proficiency in Microsoft Office and BI tools, data gathering and analytical skills.

Responsibilities

• Gather, document, and validate reporting requirements with stakeholders.
• Prepare daily/weekly/monthly source files for reporting systems.
• Create and maintain queries and ALCO applications for financial reporting.
• Review daily reports for accuracy and monitor cash positions.
• Support Treasury transactions and automate reporting workflows.

Skills

Data analysis

Advanced Excel

PowerPoint

Communication

Problem solving

Education

Finance/Accounting/Economics degree

Tools

SQL

VBA/Power Query

Tableau

Power BI

Qlik

Excel

PowerPoint

Job description

BASIC FUNCTION

The Reporting and Business Analyst develops, maintains, and analyzes financial and management reporting that supports informed decision-making across the Bank. The role partners with Reporting, Treasury, and Information Technology in gathering, processing and translating business requirements, validate data, improve reporting processes, and deliver reliable reporting and insights. The analyst also supports the Treasurer with certain Treasury functions through daily processes and reporting.

Key Responsibilities include, but are not limited to:

• Gather, document, and validate business, data, and reporting requirements in partnership with Reporting, Treasury, and Information Technology stakeholders.
• Prepare daily / weekly / monthly source files for the Qlik coming from Prologue / CVIEW
• Create and maintain Prologue / CVIEW queries / ALCO applications to be used for financial reporting.
• Review and analyze daily reports for accuracy and correctness.
• Assist in monitoring daily cash positions, ensuring the bank meets all operational requirements.
• Assist and support financial modeling and reporting to support Treasury
• Assist and perform model reviews of assumptions, back testing, and tuning.
• Participate in and execute system application improvement and automation efforts for various systems.
• Assist in the execution of Treasury transactions.
• Identify manual bottlenecks in reporting/treasury workflows and design automated solutions ensuring seamless integration between core banking system and treasury modules.
• Assist in maintaining department procedures.
• Ensuring all responsibilities are carried out in accordance with applicable federal, state, and local laws, regulations, and organizational policies, maintaining the highest standards of ethical and legal compliance.
• Performs other duties as required.

Education/Certifications:

Bachelor’s degree in finance, Accounting, Economics, Management Information Systems, or a related field, or an equivalent combination of education and experience, is required.

Experience:

Two to four years of experience in accounting, treasury, financial reporting, financial analysis, or a related banking function is preferred.

Preferred Skills:

• Strong proficiency in system applications, such as Microsoft Office (Advanced Excel and PowerPoint), ALCO models, SQL, VBA/Power query and BI Tools such as Tableau/PowerBI/Qlik
• Experience with financial modeling and techniques
• Analytical and data gathering skills
• Ability to translate jargon between business lines and information technology groups
• Excellent problem-solving analytical skills, detail-orientation, independent thinking, and organizational skills

Benefits

• Holidays
• Vacation
• Health/Dental
• Vision Service Plan
• Short Term Disability
• Long Term Disability
• Life Insurance
• Flexible Spending Accounts
• 401k Savings Plan
• Tuition Reimbursement
• Employee Assistance Program
• Free Employee Checking Account