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:
- 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.
- 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.
- 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.
- 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.
- 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.
