Data Integration & Automation Engineer, Development (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.