What are the responsibilities and job description for the Data Integration Specialist position at Welch Packaging Group Inc.?
SUMMARY
This role will be responsible for extracting, transforming, and integrating data from our ERP system into Power BI to support business intelligence and reporting needs. The ideal candidate will have experience with ETL processes, SQL, API integrations, and data modeling to ensure seamless data flow and accurate reporting. Strong problem-solving skills and the ability to collaborate with IT and business teams are essential.
ESSENTIAL FUNCTIONS
• Pulling data from the ERP system (e.g., SAP, Oracle, Microsoft Dynamics, or a specialized manufacturing ERP like Epicor).
• Cleaning, transforming, and organizing the data into a structured format suitable for reporting and analysis.
• Designing and managing Extract, Transform, Load (ETL) pipelines to move data from the ERP to a data warehouse or directly into Power BI.
• Creating dashboards, reports, and visualizations in Power BI or other Power Platform tools.
• Ensuring smooth integration between the ERP system and Power BI/Power Apps using APIs, connectors, or custom scripts.
• Working with stakeholders to understand data needs and develop actionable insights
REQUIREMENTS/QUALIFICATIONS
Education:
• High School Diploma or equivalent
• AA or BS in Technology or Computer Sciences or similar preferred
• Certifications in various ERP and/or Six Sigma a plus
Experience
• Experience with ERP data extraction and integration
• Proficiency in SQL, ETL tools, API’s and Power BI
• Experience with Windows operation systems
SPECIFIC KNOWLEDGE, SKILLS OR ABILITIES
• Strong written and oral communication.
• Organization and attention to detail.
• Analytical and problem-solving skills.
• Time management.
• Systems analysis.
• Mathematical and deductive reasoning.
• Critical thinking.
• Active learning.
PHYSICAL DEMANDS/WORK ENVIRONMENT
The physical demands described here are representative of those that must be met by an employee to successfully perform the functions of this job with or without reasonable accommodation.
The work environment characteristics described here are representative of those an employee encounters while performing the functions of this job.
Physical Requirements:
• Reaching above shoulder heights, below the waist or lifting as required to handle the technology equipment or store materials during the workday.
• Must be able to lift as much as 40 pounds and carry items such as monitors, PC’s and printers
Work Environment:
• Typical office environment
Welch Packaging is proud to be an equal opportunity workplace. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, or protected veteran.
