Senior Analyst

Job Description:

• Design develop and deploy automated data remediation workflows using Power Automate Premium and Copilot Studio
• Create intelligent agents grounded in enterprise data using Model Context Protocol MCP and optimize prompt context schemas
• Write and optimize SQL queries and Python scripts within Microsoft Fabric Notebooks to support data validation transformation and
• correction
• Integrate with enterprise systems including Snowflake Dataverse Azure SQL and Microsoft Fabric Lakehouse Warehouse
• Develop custom connectors and integrate securely with REST APIs using OAuth 2
• 0 token based authentication and secure credential handling
• Parse transform and manipulate both JSON and XML payloads to support data operations and flow logic
• Build advanced Power Automate expressions for dynamic logic data validation branching and error handling
• Design Copilot experiences that are token efficient and grounded understanding LLM context windows prompt limits and AI response
• behavior
• Implement security and compliance best practices ensuring automations follow encryption access control and data handling standards
• Use Power Platform ALM tools e
• g
• GitHub Azure DevOps for solution deployment version control and environment management
• Monitor flow performance and automation KPIs optimize for cost reliability and data quality impact
• Collaborate with governance IT and business teams to align automation strategies with enterprise data integrity goals

Key Responsibilities:

• 3 years of experience building solutions with Power Automate Premium including premium custom connectors
• Experience building Copilot Studio agents grounded with MCP and optimized for enterprise use
• Proficient in SQL particularly with Snowflake and experienced with Python scripting in Microsoft Fabric
• Strong working knowledge of JSON and XML data handling
• Skilled in Power Automate expression building conditional logic and exception management
• Experience integrating with RESTful APIs using OAuth 2
• 0 token lifecycle management and secure secrets storage
• Understanding of Generative AI including prompt design token usage and AI output structuring
• Familiarity with Dataverse Azure SQL and Microsoft Fabric Pipelines Real Time Analytics and Lakehouse architecture
• Awareness of data security compliance and governance protocols in automated workflows
• Experience with Power Platform Change Management ALM including deploying solutions using GitHub or Azure DevOps

Technical Requirements:

• Experience with Snowflake automation features e
• g
• tasks streams stored procedures
• Understanding of semantic models dataflows and real time alerting
• Experience with GitHub Copilot or similar AI assisted development tools to accelerate scripting expression authoring and automation design
• Microsoft certifications PL 400 PL 500 Fabric Analytics Engineer Associate Azure Developer Associate or equivalent

Additional Responsibilities:

• Strong analytical mindset with attention to detail and a passion for clean accurate data
• Excellent collaboration and communication skills across technical and business teams
• Self starter who can manage complex automation and integration initiatives end to end

Preferred Skills:

Technology->SQL SSIS->SQL Server