Data and Solutions Engineer

Get AI-powered advice on this job and more exclusive features. Ready to help us pipeline our way to success? Read on to find out more about our new position, Data and Solutions Engineer. The investment arm of a market leading financial services company is expanding. With over £1 billion assets under management, we are committed to delivering innovative solutions and driving business growth through data. With a strong focus on adopting the latest technologies, we are transitioning our data infrastructure from hosted SQL Server to a modern cloud-based environment on Azure. 🚶We are seeking an experienced Data Engineer to join our Engineering team with the primary focus of providing technical support to the Investment & Decision Science teams driving investment and analytical decisions. You will play a crucial role in providing technical and analytical solutions to challenges faced by the investment team operating at the heart of the investment process, supporting our migration to cloud technologies and assisting with any future applications of AI-driven technologies. The ideal candidate will have a strong foundation in traditional data engineering skills while being able to adapt to modern tools such as Azure Data Factory, Power BI, and Databricks, with Python as the primary coding language. This role requires hands‑on experience with database design, ETL development, data integration, and a passion for data quality and governance. 🗓 Data Best Practices: Ensure best practices are followed in data creation, management, and database performance. Data Solution Design: Translate high-level data solutions into detailed low-level designs and work packages and supporting the production of analytical outputs, operational insights and visualisations to be utilised by the investment team. Build and manage high-quality, secure, and governed ETL processes using on-premise and cloud-based data sources. Data Quality & Monitoring: Design data observability and quality checks into all ETL processes, enabling proactive identification of discrepancies. Performance Optimisation: Optimise data platforms, ETL processes, and database solutions for reusability and performance. Financial Calculations: Writing robust and repeatable formulae, prescribed by the Investment team to calculate a range of valuation metrics, to be referenced by the investment team throughout the valuation and decision making process (examples including IRR’s, NPV’s and ROI’s). 👆3+ years of experience designing and deploying business data ETL packages and data‑based systems. Strong proficiency in Python, T‑SQL, and other traditional Microsoft SQL Stack technologies. A solid understanding of data quality and governance practices. Familiarity with Microsoft Azure tools such as Azure Data Factory, Power BI, Data Pipelines, and Data Lake. Experience with Azure Data Lake and Delta Lake design pattern implementation, including file hierarchy and low‑level permissions management (desirable). Experience in building CI/CD pipelines in Azure DevOps with managed identity (desirable). ⏳ A first stage video call with the internal talent acquisition team (15 minutes). A second stage introductory video call with the hiring manager (30 minutes). Please note we will close this role once we have enough applications for the next stages therefore you should submit your application ASAP to avoid any disappointment. 40,000 - £45,000 DOE + up to 20% of your annual salary, paid as a bonus. 📍This role is based at our Manchester Spinningfields office. Did we mention the free coffee bar and beer tap? We offer flexible and hybrid working between our core hours of 8am- 6pm, Monday to Friday. 🎓And many more benefits to support your wellbeing and professional development. All applicants will be considered for employment without attention to age, ethnicity, religion, sex, sexual orientation, gender identity, family or parental status, national origin, veteran, neurodiversity or disability status. If you have any questions or suggestions of how we can assist you in your application due to disability or personal reasons, please email recruitment@perchgroup.PLEASE NOTE - All new employees must undergo a full DBS and Credit Check upon acceptance of a job offer with Perch Group. Full‑time Manchester Spinningfields Office, Manchester, England, United Kingdom. #