SUMMARY

We are seeking a skilled and data-driven Business Analytics Engineer with advanced expertise in Power BI development, Power Automate, Power Apps, Excel, and complex queries to join our team. In this role, you will be responsible for analyzing data, developing reports, creating automated workflows, and designing applications to improve business processes. You will work closely with cross-functional teams to deliver insights that drive business decision-making, efficiency, and growth.

ESSENTIAL DUTIES AND RESPONSIBILITIES

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Exercise of judgment, discretion, and tact in all business matters and business relationships is required. Strong interpersonal skills and the ability to maintain clear and cooperative working relationships with co-workers and demonstrate regular attendance and punctuality are essential. The organization’s leadership promotes collaborative problem solving in both formal and informal work teams. Participation in and contribution to teamwork within the organization is required. Necessary interpersonal skills include being a self-starter, motivated, creative, flexible, self-confident, deadline oriented and able to multi-task. Employees must follow all quality and safety procedures of the company, including those at customer sites if applicable, and must abide by the corporate Code of Conduct in all situations.

Supervisory Responsibilities

None.

Duties

1. Data Analysis & Reporting: Gather, analyze, and interpret complex datasets to create actionable insights.
2. Develop advanced, visually appealing, and interactive dashboards and reports using Power BI.
3. Ensure data integrity and accuracy by implementing best practices in data visualization and reporting.
4. Automation & Process Improvement: Design and implement automated workflows using Power Automate to streamline business processes and improve operational efficiency.
5. Develop custom applications using Power Apps to support specific business needs, improving accessibility and data management.
6. Excel & Query Development: Utilize advanced Excel skills, including formulas, pivot tables, and VBA scripting, to manage and analyze large datasets.Write and optimize complex queries to extract and manipulate data from various sources (e.g., SQL databases, cloud platforms).
7. Collaboration & Stakeholder Engagement: Work closely with stakeholders to understand business requirements, identify opportunities for improvement, and recommend innovative solutions.
8. Collaborate with IT and business units to ensure seamless data integration, system functionality, and report accessibility.
9. Documentation & Training: Document processes, workflows, and best practices for reporting, automation, and app development.
10. Train end-users and business teams on how to effectively use reports, workflows, and applications you develop.
11. Mathematical Modeling: Utilizing mathematical models for building forecast and capacity models. Developing predictive models to analyze trends and optimize operational processes.
12. Performing data mining and statistical analysis to identify key performance indicators (KPIs) and business insights.
13. Data Quality: Implement data quality checks, monitoring, and validation processes to ensure data accuracy and consistency across the date pipeline.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

90% noise and temperature-controlled office environment, 10% shop-floor production areas. Routine lifting, carrying and pushing up to 25 lbs. Must wear safety glasses and face-shield while working near or around grinders, polishers, bead-blasting, etc. Must wear hearing protection where required.

Tasks require walking, sitting, bending, reaching, mobility, frequent lifting and pushing/pulling. Work requires computer skills (word processing, spreadsheet, and data-entry), attention to detail and accuracy. Communication skills including listening and speaking are required for interaction with other employees, vendors, and customers. Strong interpersonal skills, the ability to balance multiple tasks and any stress associated with the duties and responsibilities of this position are essential requirements in the performance of this job.

Secondary duties with added requirements may be assigned from time to time.

POSITION REQUIREMENTS

Company Values

Pfeiffer Vacuum V&E believes that we are all suppliers and customers of someone in our organization. Our employees must be able to demonstrate this customer-centric belief - which means that you are value-adding, reliable, performance-driven, innovative, service-minded, and agile – in all of their business activities. We expect that our company values of open mindedness, trust, communication, thinking strategically/being creative, being courageous, accountable, and humble, ethical sensitivity/compliance, resilience/facing diversity and fostering a culture of empowerment, engagement and collaboration will drive the actions of our employees.

General Qualifications

1. Advanced proficiency in Power BI development (DAX, Power Query, visualizations).
2. Expertise in Power Automate for workflow automation and process improvement.
3. Experience with Power Apps for building and deploying custom business applications.
4. Strong knowledge of Microsoft Excel (advanced formulas, pivot tables, VBA) and query writing.
5. Experience with SQL or other relational database systems is a plus.
6. Strong analytical mindset with excellent problem-solving abilities.
7. Ability to translate complex data into meaningful insights and recommendations.
8. Experience with data integration from multiple sources (e.g., APIs, ERP systems) is preferred.
9. Knowledge of project management tools or methodologies is preferred.
10. Familiarity with cloud-based platforms (e.g., Onedrive, Azure, SharePoint) is preferred.

Education and/or Experience

1. Any combination of education and training, equivalent to graduation from an accredited college/university with a bachelor’s degree in business, Information Systems, Data Analytics, or a related field.
2. Minimum of 3-5 years of experience in a Business Analytics Engineer or similar role, with a strong focus on data analysis, reporting, and process improvement.

Language Skills

Excellent verbal and written communication skills.

Mathematical Skills

Basic mathematics skills.

Reasoning Ability

High attention to detail and the ability to manage multiple priorities in a fast-paced environment.

Certificates, Licenses, Registrations

None.

TOOLS AND/OR EQUIPMENT

None.

WORK ENVIRONMENT

This position may work in various environments including office, factory, or home settings. Employees who choose to work from home are expected to comply with all company requirements for core work hours or in-person attendance at company meetings or events. (As applicable)

Pfeiffer Vacuum V&E is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender, gender identity, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified individual with disability.

If you are an individual with disabilities who needs accommodation or you are having difficulty using our website to apply for employment, please contact Danielle Clair at 530-841-9150.