Software Engineering Intern

TriMas Corporation • Bloomfield Hills, MI

2d • Onsite

About The Position

We are seeking an Software Engineering Intern to help design and build a solution that ingests financial data from multiple file formats (e.g., Excel, CSV, PDFs, ERP exports), standardizes the data, and generates automated comparisons, insights, and variance analysis. This tool will support financial planning and analysis (FP&A) processes and improve decision-making efficiency.

Key Responsibilities:
Design and develop a system to extract, transform, and load financial data from diverse sources
Build models to:
Normalize inconsistent data formats
Map accounts across different datasets
Develop functionality to:
Compare financial statements (actuals vs budget, forecast vs prior, etc.)
Identify variances and key drivers
Highlight anomalies or inconsistencies
Implement data validation and reconciliation logic
Create user-friendly outputs such as:
Dashboards (Power BI / web app)
Automated reports
Summary insights
Integrate with existing tools (e.g., Excel, Power BI, ERP systems)
Ensure scalability, performance, and data accuracy
Collaborate with finance stakeholders to refine business logic and requirements
This position is an onsite, part-time role. Expected hours are 15-20 hours per week.

Requirements

• Strong programming skills
• Experience with data processing libraries
• Experience with file parsing (Excel, CSV, PDF extraction)
• Knowledge of machine learning or AI techniques (for classification, anomaly detection, or mapping)
• Understanding of financial statements and FP&A processes
• Experience with databases (SQL, data warehouses)
• Knowledge of automation frameworks or RPA tools
• Experience building internal tools or analytics products

Responsibilities

• Design and develop a system to extract, transform, and load financial data from diverse sources
• Build models to normalize inconsistent data formats and map accounts across different datasets
• Develop functionality to compare financial statements, identify variances and key drivers, and highlight anomalies or inconsistencies
• Implement data validation and reconciliation logic
• Create user-friendly outputs such as dashboards, automated reports, and summary insights
• Integrate with existing tools (e.g., Excel, Power BI, ERP systems)
• Ensure scalability, performance, and data accuracy
• Collaborate with finance stakeholders to refine business logic and requirements

Benefits

• Medical Insurance and Prescription Drugs
• Dental Insurance
• Vision Insurance
• Flexible Spending Accounts
• Life Insurance
• Short-Term Disability
• Long-Term Disability Insurance (for eligible employees)
• Employee Assistance Plan (EAP)
• Paid Time Off (may include vacation and sick time)
• Retirement Program
• Other Voluntary Benefits

What This Job Offers

• Job Type: Part-time
• Career Level: Intern
• Education Level: No Education Listed