Design, develop, and implement successful custom integrations solutions using MS Integrations Services and Power Platform components to automate processes, streamline operations and extend functionality of core applications.
Build out an enterprise class data platform interfacing with a multitude of differing endpoints, technologies and data structures
Provide expert guidance on Azure integration component implementation, configuration and customisation to meet business requirements.
As part of Service Delivery, provide support to troubleshoot and resolve issues with data and application integrations and related environments.
Collaborate with stakeholders at all levels to gather requirements, analyse processes and recommend optimal solutions.
Stay up to date with the latest MS Azure, Power Platform and D365 features and best practices.
Fully participate in team planning and work with colleagues to continuously improve the team’s performance.
Extensive experience in the Microsoft Azure Integrations Service technologies and components -Developing robust, scalable, secure & efficient enterprise class integrations interfacing with a wide variety of in-house and 3rd-party applications and services.
Implement error logging, error trapping, and checkpoints.
Implement secrets and Key Vault stores for optimum security.
Deploy integrations via CI/CD pipelines in DevOps across multiple environments in a fully controlled and traceable process.
Maintain code and object repositories in DevOps.
Provide ongoing support and troubleshooting for deployed integrations.
Work as part of a collaborative, medium-sized multi-disciplinary team, excellent communication skills.
Able to work on own initiative when called upon.
Proficient in aiding with design and architecture discussions and decision making.
Proficient in reverse engineering existing integrations and processes to aid with transposing into new data platform.
Proficient in interpreting designs and patterns provided by other team members and approved 3rd parties into workable, scalable, reliable solutions.
Proficient in creating code, processes, JavaScript, T-SQL, formulas, C#, PowerShell and other scripts as required.
Proficient in manipulating and working with a range of data formats including JSON, XML, delimited text, Excel, etc.
Familiarity with .Net development, Microsoft tools and DevOps.
Responsible for the development of Azure Logic Apps, Azure Function Apps, workflows and other components as required.
Provide architecture, configuration, administration, and functional support to expand capabilities in Microsoft 365 (Dynamics 365 is a plus).
Assist in implementing best practice for information and document management.
Gather requirements, make recommendations and estimate effort to complete work.
Offering mentoring and support to less experienced members of the team.
Interpret and design database models (SQL Server, Azure DB etc).
Good foundational knowledge of Office 365 platforms, including Azure AD, and Azure ecosystem.
Working knowledge of medallion architecture and how it fits within a data platform.
Working knowledge of Log Analytics, KQL and how it fits within monitoring solutions.
Integrations development involving Azure Integrations, SQL Server / Azure SQL, APIs, Saas & PaaS systems
Experience in an Agile development life cycle (SCRUM, RAD, KANBAN) using Azure DevOps or similar
Working as part of medium sized development team (5+)
Exposure to multi-platform integration (MS tools preferred).
On premise SQL environments, legacy SSIS, SSRS and other SQL-related technologies employed in complex ETL or ELT patterns
Synapse Link for Dataverse
Dataverse, Data Flows, Cloud Flows, DAX and Power Platform implementations
Synchronisation methods for Synapse and Fabric from D365
FTP / STFP configurations and services
Web services, SaaS and PaaS development
