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.

Duties and Requirements

Key Responsibilities

Database & SQL Development

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

Power BI Reporting & Analytics

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

Cross-Functional Collaboration

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

Data Quality & Governance

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

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.

Preferred Experience:

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

Core Competencies:

• Analytical and detail-oriented
• Strong problem-solving skills
• Clear communication of technical concepts to non-technical users
• Ability to manage multiple priorities and meet deadlines
• Commitment to data accuracy, quality, and reliability

PiovanGroup offers an outstanding compensation and benefits package including profit sharing, bonus plans, 401(k) with company match, medical insurance, dental, vision, life insurance, short- and long-term disability, health club reimbursement, tuition reimbursement, employee assistance, and employee referral bonus program.

PiovanGroup is an Equal Opportunity Employer (EOE) and offers employment opportunities to all qualified persons regardless of race, color, religion, sex, age, national origin or ancestry, physical or mental disability (except where physical or mental abilities are a bona fide occupational requirement), veteran status, marital status, familial status, sexual orientation, HIV-positive status, possession of the sickle cell trait, genetic characteristics, political views, and any other basis protected by federal, state or local laws.