Business Analyst - PW

Belcan Corporation; Windsor (CT); On-site; USD 50,000 - 58,000; Full time

Benefits offered by this job

Health care

Dental insurance

Vision insurance

Life insurance

401(k)

Education assistance

Paid time off

Holidays

Job summary

Belcan Corporation in Windsor, CT is seeking a Business Analyst for a full-time position with benefits. A Bachelor's Degree in Finance, Accounting, or related business field is required.

The role focuses on invoice analysis for a major aerospace customer, using Excel, Access, and SQL to manage data and generate monthly reports. The ideal candidate will be highly organized, able to meet deadlines, and possess strong communication skills.

Qualifications

• Bachelor's Degree in Finance, Accounting, or another business major.
• Proficiency in Excel with macros, pivot tables, and data analysis.
• Strong MS Office and Outlook skills.
• Excellent verbal and written communication; highly organized.

Responsibilities

• Review invoices and ensure billing per vendor contracts.
• Prepare and upload files into databases.
• Maintain Internal Parts Catalog with quarterly updates.
• Create/Update Work Instructions.
• Format shop invoice data for cost estimates.
• Create and maintain an Access database for invoice data and monthly reports.
• Generate monthly reports showing unbilled metrics and invoicing status.
• Support pricing processes and analyze data to present variances.

Skills

Excel macros

Pivot tables

Data analysis

MS Office suite

Outlook

Communication

Organization

Team player

Customer focus

Deadline-driven

Education

Bachelor's degree in Finance/Accounting or business

Tools

VBA

Microsoft SQL Server

Access

Job description

Description

A Business Analyst job is currently available at Belcan in Windsor, CT. This is a full-time direct position with benefits. To be considered, you will need a Bachelor's Degree in Finance, Accounting, or another Business related major. In this role you will support our large aerospace customer with invoice analysis related tasks.

Job Duties

• Review invoices and ensure they are billed in accordance with vendor service contracts.
• Prepare files for upload into database.
• Maintain Internal Parts Catalog by performing quarterly updates.
• Create/Update Work Instructions.
• Formatting of shop invoice information during engine visit to provide shop visit cost estimates.
• Create and maintain an Access Database that will contain all invoice data and reference files used to create a monthly report.
• Generate a monthly data report that shows the unbilled metrics, actual invoicing status, and ageing of unbilled activity.
• Support Shop Visit Pricing process for Estimate At Completion (EAC), input and manipulate data in excel & present variance findings to team.
• Review and process invoices utilizing tools in Access.

Required

• Bachelor's Degree in Finance, Accounting, or another Business related major
• Intermediate to advanced proficiency in Microsoft Excel -especially the ability to create and maintain macros, pivot tables and analyze data
• Strong Microsoft office product skills
• Strong proficiency in Microsoft Outlook
• Strong verbal and written communication skills
• Highly organized and ability to follow up to close gaps prior to deadlines
• Ability to understand and meet critical customer deadlines
• Strong team player
• Strong Customer focus
• Forward thinking

Preferred

• Intermediate to advanced proficiency in VBA
• Strong experience with Microsoft SQL Server
• Ability to identify productivity improvement opportunities

Salary & Benefits

We provide a competitive pay and benefits package. This position is offering a salary rate of $49,920 to $58,240 however, Belcan considers several factors when extending an offer, including but not limited to education, experience, geographic location, and discipline. Benefits offered may include health care, dental, vision, life insurance; 401(k); education assistance; paid time off including PTO, holidays, and any other paid leave required by law.

About the Company

As an employee with Belcan, you will be part of one of the largest engineering firms in the United States. We maintain a small-company atmosphere as well as open communication at all levels of our organization, allowing for much more dynamic decision-making processes. We offer flexible schedules as well as an excellent mentoring system to ensure that you have all the knowledge and tools you need to meet a diverse range of engineering challenges. You will also have opportunities to advance to positions of greater responsibility, including management roles. Your hard work and professional dedication will be rewarded with a competitive compensation package. Build a challenging and rewarding career with an industry leader!