Tenneco

Data Analytics Intern

Tenneco

internship

Posted on:

Location Type: Office

Location: Northville • Missouri • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Entry Level

Tech Stack

Amazon RedshiftAWSSQL

About the role

  • Design, build, and maintain interactive dashboards and reports to visualize key financial and operational KPIs in Power BI
  • Extract and transform data from AWS Redshift using Power Query and SQL to create robust PBI data models
  • Assist in automating weekly flashes and month-end close processes and data reconciliation with OneStream
  • Collaborate with finance and operations teams to translate complex business needs into technical reporting specifications
  • Perform rigorous testing and validation to ensure data integrity between SAP, Redshift, OneStream and final Power BI outputs
  • Identify opportunities to automate recurring financial reports, reduce manual data pulls and increase efficiency

Requirements

  • BS or MS in Finance, Information Technology, Data Analytics or related field
  • 1+ Years of work or prior internship experience
  • Experienced with Power BI (DAX, Power Query), Excel and SQL
  • Familiarity with AWS Redshift, OneStream and understanding of SAP table structures would be a plus.
Benefits
  • Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Power BIDAXPower QuerySQLdata modelingdata extractiondata transformationdata validationdata reconciliationautomation
Soft Skills
collaborationcommunicationproblem-solvingattention to detailanalytical thinking