Lead Data Migration Specialist

About usSmartImpact is a Microsoft Partner and a leading provider of Dynamics 365 CE, Kentico and Umbraco solutions in the Not-for-Profit marketplace. We have around 75 staff and well over 150 successful projects in the membership associate, institutes, regulator, trade union and charity marketplace. Our aim is to make a difference within the NfP industry. We have seen over a 50% growth in the last 2 years, with plans to continue on this growth with additions in every single area/ department within the business. You will be joining our development team of around 20 people.About the JobWe are seeking a highly skilled and experienced Data Migration and Integration Expert to join our team. The ideal candidate will possess deep expertise in performing data migrations from various data sources to Microsoft DataVerse, along with strong proficiency in Microsoft Fabric, Power BI, Power Automate, Azure Logic Apps, and data integration techniques. This role requires a detail-oriented professional with a passion for data accuracy, seamless integration, and the ability to transform complex data into meaningful insights.Responsibilities:Data Migration:Plan, execute, and manage data migration projects from diverse data sources (SQL, Oracle, Excel, etc.) to Microsoft DataVerse.Develop and implement data migration strategies ensuring data integrity, accuracy, and security.Troubleshoot and resolve data migration issues, optimising the process for efficiency.DataVerse Expertise:Serve as the in-house expert on Microsoft DataVerse, ensuring best practices and optimal use of the platform.Provide guidance and support on DataVerse-related projects and initiatives.Microsoft Fabric and Power BI Expertise:Design, develop, and maintain Power BI dashboards and reports to support business intelligence needs.Utilise Microsoft Fabric to enhance data modelling and reporting capabilities.Power Automate and Azure Logic Apps Integration:Implement and manage data integration solutions using Power Automate and Azure Logic Apps to ensure seamless data flow between systems and applications.Automate workflows and processes to enhance operational efficiency.RequirementsMicrosoft certifications in DataVerse, Power BI, Power Automate, and/or Azure Logic Apps.Proven experience in data migration projects, specifically with Microsoft DataVerse.Strong proficiency in Power BI, including DAX, Power Query, and report/dashboard creation.Expertise in Microsoft Fabric and data integration techniques.Proficiency in Power Automate and Azure Logic Apps for workflow automation and data integration.Solid understanding of relational databases and SQL.Experience with other BI tools and data platforms (e.g., Tableau, Snowflake).Knowledge of cloud computing platforms, particularly Microsoft Azure.What we offerContinuous learning. You will develop the mindset and skills to navigate whatever comes next.Support and leadership via our SMT team.Exposure to great clients, bespoke products, and latest technology.An open and collaborative friendly working environment with knowledge sharing at the centre.The chance to join a small but growing organisation where your voice is heard.Doing rewarding work within the Not-for-Profit industry.Remote working with ad hoc office visits for team meetings and socials.Diverse and inclusive culture: You will be respected for who you are and empowered to use your voice to help others and our clients.