Business Intelligence - Data Engineer

Citarella - The Ultimate Gourmet Market; New York (NY); On-site; USD 90,000 - 120,000; Full time

Job summary

Citarella - The Ultimate Gourmet Market seeks a data reporting specialist to build and maintain data-solutions across the business. You will work with data from ERP systems, Excel, SharePoint, and third-party sources to deliver reliable reports and dashboards.

You will prepare, clean, and validate data, create Power BI dashboards and KPIs, and automate recurring tasks while collaborating with multiple departments to translate needs into effective reporting solutions.

Qualifications

• Experience transforming data into actionable reports and visualizations.
• Ability to validate and clean data before reporting.
• Strong collaboration skills to understand stakeholder needs.

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.

Skills

Data analysis

Power BI

Reporting

Tools

Power BI

Excel

SharePoint

Microsoft Lists

ERP systems

Job description

• 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.