Data Integration & Automation Engineer (53215)

Citrin Cooperman offers a dynamic work environment, fostering professional growth and collaboration. We're continuously seeking talented individuals who bring a problem-solving mindset, fresh perspectives, and sharp technical expertise. We know you have choices, so our team of collaborative, innovative professionals are ready to support your professional development. At Citrin Cooperman, we offer competitive compensation and benefits and most importantly, the flexibility to manage your personal and professional life to focus on what matters most to you!

We are actively building a Data Operations team to establish and scale our foundational enterprise data platform using Microsoft Fabric. We are looking for a self-directed Data Integration & Automation Engineer to design, build, and own the integrations and automated workflows that connect our business systems to that platform and to the people who rely on it.

In this role, you will be a key part of our operational core, focusing on the integration and automation work that keeps data moving reliably between systems. You will work across Microsoft Fabric (OneLake, Data Factory, and Notebooks), Microsoft Power Platform (Power Automate, Power Apps, and Dataverse), and Azure Integration Services (Azure Functions, Logic Apps, and Service Bus) to connect enterprise systems and legacy on-premises systems, third-party APIs, and business teams. Working closely with our Data Engineers, you will take ownership of integrations from design through daily operation, meet directly with business stakeholders to turn their process needs into technical designs, and exercise independent judgment in choosing tools and design patterns. The ideal candidate is an experienced builder who can explain technical trade-offs in plain business terms, works well without close supervision, and treats every integration as a system someone will have to support long after go-live.

Responsibilities are, but not limited to:

• Integration Design & Development: Design, build, and deploy integrations between business systems, Dataverse, Azure, and Microsoft Fabric using Azure Functions, Logic Apps, Service Bus, and Fabric Data Factory, choosing between real-time, event-driven, and batch patterns based on business need.
• Process Automation: Turn manual, error-prone business processes into automated workflows using Power Automate, Power Apps, and Dataverse plugins, with proper error handling, logging, and retry logic.
• Data Migration: Plan and carry out data migrations from legacy and on-premises systems, including source analysis, field mapping, data cleansing, reconciliation, and cutover planning.
• Stakeholder Engagement & Requirements: Work directly with business stakeholders to gather requirements, map current processes, and recommend solutions. Explain design options, costs, and risks in plain language, and set realistic expectations on scope and timelines.
• Operational Monitoring & Support: Take ownership of the health of integrations and automated workflows. Monitor runs, troubleshoot failures, find root causes, and ensure Service Level Agreements (SLAs) for data delivery are consistently met.
• Data Security & AI Readiness: Apply data governance, security, and access controls (including Microsoft Entra ID and role-based access) to all integrations and automations. Help prepare governed, well-documented data that Copilot and other AI tools can use safely.
• Standards, Version Control & CI/CD: Set and follow design and coding standards for integration and automation work. Manage solutions in Git and Azure DevOps, use automated deployments across environments, and review the work of other engineers.

The ideal candidate must have:

• Bachelor's degree in information technology, computer science, information systems, or equivalent practical experience.

• Preferred Certifications:

• Microsoft Certified: Power Platform Solution Architect Expert (PL-600)

• Microsoft Certified: Power Platform Developer Associate (PL-400)

• Microsoft Certified: Azure Developer Associate (AZ-204)

• Microsoft Certified: Fabric Data Engineer Associate (DP-700)

• 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, SAP, or similar) with cloud platforms, including at least one data migration project from start to finish.

• Strong proficiency with Power Automate, Power Apps, Dataverse, and Azure Integration Services (Azure Functions, Logic Apps, and Service Bus).

• Working experience with Microsoft Fabric, Azure Data Factory, or Azure Synapse Analytics, along with strong SQL skills.

• Development experience in C# / .NET and REST APIs, including Dataverse plugins or custom connectors.

• Experience working directly with business stakeholders: gathering requirements, presenting design options, and managing scope.

• Familiarity with source control (Git), Azure DevOps, and CI/CD for Power Platform and Azure solutions.

• Preferred: experience with data governance and security for AI and Copilot solutions, including Model Context Protocol (MCP) servers.

• The following personal attributes:

• Self-Directed: Takes a loosely defined business problem and turns it into a working solution without needing step-by-step direction. Knows when to make a decision alone and when to bring others in.

• Clear Communicator: Explains technical options, trade-offs, and risks to non-technical stakeholders in plain language, and pushes back when a request will cause problems later.

• Reliability-Focused: Values stability and predictability. Understands that the best integration is one nobody has to think about because it runs, alerts, and recovers as designed.

• Detail-Oriented: Cares about field mapping, error handling, and naming conventions, knowing that a small mistake in one integration spreads to every system downstream.