Data Integration & Automation Engineer (53215)
Citrin Cooperman2 days ago
Remote, United StatesSenior
Base Salary
$150k - $185k/yr
Responsibilities
- Design, build, and deploy real-time, event-driven, and batch integrations between business systems, Dataverse, Azure, and Microsoft Fabric.
- Automate manual business processes with Power Automate, Power Apps, Dataverse plugins, error handling, logging, and retry logic.
- Plan and execute data migrations from legacy and on-premises systems, including source analysis, field mapping, cleansing, reconciliation, and cutover planning.
- Gather requirements from business stakeholders, map processes, recommend solutions, and communicate design options, costs, risks, scope, and timelines.
- Monitor integration and workflow health, troubleshoot failures, identify root causes, and meet data-delivery SLAs.
- Apply data governance, security, access controls, Microsoft Entra ID, and role-based access to integrations and automations.
- Establish integration and coding standards, manage solutions in source control, automate deployments across environments, and review other engineers’ work.
Requirements
- Bachelor’s degree in information technology, computer science, information systems, or equivalent practical experience.
- At least 5 years of professional experience in software development, systems integration, or data engineering, including at least 3 years building integrations or automation on Microsoft Azure or Power Platform.
- Hands-on experience integrating ERP systems such as Dynamics 365 or SAP with cloud platforms and completing at least one end-to-end data migration.
- Strong proficiency with Power Automate, Power Apps, Dataverse, and Azure Integration Services, including Azure Functions, Logic Apps, and Service Bus.
- Experience with Microsoft Fabric, Azure Data Factory, or Azure Synapse Analytics, along with strong SQL skills.
- Development experience with C#/.NET and REST APIs, including Dataverse plugins or custom connectors.
- Experience gathering requirements, presenting design options, managing scope, and working directly with business stakeholders.
- Familiarity with Git, Azure DevOps, and CI/CD for Power Platform and Azure solutions.
- Preferred certifications include Microsoft Certified: Power Platform Solution Architect Expert (PL-600), Power Platform Developer Associate (PL-400), Azure Developer Associate (AZ-204), and Fabric Data Engineer Associate (DP-700).
- Preferred experience includes data governance and security for AI and Copilot solutions, including Model Context Protocol servers.
- Ability to work independently, communicate technical trade-offs clearly, prioritize reliability, and maintain strong attention to implementation details.
Benefits
- Competitive compensation and benefits.
- Professional development support in a collaborative and innovative environment.
- Flexibility to manage personal and professional responsibilities.
About Citrin Cooperman
Citrin Cooperman is a privately held professional services firm providing audit, tax, accounting, and advisory services—including transaction advisory, valuation/forensics, wealth management, and cybersecurity—to middle-market companies and high-net-worth individuals. Founded in 1979 and headquartered in New York, it operates under an alternative practice structure (Citrin Cooperman & Company, LLP and Citrin Cooperman Advisors LLC) and is backed by Blackstone. The firm has 30+ offices and is a member of the Moore Global network.