Bi Developer, Cardiff

Company description We are the AA. And we keep everyone?s show on the road. There for our customers wherever and whenever they need us, we?re always ready for anything. That?s why, for over 100 years, we?ve continued to evolve and adapt. Today, as the nation?s number one motoring organization, we offer a range of excellent products and services to millions of customers. FTC - 12month contract Location: Cardiff with homeworking Salary: £40k to £49k subject to experience This is the job As the BI developer, you will be responsible for the redesign and ongoing enhancement of the Driving School data capability. You will be required to implement and consistently improve upon the end-to-end solution for all levels of the data architecture, from the ETL abstraction layer through to the semantic data models and end user reports. The role is predominantly hands on. However, is a requirement to support the ongoing development of junior members of the team. What will I be doing? * Working with the BI manager, contribute to the design and planning process for the new data warehouse and semantic data models, providing estimates on delivery timescales * Provide timely updates to the BI manager on initial and ongoing delivery, progress, slippage, risks, issues and quality such as peer reviews * Share lessons learned providing feedback as required * Design new or continuously improve / optimise BI solutions, taking into account end user feedback * Provide post implementation and ongoing support to end users to ensure the BI solution is fit for purpose and successfully imbedded * Collaborate with colleagues both internal and external to strengthen BI solution delivery, with an initial focus on implementing data models for sales attribution and customer LTV * Implement an ETL abstraction layer responsible for consumption of data from multiple sources both internal and external; ensuring robust data sanitation processes are in pace * Comprehensive documentation on both the data warehouse and business logic utilised in semantic data models * Support Junior team members through sharing knowledge and experience What do I need? Capability, Knowledge and Experience: * Experience with Microsoft Azure and AWS (Amazon Web Services) * Strong experience with SQL Server * Strong experience with TSQL * Strong experience with SSIS, SSRS, SSAS (essential), Azure Analysis Services (desired) * Experience with NoSQL databases (MongoDB, Cassandra etc) * Experience in developing, maintaining and supporting operational/live reports, dashboards, and scorecards using Microsoft Power BI * Experience using, configuring and interrogating CRM systems * API consumption (essential), API development (desired) * Strong experience in Excel * Strong experience in Power BI or equivalent reporting tool * Strong knowledge base in data warehouse methodologies and best practice * Relevant experience in migrating data solutions into the cloud * Experience in leveraging geo-based datasets Education and Qualifications: * Degree or equivalent experience * Strong business experience and knowledge in BI design and methodologies Good conduct matters at the AA. It's very important that you act with honesty & integrity, are respectful of others and have a consistent desire to do the right thing. Everyone at the AA lives these behaviours, so we are all able to support the delivery of good outcomes for our customers