Bachelor Internship: DWH Regulatory reporting Paccar Financial Europe

Enhance regulatory reporting using the Data Warehouse (DWH).

Functiebeschrijving

Investigate the current creation process for regulatory reports and enhance the process using PowerBI and the DWH.

In Italy, Paccar Financial Italia (PFI) is required to report to the national bank and a credit agency. This reporting is currently based on manual retrieval of data from source systems and reference data. The data is manually combined into reports, using tools such as Excel or in-company developed programs. A Data Warehouse (DWH) has been constructed to provide the data needed for reporting.

Your assignment will be to:

• Investigate the current process
• Investigate the required data for the report(s)
• Create validation rules on data quality for the fields required
• If needed, define additions for the DWH
• Build the report(s) in PowerBI
• Investigate further automation (automatic upload)

Jouw profiel

We are looking for an enthusiastic intern with the following skill set:

• Education: HBO (3rd year) student who is pursuing a degree in fields such as IT or business administration
• Analytical skills on business process and data use
• Basic knowledge of:
  • a DWH
  • Microsoft PowerBI
• Language skills: English (written and verbal) or Dutch
• Competencies: Communication skills, teamwork skills, organisational skills, time management, problem solving
• Preferred period of the internship: 4-5 months

Afdeling

PACCAR Financial Europe (PFE) provides financial services to DAF dealers and end customers to support the sales of DAF trucks. PFE is part of the worldwide PACCAR Financial organization, has its headquarters in Eindhoven at the DAF premises and is active in a large number of European countries with its own sales offices and used trucks centers. The PFE Information Technology department is responsible for the development, configuration, testing and deployment of innovative IT-solutions, management of these systems during their lifecycle and support of the users of these systems. PFE-IT consists of approximately 25 FTE, of which 20 are internal, and works according to the agile framework. Most of the systems are subject to Sox-regulations.

PFE contains 4 lines of business areas: Wholesale Financing to DAF-dealers, Retail Financing to End Customers, Short Term Leasing and Asset Management & Used Trucks Remarketing. The Retail Financing systems landscape has been renewed recently and a new state-of-the-art systems landscape for Asset Management & Used Trucks Remarketing is currently under development as part of a large IT-project. Other projects are already planned.

Wij bieden

• A view behind the scenes at a large international corporation; you will get a lot of freedom and responsibility
• We are open to your initiatives and, depending on the assignment, you see your results back in the workplace
• An experienced coach and supervisor who can teach you a lot and is willing to help you with your assignment
• After your graduation, you will have the opportunity to start your career at DAF
• An internship wage of €375 (Bachelor) and €450 (Master) per month on a full-time basis
• A travel allowance, if you don’t have a student travel product (provided by the Dutch government)
• A housing allowance, if you temporarily rent a room near DAF