Strong communication, analytical, and problem-solving abilities
Adept at managing the architecture, administration, and integration of solutions utilizing SQL-based Data Lake platforms, Microsoft SharePoint Online (SPO), and Power Platform technologies (Power Apps, Power Automate, Dataverse)
Deep understanding of technical systems, governance frameworks, and collaboration across both business and IT teams
Responsibilities
Facilitate Joint Application Development (JAD) sessions with Business Analysts and functional users to gather and comprehensively document functional requirements
Oversee governance and development standards related to the company’s Power Platform and SharePoint environments
Conduct analysis and design activities for application delivery
Identify data requirements and develop data models for applications
Support quality assurance efforts through the creation and execution of test and deployment plans
Contribute to the creation of technical documentation for applications
Design and configure automated business process workflows as needed
Participate in system signoff processes and fulfill all related change management requirements
Independently research and resolve help desk issues concerning core applications, collaborating with other Business Analysts when necessary
Develop and deliver training programs
Modify and enhance applications in accordance with established methodologies
Proactively identify opportunities to improve customer satisfaction and strengthen client relationships
Collaborate with European counterparts to ensure systems adhere to PII and Works Council guidelines
Provide ongoing quality assurance support before and after implementation
Architect, implement, and optimize SQL-based Data Lake solutions
Develop and maintain complex T-SQL queries, stored procedures, and ingestion pipelines
Collaborate with data engineers to ensure data availability, security, and quality
Support schema design, metadata strategies, and data modeling initiatives
Design and manage both model-driven and canvas Power Apps
Build scalable automations leveraging Power Automate
Administer Power Platform environments, including roles and DLP policies
Aid ‘Citizen’ developers by reviewing their designs and development approach including training
Design SharePoint Online architecture, including hub sites, metadata structures, and permissions
Modernize legacy SharePoint implementations to SharePoint Online
Maintain custom solutions utilizing SPFx, PowerShell, and PnP
Oversee tenant configurations, compliance, and lifecycle management
Define and enforce governance policies across the Microsoft 365 stack
Serve as a subject matter expert for transformation