Business Intelligence Developer

PGNA INC•Cranberry Township, PA

1d•Onsite

About The Position

PiovanGroup is a world leader in the development and production of systems for the automation of production processes for the storage, transport and treatment of polymers, plastic, and food powders. The Piovan Group shared services organization provides best in class manufacturing and business support services to its brands in order to create a competitive advantage for each of the brands to drive better solutions for customers. Our businesses include Conair, the leading producer of auxiliary equipment for plastics processing, Thermal Care, a leading provider of industrial heat transfer solutions, and Pelletron, a leading supplier of pneumatic conveying equipment and dust removal systems. The Business Intelligence Developer is responsible for managing and optimizing SQL databases, developing robust data models, and creating high-quality Power BI dashboards and reports that support business decision-making. This role works closely with cross-functional teams to ensure data accuracy, improve reporting capabilities, and deliver insights that enhance operational performance across the organization. This position will report to the Software Applications Director and will report to the Cranberry Township, PA location.

Requirements

3–5+ years of experience with SQL Server or similar relational database platforms.
Strong SQL development skills (queries, joins, views, stored procedures, optimization).
Experience with Power BI or comparable BI platforms such as Tableau, Looker, Qlik, or MicroStrategy.
Experience designing semantic or metrics layers (e.g., Power BI datasets, LookML, Tabular models, SSAS, dbt metrics).
Proficient with DAX, Power Query (M), and data transformations.
Ability to understand business processes and translate them into reporting solutions.

Nice To Haves

Experience integrating SQL with enterprise systems (SAP, M2M, Salesforce, CPQ, etc.).
Familiarity with Azure SQL, Power BI Gateways, or cloud-based data platforms.
Knowledge of ETL tools or scripting languages (Python, SSIS, ADF, etc.).
Experience working with data warehouses such as SQL Server, Snowflake, Redshift, BigQuery, or Azure Synapse.

Responsibilities

Design, write, and optimize SQL queries, stored procedures, functions, and views.
Manage data extraction, transformation, and loading (ETL) processes to support reporting and analytics.
Troubleshoot performance issues, indexing problems, and data integrity errors.
Maintain and improve existing SQL databases used by applications and reporting platforms.
Build, publish, and maintain Power BI dashboards and paginated reports.
Create semantic data models, including relationships, measures, and DAX calculations.
Optimize Power BI datasets for performance, refresh reliability, and ease of use.
Implement row-level security and workspace governance standards.
Partner with business stakeholders to understand reporting requirements and translate them into technical solutions.
Collaborate with application teams (Salesforce, Oracle CPQ, SAP, JobRouter, etc.) to integrate data sources and validate outputs.
Document database structures, data flows, and reporting processes.
Ensure data accuracy, consistency, and compliance across all reporting environments.
Monitor scheduled data refreshes, troubleshoot failures, and maintain reliability.
Assist in establishing data governance best practices and report cataloging.
Other duties as assigned.