Department: IT Location: Barnsley, South Yorkshire, Birmingham, Erdington, Birmingham, Flexible, Hybrid working, Knockmore Industrial Estate, Lisburn, Manchester, Stockport, Manchester, Wilmslow, Cheshire Salary Range: Competitive salary, 33 days holiday, Life Assurance and other great Company benefits Contract Type: Permanent 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 100% 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? Design, build and deploy business intelligence solutions including BI solutions (e.g. reporting tools) Develop visual reports, dashboards and KPI scorecards using Power BI desktop Connect to data sources, import data and transform data for Business Intelligence Translate business needs to technical specifications Develop and update technical documentation and complete frequent data reconciliations Develop and execute database queries and conduct analyses Responsible for design methodology and project documentation To be successful in this role you will: Have proven experience as a Power BI Analyst or Report Writer Be experienced in taking large amounts of data and turning it into reports Have a background in data warehouse design (e.g. dimensional modelling) and data mining Have an in-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework Have knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) Be experienced in dealing with a high volume of data and transactions Experience of working with financial data is not essential Qualifications Bachelor's degree in Information Technology or proven experience. Knowledge of Power BI, SSRS or comparable reporting products. Familiar with SQL relational database structure, MS SQL Server preferred. Good skills of SQL language. Working knowledge of JavaScript, CSS, HTML. General knowledge of Microsoft Office applications (Word, Excel, Outlook). Outstanding analytical and technical skills for report design and execution. Excellent organization and time management skills. Ability to work independently and manage priorities in a fast-paced environment. 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). We therefore welcome candidates within a commutable distance of our following dealerships: Barnsley, Erdington, Knockmore, Stockport or Wilmslow. In addition to receiving a competitive salary, for the right candidate this position will offer: Industry leading package 33 days annual leave (including bank holidays) in addition to an annual leave purchase & sale scheme Pension Scheme & Life Assurance Ford Privilege vehicle purchase scheme Discount on Service, Bodyshop and Parts 1 day each year to volunteer for a charity of your choice Cycle to work purchase scheme Access to Perks at Work discount website When completing your application please give specific detail of your experience, skills and previous responsibilities that you believe would be relevant to the role you are applying for. We blind recruit therefore our Recruiting Managers will not see your personal details or your CV until you have been selected to attend an interview. Our application form is your opportunity to detail all of your experience as you would on your CV. For your first 2 days in the business, you'll be attending our fantastic residential induction academy. This is at a lovely hotel in the heart of the Northampton countryside, where you'll learn all about our business before you start your new role. Our PPA is what makes TrustFord. Our Network Groups support us in allowing for every colleague to respect and care for one another no matter what... be it your race, ability, gender, or who you love. This helps us to develop inclusive and diverse teams, truly representative of the communities that we operate in. We welcome applications from everyone. We work with our colleague network Groups - including our Race, LGBTQ+, Disability and Gender Networks to increase the number of applications we receive from different backgrounds. To request any adjustments, please ask this during the application stage or contact the Recruitment Team. Happy to Talk Flexible Working - To help us be more inclusive, requests for flexible working will be considered at any point in your application or employment. Although we may deem this may not be suitable for every role, we will try and be supportive where we can. We would encourage you to contact our recruitment team to discuss any requirements you may have. TrustFord is an equal opportunities employer and does not discriminate on any grounds other than ability to carry out the job role. All offers of employment are subject to a background check. We advertise our vacancies to attract candidates and not agency suppliers. If we need agency assistance then we will contact agencies from our Preferred Supplier List. Any speculative CVs we receive will not be accepted as an introduction. To be considered for this role you will be redirected to and must complete the application process on our careers page. To start the process click the Continue to Application or Login/Register to apply button below.