Managing Director – U.S. Prudential Bank Regulatory Group
Citi
Engineer, Compliance Solutions
Ensemble Health Partners
full-time
Posted on:
Location: 🇺🇸 United States
Visit company websiteSalary
💰 $101,600 - $152,400 per year
Job Level
Mid-LevelSenior
Tech Stack
AzureSQL
About the role
- Copilot Studio & AI Agent Integration: Design, configure, and deploy Copilot Studio agents tailored for compliance and audit workflows. Embed AI-driven prompts and narrative generation within Power Apps and Power Automate to assist with assessments, control testing, and exception analysis.
- Power Platform Development: Build and maintain Canvas and Model-driven Power Apps; develop Power Automate flows for notifications, task assignments, and data synchronization.
- SQL-based Data Extraction & Reporting: Write complex SQL queries; create views/scripts; validate extracts with Data Engineering
- Reporting & Visualization: Develop Power BI dashboards and paginated reports; embed visuals in Power Apps for real-time insights
- Governance & Best Practices: Ensure security, access-control, data privacy; document specs and change-management
- Collaboration & Enablement: Train teams on Copilot-enhanced Power Apps/Power Automate; enable self-service analytics
- Compliance Investigations Support: Tools for case tracking, evidence collection, and documentation; analytics for root cause analysis
- Compliance & Internal Audit Support: Digitize risk assessments, control testing, audit planning; monitor findings and remediation; provide on-demand reporting
Requirements
- 3+ years developing low-code solutions using Power Apps and Power Automate
- Hands-on experience with Copilot Studio: designing agents and integrating them into Power Platform
- Strong SQL skills (joins, window functions, stored procedures) and experience with Azure Databricks
- Proficiency in Power BI for dashboard and report development
- Knowledge of HIPAA and SOX compliance and control-testing methodologies
- Excellent written and verbal communication skills
- Bachelor's degree or equivalent
