BI Developer

Hollingsworth & Vose; East Walpole (MA); On-site; USD 95,000 - 116,000; Full time

Job summary

Hollingsworth & Vose seeks a data analytics professional to turn complex manufacturing data into trusted insights. You will build Power BI reports and semantic models, source data from Oracle EBS and MES, and leverage SSAS cubes for cross-ERP analysis.

AI features will be embedded into reports and applications to enable automated insights. You will partner with stakeholders, ensure data accuracy, and deliver production-ready analytics you can trust, with a focus on margins and cost controls

Qualifications

• 3–5 years building analytical Power BI reports and dashboards.
• Strong SQL with Oracle databases.
• Experience consuming SSAS multidimensional cubes from Power BI, including MDX.
• SSRS report development or maintenance experience.
• Hands-on use of AI tools in your development work (tool‑agnostic).
• Analytical mindset with focus on decision‑making.
• Strong communicator who works with non‑technical stakeholders.

Responsibilities

• Analytics people rely on: Power BI dashboards and reports with drill-through and dynamic filtering.
• Develop semantic models, KPIs, and multisite data handling.
• Source, validate, and shape data using SQL against Oracle EBS and MES.
• Develop against central SSAS cube for cross-ERP analysis.
• Maintain and rationalize the SSRS estate.
• Build AI features into Power BI and internal apps.
• Partner with stakeholders to deliver actionable recommendations.

Skills

Power BI

SQL

MDX

SSRS

AI in reports

Stakeholder comms

Tools

Oracle EBS

MES

SSAS multidimensional

Job description

H&V is a global leader in filtration and energy storage solutions. Our advanced materials are used in nearly every industry and touch every aspect of modern life. Wherever you work, live or travel, chances are an H&V solution is close by, contributing to a cleaner, healthier, more sustainable world. H&V serves the world from 13 strategically located facilities. Our footprint in the Americas, Europe and Asia lets us meet the unique requirements of global and regional customers efficiently, accurately and cost effectively, while capturing supply chain efficiencies. These advantages help make H&V a valuable partner and a true worldwide leader. Our success comes from our ability to adapt, our values and the people of H&V. We act with integrity, and we treat customers, partners and each other with dignity and respect. We live these values every day and could not have prospered for more than 200 years without them.

Role Purpose

Your job is to turn data into decisions. Hollingsworth & Vose is a global specialty manufacturer with mill operations across the Americas, Europe, and Asia — and the people running those operations, from the mill floor to senior management, need numbers they can trust and analytics they can act on. You build those.

A dashboard is not the outcome. The outcome is a plant manager who catches a margin problem a month earlier, or a finance team that stops arguing about whose number is right. We measure this role by results that matter to the business, not by reports shipped. Trust is the product — you treat it that way.

This is also a role for someone who wants to build with AI, not just read about it. We are embedding AI into how IT delivers — natural-language access to data, automated insights, AI-assisted development — and this role sits at the center of that work.

What You Own

• Analytics people rely on. Power BI dashboards and reports covering trend, variance, cost, and margin analysis — with drill-through, drill-down, parameters, and dynamic filtering that let people answer their own next question.
• Semantic models that hold up. Accurate models, measures, and KPIs. Multi-site, multi-currency, imperial/metric — handled correctly, to our site and item naming conventions, every time. If two reports disagree, that’s your problem to run down.
• The data behind the numbers. Strong SQL against Oracle EBS and our MES database to source, validate, and shape data. You verify before you publish — and when a number is wrong, “the source data was bad” is where your job starts, not where it ends.
• The sales cube. Develop against our central SSAS multidimensional cube (live connection / MDX) for cross-ERP, multi-currency sales and margin analysis.
• The existing SSRS estate. Maintain and rationalize current SSRS reports while the future state takes shape.
• AI in production. Build AI features into Power BI and our internal applications — natural-language Q&A, automated insights, anomaly detection, AI-assisted workflows — and use AI tools daily in your own development.
• The relationship. You listen first. You partner with stakeholders to understand the goal behind the question, and you deliver recommendations, not just charts. Nobody who depends on your work waits in the dark for a status update.
• Trust in the numbers. Data accuracy, documentation, and version control. Done means running in production, validated against source, documented, and handed off.

The Environment You’ll Work In

We’re honest about this: it’s a real manufacturing systems landscape, not a greenfield. The craft here is turning a complex environment into analytics people trust — if that sounds like work worth doing, you’ll like it here.

• Oracle E-Business Suite — OPM process and discrete manufacturing (recipes, batches, inventory, standard costing), AP/AR/GL, and order management, with significant in-house customization.
• A manufacturing execution system (MES) — sales orders, machine utilization, mill cost, raw-material consumption, quality metrics, and production scheduling.
• A central SSAS multidimensional sales cube aggregating data across ERP systems, with multi-currency and standard-vs-actual cost and margin analysis.
• Reporting today is largely SSRS and Power BI; AI tooling is expanding rapidly.

Required

• 3–5 years building analytical Power BI reports and dashboards — DAX, semantic modeling, performance tuning, row-level security.
• Strong SQL with hands‑on experience querying Oracle databases.
• Experience consuming SSAS multidimensional cubes from Power BI, including MDX — not tabular/DAX only.
• SSRS report development or maintenance experience.
• Hands‑on use of AI tools in your development work (tool‑agnostic), and a genuine interest in building AI features into reports and applications.
• An analytical mindset — you interpret data, spot trends, and frame insight for decision‑making.
• A strong communicator who partners well with non‑technical stakeholders and works as part of a team.
• Comfortable working on‑site at a manufacturing mill.

Preferred

• Oracle E‑Business Suite experience, especially OPM process manufacturing.
• MES experience (Tieto TIPS a plus).
• Manufacturing or process‑industry domain knowledge — costing, recipes, production and quality data.
• Master data management (MDM) exposure — working with item, customer, or site master data across multiple systems, or contributing to data governance and standardization efforts.
• Power Query / dataflows, paginated reports, or Microsoft Fabric experience.

Hollingsworth & Vose is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, gender, sexual orientation, gender identity or expression, religion, national origin, marital status, age, disability, veteran status, genetic information, or any other protected status.

Starting salary at $105,000

Hollingsworth & Vose is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, gender, sexual orientation, gender identity or expression, religion, national origin, marital status, age, disability, veteran status, genetic information, or any other protected status.