Apply on Employer Site

PiovanGroup · 1 day ago

Business Intelligence Developer

Cranberry, PA

Full-time

Onsite

Mid, Senior Level

3+ years exp

PiovanGroup is a world leader in the development and production of systems for the automation of production processes. The Business Intelligence Developer is responsible for managing SQL databases, developing data models, and creating Power BI dashboards that support business decision-making and enhance operational performance.

Energy Efficiency

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

Qualification

SQL developmentPower BIETL processesDAXData modelingData governanceAnalytical skillsProblem-solvingCommunication skillsTime management

Required

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

Benefits

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

Employee referral bonus program

Company

PiovanGroup

PiovanGroup is a world leader in the design, manufacture and installation of systems that automate the storage, transport and processing of polymers, plastic powders and food ingredients.

Founded in 1934

Bromsgrove, Worcestershire, GBR

1001-5000 employees