BI Data Engineer: Power BI, Data Pipelines & Automation

Citarella; Northern, New York (KY, NY); Hybrid; USD 80,000 - 95,000; Full time

Job summary

Citarella in New York, NY, is seeking a Business Intelligence - Data Engineer to build and maintain reporting and data solutions across the business. You will work with data from ERP systems, Excel files, SharePoint, Microsoft Lists, and other operational sources to prepare, clean, and validate data for reporting.

Responsibilities include building Power BI reports, dashboards, and KPIs, creating data pipelines, automating repetitive tasks, and troubleshooting data issues.

Qualifications

• Build and maintain reporting and data solutions used across the business.
• 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.
• Document important processes, business rules, and reporting logic.
• Take ownership of projects from understanding the problem through implementation and validation.

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

Power BI

Tools

SharePoint

Microsoft Lists

Excel

ERP systems

Job description

Citarella in New York, NY, is seeking a Business Intelligence - Data Engineer to build and maintain reporting and data solutions across the business. You will work with data from ERP systems, Excel files, SharePoint, Microsoft Lists, and other operational sources to prepare, clean, and validate data for reporting.

Responsibilities include building Power BI reports, dashboards, and KPIs, creating data pipelines, automating repetitive tasks, and troubleshooting data issues.