Finance Intern – 1st shift – On site - Aeroestructuras

Collins Aerospace; Mexicali; On-site; MXN 112,000 - 167,000; Part time

Job summary

Collins Aerospace in Mexicali, BC, is seeking a finance internship student to support financial reporting, data analysis, and internal controls. You will work with Excel, Power Query, and BI tools to transform data into insights and help improve the quality of financial information. This onsite role runs from 8:00 a.m.

to 2:00 p.m. and requires current enrollment in Finance/Accounting/Business Admin in 7th or 8th semester with intermediate-advanced English.

Qualifications

• Currently enrolled in Finance/Accounting/Business Administration degree program, 7th or 8th semester.
• Experience using Microsoft Office, including Excel (VLOOKUP/XLOOKUP, Pivot Tables, and basic formulas).

Responsibilities

• Support preparation, analysis, and monitoring of financial reports.
• Assist Fixed Assets Inventory and internal controls documentation.
• Support reporting automation and BI initiatives.

Skills

Excel

Microsoft Office

VLOOKUP/XLOOKUP

Education

Finance/Accounting/Business Admin degree

Tools

Power BI

Power Query

SQL

SAP/ERP

Job description

What You Will Do:

• Financial Analysis & Reporting: Support the preparation, analysis, and monitoring of financial reports, using data to identify trends, inconsistencies, and improvement opportunities, while contributing to improving the visibility and quality of financial information.
• Fixed Assets & Internal Controls: Participate in the Fixed Assets Inventory project by collecting, validating, and analyzing information, as well as supporting activities related to the assessment and documentation of internal controls.
• Reporting Automation & Business Intelligence: Support reporting automation initiatives to improve process efficiency, using Business Intelligence and Data Analytics tools to transform data into valuable information for the business.
• Schedule Availability: Availability to work from 8:00 a.m. to 2:00 p.m.
• Intermediate- advanced English: Intermediate- advanced English proficiency (B2 or higher).

What You Will Learn:

• Finance & Business Processes: Understand how financial processes operate within an organization and how financial information contributes to business decision-making.
• Data Analytics & Business Intelligence: Apply data analysis and visualization tools to real financial processes, gaining experience in dashboards, reporting, and generating insights.
• Financial Controls & Reporting: Gain practical knowledge of Fixed Assets, Internal Controls, and Financial Reporting, as well as an understanding of the importance of controls in ensuring the quality and reliability of financial information.
• Automation & Continuous Improvement: Learn how to identify opportunities for process automation and improvement by using data and digital tools to increase efficiency.
• Cross-functional Experience: Gain experience collaborating with different teams and participating in real-world projects, strengthening the ability to communicate analysis and contribute to business solutions.

Qualifications You Must Have:

• Currently enrolled in a Finance, Accounting, Business Administration, or related degree program, currently in the 7th or 8th semester.
• Experience using Microsoft Office, including Microsoft Excel (VLOOKUP/XLOOKUP, Pivot Tables, and basic formulas).

Qualifications We Prefer

• Academic, professional, or project experience in data analysis, report preparation, or financial analysis.
• Previous experience using Power Query, SQL, or reporting automation tools.
• Previous experience using SAP or another ERP system.
• Experience using Power BI.

Finance:

When you join our finance team, you’re joining a team whose impact stretches across the world, and even beyond. Our team supports 70,000 employees across the U.S. and around the globe. As a United Technologies Corp. subsidiary, we operate with our own business reporting structure, financial dashboards and earnings metrics. This reporting relationship allows finance team members to implement innovative tools for the aerospace market in a stand-alone business environment. At Collins Aerospace, you’ll be not only be advancing your career, you’ll be leaving your mark on the future of advanced technologies.

Role Type Definitions:

Onsite: Employees who are working in Onsite roles will work primarily onsite. This includes all production and maintenance employees, as they are essential to the development of our products.

Please be aware of our location:

Blvr. Venustiano Carranza #238, El Robledo, 21397 Mexicali, B.C.