Macildowie Recruitment & Retention - Data, BI & MI Analytics Senior Data Engineer - Up to 85,000 - Nottingham Monday - Friday, 9am - 5pm - Hybrid / Remote Macildowie Data Analytics is delighted to have exclusively partnered with a reputable and growing organisation to recruit a Senior Data Engineer / Developer. You will play a pivotal role in streamlining our client's workflow and data infrastructure which would include writing SQL code, whilst extracting and cleansing data from core systems working towards building and selecting a data warehouse for the business. Main Responsibilities Develop, maintain, and distribute critical operational reports to senior management and key stakeholders. These reports will offer valuable insights into operational performance, guiding our client's actions. Extract data from core systems, whilst using SQL to write and cleanse data to ensure data availability and accuracy. Establish and support the wider business with building a robust data warehouse for ongoing reporting. Scrutinise data quality, rectify discrepancies, and proactively identify and address dataset issues to guarantee precision in our analysis. Conduct thorough gap analyses within datasets and collaborate with the business to implement solutions, fostering continuous improvement. Playing a crucial role in the preparation and monitoring of weekly/monthly metrics required for regulatory reporting using PowerBI. Create insights that pinpoint and prioritise key areas for the business, ensuring our focus aligns with industry trends and emerging opportunities. Cooperating with stakeholders to provide appropriate value-adding commentary helping our client identify gaps and explore. Map, scope and support cross functionally with the build of a new data warehouse. Identify opportunities to automate data processes and implement data quality control measures. The Candidate Proficiency in handling and integrating large, complex datasets. Experience using and coding SQL to interrogate datasets and to derive insights. Demonstrated expertise in data manipulation techniques, including data cleaning, transformation, and aggregation. Proficient user of data visualisation tools such as Power BI and Excel to effectively communicate insights, trends, and findings. Exhibit strong problem-solving skills, approaching data challenges with analytical thinking and innovative solutions. Previous experience data warehousing or with legacy and modern database technologies. A background in wealth management or financial planning. The first stage of the application process is to apply online. If you would like any more information about this vacancy before applying, please get in touch with Tom Whitsey. Please put your home postcode on your CV when applying. Our recruitment tech uses this to make sure your CV is reviewed by the relevant consultant, for the relevant job(s), in the relevant geography. Macildowie are a recruitment business working on behalf of a client to recruit this role. Your personal data may be forwarded to that client company as part of the application process. If you would like information on how we will process your data please go to our website (macildowie.com) and view our fair processing notices which are located at the bottom of the page under privacy policies. Within the fair processing notice for Candidates there is guidance on how to amend your contact preferences or exercise your rights relating to personal data. We can't provide direct links as email address and website urls within our job adverts are removed by some of the websites on which we advertise. Macildowie is a specialist recruitment consultancy with a rich history of enhancing the careers of professionals across the Midlands and the Northern Home Counties. We have an unrivalled understanding of the local market place and recruit for the majority of the region's premier employers. To search for all of our live jobs please visit us at macildowie.com.