On-Site Data Engineering Intern for FP&A Insights

TriMas Packaging Group; Michigan; On-site; USD 2,066,000 - 3,444,000; Part time

Benefits offered by this job

Medical Insurance and Prescription Dr�

Dental Insurance

Vision Insurance

Flexible Spending Accounts

Life Insurance

Short-Term Disability

Long-Term Disability Insurance

Employee Assistance Plan (EAP)

Paid Time Off

Retirement Program

Other Voluntary Benefits

Job summary

TriMas Packaging LLC is seeking a Software Engineering Intern to design and build a data ingest and FP&A analysis tool. You will work on ingestion from Excel, CSV, PDFs, and ERP exports, standardize data, and generate automated insights and variance analysis for decision-making.

The role involves building ETL pipelines, data models, and dashboards, with collaboration across finance and IS teams. This is an on-site, part-time internship with 15–20 hours per week.

Qualifications

• This role requires strong programming and data processing ability.
• Experience with file parsing and data standardization is preferred.
• Knowledge of FP&A concepts and SQL is beneficial.

Responsibilities

• Design and develop a system to extract, transform, and load financial data from diverse sources.
• Build models to normalize data formats and map accounts across datasets.
• Develop functionality to compare statements and identify variances.
• Highlight anomalies and implement data validation and reconciliation logic.
• Create dashboards and automated reports (Power BI / web app).
• Integrate with Excel, Power BI, and ERP systems; ensure scalability and accuracy.

Skills

Strong programming

Data processing libraries

File parsing

ML techniques

FP&A knowledge

SQL

Automation frameworks

Internal tools

Tools

Power BI

Job description

TriMas Packaging LLC is seeking a Software Engineering Intern to design and build a data ingest and FP&A analysis tool. You will work on ingestion from Excel, CSV, PDFs, and ERP exports, standardize data, and generate automated insights and variance analysis for decision-making.

The role involves building ETL pipelines, data models, and dashboards, with collaboration across finance and IS teams. This is an on-site, part-time internship with 15–20 hours per week.