Job Title: Senior Integration Specialist (Enterprise Apps) with MuleSoft, SQL Server & Microsoft Fabric Job Overview: As a key member of our IT team, the Senior Integration Specialist designs and builds robust data flow channels to implement scalable API-led connectivity and data integration solutions connecting diverse enterprise systems and external services to ensure seamless, secure, and real-time data exchange. With extensive experience delivering enterprise integrations using MuleSoft Anypoint Platform, complemented by strong SQL Server skills and hands-on knowledge of Microsoft Fabric, they will design, develop, and enable reliable data movement and actionable insights across platforms. This role demands exceptional technical proficiency, leadership qualities, and a proven track record in delivering complex integration initiatives while ensuring performance, security, and maintainability. Key Responsibilities: 1. Integration Solution Development: - Lead the design, development, and maintenance of sophisticated integration solutions using MuleSoft Anypoint Platform, applying API-led connectivity (System/Process/Experience APIs) to enable seamless communication between diverse systems. - Build and optimize data ingestion, transformation, and validation workflows leveraging SQL Server (T-SQL, stored procedures, performance tuning) and Microsoft Fabric components (e.g., Lakehouse/Warehouse and Data Pipelines) as appropriate. 1. Reporting: - Partner with analytics stakeholders to enable reporting and semantic modeling needs using SQL Server and Microsoft Fabric (including integration patterns that support Power BI consumption). - Collaborate closely with business analysts and stakeholders to understand data and reporting requirements, translating them into MuleSoft APIs/integrations and downstream Fabric/SQL Server data products. 1. Management and Collaboration: - Oversee and manage complex integration efforts, collaborating closely with business analysts, stakeholders, and technical teams. - Mentor a team of developers, providing guidance, training, and technical expertise in integration best practices and tools. - Collaborate with database administrators and other IT teams to ensure data security, integrity, and optimal database performance. 1. Performance Optimization and Troubleshooting: - Monitor integration processes, troubleshoot issues, and optimize performance to exceed predefined service level agreements (SLAs). - Create and maintain detailed documentation for integration processes, data mappings, and report specifications. 1. Continuous Improvement and Innovation: - Stay abreast of emerging trends, technologies, and best practices in data integration, reporting, and transformation, and drive their adoption within the team. Qualifications: - Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent work experience). - 7+ years of proven experience as an Integration Developer, with a focus on MuleSoft Anypoint Platform, plus strong SQL Server expertise and exposure to Microsoft Fabric. - Exceptional understanding of integration concepts, data transformation strategies, and report development. - Proficiency in designing and implementing complex integration workflows using MuleSoft Anypoint Platform (Anypoint Studio, API Manager, and Runtime Manager), including secure API design and deployment patterns. - Experience with data ingestion, cleansing, validation, and transformation using SQL Server and/or Microsoft Fabric (e.g., Lakehouse/Warehouse, Dataflows Gen2, Data Pipelines, notebooks, pyspark) or comparable modern data platforms. - Strong T-SQL skills including querying, optimization, and data modeling. - Strong leadership skills, problem-solving abilities, attention to detail, and a proactive approach to mentoring a team. - Excellent communication and collaboration abilities, with a demonstrated ability to lead, inspire, and drive results. Preferred Skills: - MuleSoft Anypoint Platform certification(s) (e.g., Developer, Platform Architect, Integration Architect) and experience with API governance, reusable assets, and CI/CD for Mule applications. - Experience with Microsoft Fabric and Azure data services (e.g., OneLake, Data Factory/Azure Integration Runtime patterns, Azure SQL) is a strong asset. - Experience working in a Scrum environment, collaborating effectively with cross-functional teams and delivering high-quality results within agile frameworks. - Familiarity with cloud platforms (e.g., Azure, AWS) and microservices architecture is advantageous.