Data Analyst

Watts Water; Massachusetts; On-site; USD 90,000 - 130,000; Full time

Job summary

Watts Water in Massachusetts is seeking an experienced Data Analyst to bridge business stakeholders, analytics teams, and data engineering. You will analyze SAP data structures, validate data, and contribute to enterprise reporting modernization.

You will help design scalable data models, support UAT, and ensure governance across SAP and non-SAP platforms as Watts transitions toward SAP BDC, Datasphere, and Databricks.

Qualifications

• Bachelor’s degree in information systems, computer science, engineering, business analytics, or equivalent.
• 5+ years as a Data Analyst, Analytics Consultant, or similar role.
• Strong knowledge of SAP data structures and business processes with SAP modules MM SD PP WM/EWM FI/CO.
• Experience gathering and documenting business requirements and functional specifications.
• Hands-on data validation and reconciliation with ERP source systems.
• Experience with enterprise data warehouses and analytics platforms.
• Understanding of data modeling, data lineage, and data governance.

Responsibilities

• Gather, analyze, and document business and reporting requirements from stakeholders.
• Translate requirements into data, analytics, and reporting solutions.
• Develop understanding of SAP processes and underlying data structures.
• Validate and reconcile analytics data against SAP sources for accuracy.
• Perform data quality assessments and root cause analyses across SAP and non-SAP platforms.
• Collaborate with Data Engineers, Architects, and Reporting Teams to design scalable enterprise data models.
• Support conceptual, logical, and physical data model design for analytics solutions.
• Create source-to-target mappings and data transformation requirements.
• Participate in data warehouse modernization involving BDC, Datasphere, Databricks, and cloud analytics.
• Support UAT, business validation, and production deployment activities.
• Ensure analytics solutions align with governance standards and business needs.
• Work with business users to resolve data/reporting issues and improve analytics adoption.

Skills

SAP data structures

Business processes

Data modeling

Data governance

Stakeholder management

Analytical abilities

Communication skills

Education

Bachelor's degree in Information systems, Computer Science, Engineering, Business Analytics, or equivalent

Tools

SAP

SAP Business Data Cloud (BDC)

SAP Datasphere

SAP BW/HANA

Databricks

Azure Data Lake

Power BI

Jira

Job description

We're Watts. Together, we're reimagining the future of water.We feel proud every day about what we do. We're all part of the same crucial mission, no matter what function we support -- it's to provide safe, clean water for the world, and to protect our planet's most valuable resource.

What we do

For 150 years, Watts has built best-in-class products that are trusted by customers in residential and commercial settings across the world. We are at the forefront of innovation, working with cutting-edge technology to provide smart and connected, sustainable water solutions for the future. Watts is a leading brand with a quality reputation - and we have a dynamic future ahead.

Scope of Position

We are seeking an experienced Data Analyst to serve as a critical link between business stakeholders, analytics teams, and data engineering teams. The ideal candidate will have strong expertise in SAP data structures, business process analysis, data validation, analytics, and enterprise data modeling.

This role will be responsible for gathering business requirements, validating data across SAP and non-SAP systems supporting enterprise reporting initiatives, and partnering with Data Engineers to design scalable data models that enable trusted analytics and reporting. The candidate will play a key role in our ongoing transition from a traditional SQL-based data warehouse environment to a modern SAP Business Data Cloud (BDC) and Databricks ecosystem.

Primary Job Duties and Responsibilities

• Gather, analyze, document business, and reporting requirements from stakeholders across various business functions.
• Translate business requirements into data, analytics, and reporting solutions.
• Develop a strong understanding of SAP business processes and underlying data structures.
• Validate and reconcile analytics data against SAP source systems to ensure reporting accuracy and consistency.
• Perform data quality assessments, root cause analysis, and data validation across SAP and non-SAP platforms.
• Analyze source data and business processes to identify gaps, risks, and improvement opportunities.
• Collaborate with Data Engineers, Architects, and Reporting Teams to design scalable enterprise data models.
• Support conceptual, logical, and physical data model design for analytics and reporting solutions.
• Create source-to-target mappings, business rules, and data transformation requirements.
• Participate in data warehouse modernization initiatives involving BDC, Datasphere, Databricks, and cloud analytics platforms.
• Support User Acceptance Testing (UAT), business validation, and production deployment activities.
• Ensure reporting and analytics solutions align with business requirements and governance standards.
• Work closely with business users to resolve data and reporting issues and improve analytics adoption.

Required Qualifications

• Bachelor's degree in Information systems, Computer Science, Engineering, Business Analytics, or equivalent field required.
• 5+ years of experience as a Data Analyst, Analytics Consultant, or similar role.
• Strong knowledge of SAP data structures and business processes with SAP modules such as: MM (Materials Management), SD (Sales & Distribution), PP (Production Planning), WM/EWM and Finance (FI/CO).
• Experience gathering and documenting business requirements and functional specifications.
• Hands-on experience validating and reconciling reporting and analytics data with ERP source systems.
• Experience working with enterprise data warehouses and analytics platforms.
• Strong understanding of data modeling concepts, data lineage, and data governance principles.
• Ability to analyze business requirements from both SAP and non-SAP perspectives.
• Experience working with cross-functional stakeholders, business users, and technical teams.
• Experience documenting requirements, business processes, and functional specifications.
• Excellent stakeholder management, analytical, problem-solving, and communication skills.

Preferred Qualifications

• Experience with SAP Business Data Cloud (BDC), SAP Datasphere, SAP BW/HANA, or similar SAP analytics platforms.
• Strong SQL skills for complex data analysis, data validation, data profiling, troubleshooting, and reconciliations.
• Experience with Databricks, Azure Data Lake, or cloud-based data and analytics platforms.
• Experience supporting Power BI datasets, semantic models, and reporting solutions.
• Knowledge of dimensional modeling, star schemas, Fact and dimension design principles.
• Experience working in Agile/Scrum environments using Jira

General Applicable Company Competencies

• Commitment to Watts' values of integrity, accountability, continuous improvement and innovation, and transparency.
• Punctuality and dependability.
• Ability to be flexible and adapt to changing work priorities and stressful conditions.
• Adherence to all personnel policies, procedures, and standards of process as implemented by Watts.
• Maintain productive and collaborative relationships with other Watts employees.
• Adherenc