Business Intelligence Engineer

BI Engineer – BI, Business intelligence, Engineer, BI Consultant, Data Bricks, Azure Data Lake, Data Lake, D365, Dynamics365, ETL, ELT, Fabric, Synapse - £550-650pd – London/Remote Our professional services client require a BI Engineer to help them move core financial reporting from D365 to Azure Data Lake. For this role it is essential that candidates have experience/knowledge across D365, Azure Date Lake and Data Bricks. The role will typically involve 2 days per week on-site in London and has been deemed inside IR35. Key Skills: • 3+ years of experience building ETL/ELT pipelines using Databricks SQL. • Strong understanding of the D365/F&O data schema (e.g., GeneralJournalAccountEntry, CustInvoiceJour, TaxData). • Strong experience with ADLS Gen2, Azure Synapse Link, and Azure Data Factory. • Expert-level knowledge of Kimbal-style data warehousing (Facts and Dimensions). Main Responsibilities: • Architect and maintain the bridge between D365 and the Data Lake • Use Databricks to develop the architecture to handle high volumes of transactional data. • Replicate and enhance legacy OLAP cube logic by designing Star Schemas and Delta Tables optimized for Power BI. • Translate complex D365 accounting concepts (General Ledger entries, Tax settlements, Sub-ledger reconciliations) into scalable code. • Optimize Databricks clusters and partition strategies to ensure financial reports refresh quickly Location: London/Remote Candidates must be eligible to work in this country. Catch Resource Management is a leading provider of Dynamics 365, JD Edwards, NetSuite, EPM and other ERP resources to both end users and to product suppliers/authors. Our consultants deliver a completely professional resourcing service, always backed up by our team of ERP specialists who are all experienced in full project life cycle implementation and support, thus ensuring that we fully understand our clients’ requirements and our candidates’ skills. If you have the relevant skills and experience for this position we would welcome your application, however please note that we receive high levels of responses to our advertisements so can only immediately respond to those that are a close match. However, if you are interested in hearing about similar positions then please register on our website: www.catchgroup.com.