CITARELLA OPERATINGS LLC

Business Intelligence - Data Engineer

CITARELLA OPERATINGS LLC New York, New York, United States · $80K–$95K/yr

Food and Beverage Services · 501-1,000 employees

4 h ago
data-engineer Mid (2-5 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The role involves building and maintaining data pipelines, reporting solutions, and automated processes using the Microsoft ecosystem. You will collaborate with various departments to translate business needs into effective dashboards, semantic models, and data-driven insights.

What they look for

Power BI Microsoft Fabric Power Query DAX SQL Power Automate SharePoint Microsoft Lists Excel Python Pandas Data Modeling ETL ELT Forecasting Statistical Analysis

Requirements

Candidates should have strong technical proficiency in Power BI, SQL, and the Microsoft Power Platform. Experience with data modeling, ETL processes, and the ability to clean and validate complex datasets is essential for success in this position.

Full description

Responsibilities

  • Build and maintain reporting and data solutions used across the business.
  • Work with data from ERP systems, Excel files, SharePoint, Microsoft Lists, third-party platforms, and other operational sources.
  • Prepare, clean, combine, and validate data before it is used for reporting.
  • Build and maintain Power BI reports, dashboards, semantic models, and KPIs.
  • Create and maintain data pipelines and transformation processes.
  • Automate repetitive reporting and operational tasks.
  • Troubleshoot data issues and reconcile differences between systems.
  • Support recurring reporting as well as ad hoc business requests.
  • Work with different departments to understand their needs and turn them into useful reporting or automation solutions.
  • Improve existing processes by simplifying them, removing unnecessary manual work, and finding more reliable ways of doing things.
  • Document important processes, business rules, and reporting logic.
  • Take ownership of projects from understanding the problem through implementation and validation.

Tools and Technical Skills

The role works primarily within the Microsoft data and reporting ecosystem.

Main tools

  • Power BI
  • Microsoft Fabric
  • Power Query / M
  • DAX
  • SQL
  • Power Automate
  • SharePoint
  • Microsoft Lists
  • Excel

Additional useful skills

  • Python / Pandas
  • Data modeling
  • ETL / ELT
  • External data sources
  • Forecasting and statistical analysis
  • Microsoft Power Platform

Similar roles