Dynamics 365 BI Data Engineer – D365 F&O, D365 Finance & Operations, Dynamics365 Finance & Operations, Technical Consultant, data engineer, business intelligence, Data Lake, Data Factory, Azure, Logic apps, power BI, SQL, DAX, Snowflake– UK Remote – £550-600pd (Outside IR35)
Our global end user client is looking for a highly skilled and detail-oriented BI data engineer with expertise in delivering BI solutions to Finance using Power BI, Snowflake, MS Azure Datalake and MS D365 F&O. Primarily responsible for the development of the data warehouse using best practice for optimal performance.
The client are looking for the successful candidate to start from the 1st of November. This role can be completed remotely but candidates must be UK based and eligible to work without requiring sponsorship.
Key Skills & Experience:
- Highly experienced in full life cycle BI implementations using D365 Finance, Azure Logic App, MS Data Factory, MS Datalake, Snowflake and PowerBI, particularly confident with SQL and DAX
- Proficient in the Office Suite, particularly MS Excel, and Azure DevOps
- A good understanding and exposure to the D365 and Azure datalake architecture
- Experience in leading the implementation of data warehouses and recommending best practices
- Ability to clearly document and explain proposed solution designs
- Demonstrable ability to engage and manage different level stakeholders and multicultural audience/s through superior communication and presentation skills
- Ability to propose solutions beyond the norm to achieve the requirements
- Proven ability to deal with and manage conflict
- Highly structured and proven ability to manage and run projects
Main Responsibilities:
- Base knowledge and ownership – Expertise in the required subject matter and systems i.e. D365 Finance entities and tables, Azure Datalake, Azure Data Factory, Azure Logic Apps, Snowflake and PowerBI data models. Use this expertise to recommend solution designs and own all work related to the implementation of the data warehouse development per best practice
- Understand data requirements and tooling – work with the BI business analyst and BI workstream lead to understand the reporting, data model, security and any other functional and non-functional requirements. Understand the tooling landscape and IT processes via engagement with D365 consultants and IT
- Data architecture – propose the architectural design for the data warehouse and data models including integrations to downstream and upstream systems ensuring optimal and performant system design
- Documentation – creation of the proposed data warehouse design document, data integration design document, data model design document and security design document for review and approval by senior programme members and IT. Make updates to this documentation as the implementation progresses to reflect any changes to the proposals
- Data warehouse development – create objects, scripts and codes to ingest and transform data in line with data warehouse best practices for optimal performance e.g. setup of databases, permissions, schemas, tables, views, ETL pipelines (scheduled jobs, merge scripts, appropriate stored procedures for structuring and normalisation of data per requirements, surrogate keys)
- Data pipeline maintenance and monitoring – ensure jobs are setup and scheduled for ETL processes. Work with the business analyst and workstream lead to ensure quality gates are implemented including the ability to monitor the quality gates on an ongoing basis
- Data model development – share responsibility with the business analyst on the development of PowerBI Semantic Data Models
- Testing – Perform unit and functional testing and co-ordinate UAT
- Deployment – perform deployment related activities between the different environments via appropriate ALM/version control tools
- Handover – take part in handover activities to a permanent BI function including creation of process documentation and training materials
- Coms and escalations – Make decisions that best resolve process/product related issues and appropriately escalate issues that require Programme/IT and/or business management involvement
Location: UK Remote
Candidates must be eligible to work in this country.
Catch Resource Management is a leading provider of Dynamics 365, JD Edwards, NetSuite 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.