Data Integration & Automation Engineer

Citrin Cooperman

. Design, build, and deploy integrations between business systems, Dataverse, Azure, and Microsoft Fabric .

Posted 11/11/2026full-timeRemote • United StatesMid-LevelSenior💰 $150,000 - $185,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and deploying integrations using Microsoft Azure, Power Platform, and Dataverse, with a strong focus on data governance and automation. Proficient in managing end-to-end data migrations and ensuring system reliability through effective troubleshooting and monitoring.

Highest-signal resume keywords

Microsoft Azure IntegrationPower Automate AutomationDataverse IntegrationData Migration Project ManagementSQL Proficiency

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

C#/.NET DevelopmentREST API IntegrationData CleansingError Handling ImplementationIntegration Design StandardsEvent-Driven Integration PatternsBatch Integration PatternsData GovernanceLogging and Retry LogicField Mapping

Soft Skills

Clear CommunicationReliability FocusedDetail-OrientedSelf-Directed

Tools & Technologies

Microsoft FabricAzure Data FactoryAzure DevOpsGitPower AppsDynamics 365SAPCopilotModel Context Protocol (MCP)

Certifications & Qualifications

Microsoft Certified: Power Platform Solution Architect Expert (PL-600)Power Platform Developer Associate (PL-400)Azure Developer Associate (AZ-204)Fabric Data Engineer Associate (DP-700)

Industry Keywords

Systems IntegrationData EngineeringERP IntegrationCloud PlatformsAutomation

Tech Stack

Tools & technologies

AzureCloudERPSQL.NET

About the role

Key responsibilities & impact

Design, build, and deploy integrations between business systems, Dataverse, Azure, and Microsoft Fabric
Choose real-time, event-driven, or batch integration patterns based on business needs
Automate manual business processes using Power Automate, Power Apps, and Dataverse plugins
Implement error handling, logging, and retry logic
Plan and execute data migrations from legacy and on-premises systems, including source analysis, field mapping, data cleansing, reconciliation, and cutover planning
Gather requirements and map current processes with business stakeholders
Recommend solutions and explain design options, costs, risks, scope, and timelines in plain language
Monitor integration and workflow health, troubleshoot failures, identify root causes, and meet data-delivery SLAs
Apply data governance, security, and access controls, including Microsoft Entra ID and role-based access
Prepare governed and documented data for safe use by Copilot and other AI tools
Establish and follow integration and automation design and coding standards
Manage solutions in Git and Azure DevOps
Use automated deployments across environments
Review the work of other engineers
Own integrations from design through daily operation

Requirements

What you’ll need

Bachelor’s degree in information technology, computer science, information systems, or equivalent practical experience
5+ years of professional experience in software development, systems integration, or data engineering
At least 3 years building integrations or automation on Microsoft Azure or Power Platform
Hands-on experience integrating ERP systems such as Dynamics 365, SAP, or similar with cloud platforms
At least one end-to-end data migration project
Strong proficiency with Power Automate, Power Apps, Dataverse, and Azure Integration Services
Working experience with Microsoft Fabric, Azure Data Factory, or Azure Synapse Analytics
Strong SQL skills
Development experience in C#/.NET and REST APIs
Experience with Dataverse plugins or custom connectors
Experience gathering requirements, presenting design options, and managing scope with business stakeholders
Familiarity with Git, Azure DevOps, and CI/CD for Power Platform and Azure solutions
Preferred certifications: Microsoft Certified: Power Platform Solution Architect Expert (PL-600), Power Platform Developer Associate (PL-400), Azure Developer Associate (AZ-204), Fabric Data Engineer Associate (DP-700)
Preferred experience with data governance and security for AI and Copilot solutions, including Model Context Protocol (MCP) servers
Self-directed, clear communicator, reliability-focused, and detail-oriented

Benefits

Comp & perks

Competitive compensation and benefits
Flexible work arrangements to manage personal and professional life
Professional development support
Collaborative and innovative work environment