PiovanGroup North America · 17 hours ago
Business Intelligence Developer
Cranberry Township, PA
Full-time
Onsite
Mid, Senior Level
3+ years expPiovanGroup 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 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.
SustainabilityManufacturingAssistive TechnologyMachinery ManufacturingRecycling
Hiring Manager
Dawn Sobocinski
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
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 North America
Piovan North America serves as the regional headquarters for PiovanGroup, an Italian company and a global leader in the design and manufacture of industrial automation systems for the storage, conveying, and processing of plastics and various other products.
1001-5000 employees
H1B Sponsorship
PiovanGroup North America has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2020 (1)
Funding
Current Stage
Late StageRecent News
2024-11-30
Company data provided by crunchbase