BI Developer

Hollingsworth & Vose; Walpole (MA); On-site; USD 89,000 - 121,000; Full time

Job summary

Hollingsworth & Vose seeks a data analytics professional to transform data into actionable decisions across global operations. You will build Power BI reports, semantic models, and AI-enhanced features that drive margins and cost insights in a multi-site, multi-currency environment.

The role emphasizes collaboration with stakeholders, data integrity, and delivering trusted numbers for production and finance teams. On-site work at a manufacturing mill is required.

Qualifications

• 3–5 years building analytical Power BI reports and dashboards.
• Strong SQL with hands-on experience querying 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, and a genuine interest in AI features into reports.
• An analytical mindset and ability to frame insight for decision‑making.
• A strong communicator who partners with non‑technical stakeholders.
• Comfortable working on-site at a manufacturing mill.

Responsibilities

• Power BI dashboards and reports covering trend, variance, cost, and margin analysis with drill-through, drill-down, parameters, and dynamic filtering.
• Semantic models that hold up: accurate measures and KPIs, multi-site, multi-currency, imperial/metric, aligned to naming conventions.
• SQL against Oracle EBS and MES to source, validate, and shape data; publish-ready data.
• Develop against SSAS multidimensional cube for cross-ERP sales and margin analysis.
• Maintain and rationalize current SSRS reports as the future state takes shape.
• AI in production: integrate AI into Power BI and internal apps; natural-language Q&A, automated insights, anomaly detection.
• Listen first; partner with stakeholders to understand goals and deliver recommendations, not just charts.
• Trust in the numbers: data accuracy, documentation, and version control; production-ready and hand-off-ready.

Skills

Power BI

DAX

Semantic modeling

Performance tuning

Row-level security

SQL

Oracle

MDX

SSAS multidimensional

SSRS

AI tooling

Analytical mindset

Communication

Teamwork

On-site

Tools

Oracle E-Business Suite

MES

SSAS Cube

Power BI

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.