Logo of Huzzle

🚀 Internship

• Starts Jun 9

Financial Planning and Analysis (FP&A) Intern

Logo of Dynatrace

Dynatrace

23d ago

🚀 Summer Internship

Boston

AI generated summary

  • The ideal candidate for the Financial Planning and Analysis (FP&A) Intern position at Dynatrace should be currently enrolled in a Bachelor's or Master’s program in Finance, Business, Information Technology, or a related field. They should have strong analytical and problem-solving skills, excellent communication and people skills, attention to detail, and the ability to work independently and collaboratively in a dynamic team environment. Familiarity with technologies such as Microsoft Excel, Microsoft PowerPoint, SQL, dimensional modeling, and Power BI/Power Query is also preferred.
  • The FP&A intern at Dynatrace will collaborate with the team to enhance financial reports, analyze data using Excel and SQL, create dynamic dashboards with Power BI, and participate in UAT processes to ensure accuracy and reliability of financial systems. They will also work on data transformation projects and explore automation opportunities to streamline financial processes.

Summer Internship

Banking & FinanceBoston

Description

  • We are looking for a Finance, Business, IT or similar student with masters, junior or senior level standing to join us this summer on our Financial Systems and Analytics team. This is a full-time, paid internship.  

Requirements

  • Required:
  • Current enrollment in a Bachelor's or Master’s program in Finance, Business, Information Technology, or a related field.
  • Local to our Waltham, MA office and able to come into the office 3 days per week.
  • Preferred:
  • Work experience: 0-1 Years.
  • Considering a career in Finance, FP&A or Technology
  • Strong analytical and problem-solving skills.
  • Excellent communication and people skills.
  • Attention to detail.
  • Ability to work independently and collaboratively in a dynamic team environment.
  • Familiar with one or more of the following technologies:
  • Microsoft Excel, including pivot tables, formulas, and financial modeling, financial functions, lookups, pivot tables, array-based math, and nested conditional formulas.
  • Basic understanding of Microsoft PowerPoint
  • SQL for data manipulation and analysis.
  • Understanding of accounting principles, financial statements, and financial analysis
  • Familiarity with dimensional modeling / star-schema
  • Power BI / Power Query experience is a strong plus.

Area of Responsibilities

Banking & Finance

Responsibilities

  • Reporting and Analysis:
  • Collaborate with the FP&A team to build and enhance financial reports for management.
  • Work on requirements gathering to understand stakeholders' reporting needs.
  • Utilize Excel for data analysis, creating pivot tables, and developing financial models.
  • Leverage Power BI for creating dynamic and interactive dashboards.
  • Assist in the design and development of visually compelling reports for stakeholders.
  • Design and maintain Power BI semantic models to drive self-service reporting capabilities.
  • Data Validation and User Acceptance Testing (UAT):
  • Conduct data validation exercises to ensure accuracy and reliability of financial data.
  • Participate in UAT processes, ensuring that financial systems meet user requirements.
  • Data Analysis and Transformation:
  • Develop and execute SQL queries for data extraction, transformation, and analysis.
  • Work closely with the technology team to understand and optimize database structures.
  • Participate in data transformation projects to enhance the efficiency of financial processes.
  • Explore opportunities to automate routine tasks and streamline data workflows.

Details

Work type

Full time

Work mode

hybrid

Start date

Jun 9, 2024

Location

Boston