We share an ambition to be recognised as the benchmark in all of our operations.
At TrustFord we keep on growing. From selling electric vehicles in ever greater numbers, to providing more mobile servicing and growing our commercial and fleet vehicles, we’re offering and delivering more choice to our customers every day. Becoming a more diverse and inclusive business will also be vital to our success, but what won’t change is the buzz we get from working in a fast-paced environment that’s % customer-focused.
The Analyst Report Writer works in conjunction with the IT development team to develop and support business wide reporting. This position is responsible for end-to-end report development including interaction with end users to gather requirements, understanding report objectives, designing and developing reports using SSRS and PowerBI.
What will I be doing as an Analyst Report Writer?
1. Design, build and deploy business intelligence solutions including BI solutions (e.g. reporting tools)
2. Develop visual reports, dashboards and KPI scorecards using Power BI desktop
3. Connect to data sources, import data and transform data for Business Intelligence
4. Translate business needs to technical specifications
5. Develop and update technical documentation and complete frequent data reconciliations
6. Develop and execute database queries and conduct analyses
7. Responsible for design methodology and project documentation
To be successful in this role you will:
8. Have proven experience as a Power BI Analyst or Report Writer
9. Be experienced in taking large amounts of data and turning it into reports
10. Have a background in data warehouse design (e.g. dimensional modelling) and data mining
11. Have an in-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
12. Have knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
13. Be experienced in dealing with a high volume of data and transactions
14. Experience of working with financial data is not essential
Qualifications
15. Bachelor’s degree in Information Technology or related field.
16. Knowledge of Power BI, SSRS or comparable reporting products.
17. Familiar with SQL relational database structure, MS SQL Server preferred.
18. Good skills of SQL language.
19. Working knowledge of JavaScript, CSS, HTML.
20. General knowledge of Microsoft Office applications (Word, Excel, Outlook).
21. Outstanding analytical and technical skills for report design and execution.
22. Excellent organization and time management skills. Ability to work independently and manage priorities in a fast-paced environment.
23. Knowledge of SSRS preferred but not required.
This is a Hybrid role working on site and also from home (the first 3 months during probation will be worked from the office full time, you will then move on to hybrid working from month 4).
In addition to receiving a competitive salary, for the right candidate this position will offer:
24. Industry leading package
25. 33 days annual leave (including bank holidays) in addition to an annual leave purchase & sale scheme
26. Pension Scheme & Life Assurance
27. Ford Privilege vehicle purchase scheme
28. Discount on Service, Bodyshop and Parts
29. 1 day each year to volunteer for a charity of your choice
30. Cycle to work purchase scheme
31. Access to Perks at Work discount website