Business Analyst

Belcan Corporation; Windsor, Northern (CT, KY); Hybrid; USD 50,000 - 58,000; Full time

Job summary

Belcan Corporation in Windsor, CT is seeking a Business Analyst to support invoice analysis tasks for our aerospace customer. This full-time role requires a Bachelor's Degree in Finance, Accounting, or related business field and strong Excel skills.

You will review invoices, prepare data for databases, generate monthly reports, and help maintain data holdings in Access, with attention to deadlines and customer needs. The position offers benefits and long-term career growth.

Qualifications

• Bachelor's degree in Finance, Accounting, or another business-related major.
• Intermediate to advanced proficiency in Microsoft Excel with macros and pivot tables.
• Strong MS Office skills and proficiency with Outlook.
• Excellent written and verbal communication; highly organized and deadline-driven.

Responsibilities

• Review invoices and ensure billing aligns with vendor contracts.
• Prepare files for upload into a database.
• Maintain Internal Parts Catalog with quarterly updates.
• Create/Update Work Instructions and monthly reports.
• Format shop invoice information to estimate costs during engine visits.
• Create Access database containing invoice data and reference files.
• Generate monthly data reports showing unbilled metrics and aging.
• Support pricing processes and analyze variances using Excel.

Skills

Pivot tables

Macros

Data analysis

Communication skills

Education

Bachelor's Degree in Finance, Accounting, or another Business related major

Tools

Microsoft Excel

Microsoft Outlook

Microsoft Office

VBA

SQL Server

Job 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

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.'

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!