Business Intelligence - Data Engineer

CITARELLA OPERATINGS LLC•New York, NY

17h•$80,000 - $95,000

About The Position

This role focuses on building and maintaining reporting and data solutions across the business, leveraging the Microsoft data and reporting ecosystem. The Data Engineer will work with various data sources, prepare and clean data, develop Power BI reports and dashboards, create and maintain data pipelines, and automate tasks. The position involves collaborating with different departments to understand their needs and translate them into effective reporting or automation solutions, while also improving existing processes and documenting logic. The role requires taking ownership of projects from conception to completion.

Requirements

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

Nice To Haves

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

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.