Data Engineer, Development (52338)

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 seeking an Data Engineer, Development, to join our Development team within the Information Technology department. They’ll help design, construct, maintain, and optimize the core data pipelines that power our business intelligence, analytics, and downstream applications.

In this role, you’ll be a vital part of our operational “Base Plan”, focusing on the rigorous, traditional data engineering required to run a data-driven enterprise. You’ll work within the Microsoft Fabric ecosystem (OneLake, Notebooks, Data Factory) to move data from legacy on-premises systems and third-party APIs into clean, modeled, and highly available data products. Working closely with our Senior Data Engineers and Database Administrator, you’ll take ownership of daily pipeline health, troubleshoot failures, implement data quality checks, and exercise independent judgment in designing solutions and optimizing data workflows. The ideal candidate is a detail-oriented builder who takes pride in writing clean code, designing elegant data models, and ensuring the operational stability of mission-critical data infrastructure.

Responsibilities are, but not limited to:

• Pipeline Development: Design, build, and deploy robust ETL/ELT pipelines using Fabric Data Factory and Spark (PySpark/SQL) to ingest data from diverse sources into OneLake, determining appropriate technical approaches and design patterns.
• Data Modeling & Architecture: Implement and maintain the “Medallion Architecture” (Bronze, Silver, Gold layers). Transform raw data into structured, business-ready models (e.g., Star Schemas) optimized for Power BI and standard analytics, including recommending and refining data architecture standards.
• Operational Monitoring & Support: Take ownership of daily pipeline execution. Monitor system health, troubleshoot job failures, debug data anomalies, and ensure Service Level Agreements (SLAs) for data delivery are consistently met, applying discretion to resolve complex data and system issues.
• Data Quality & Governance: Develop and automate data quality validations and anomaly detection scripts to ensure stakeholders are always querying accurate, trustworthy information, designing solutions to proactively improve data integrity.
• Collaboration & Refactoring: Work closely with the Senior DBA to optimize query performance against source systems. Assist in refactoring legacy stored procedures and custom applications into modern, cloud-native Fabric workloads, contributing to technical design decisions and modernization strategies.
• Version Control & CI/CD: Write clean, modular, and well-documented code. Participate in code reviews and utilize Git for version control and automated deployment of data artifacts, following and helping to enhance engineering best practices.