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 Robust 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