Data Analyst

Watts Water•North Andover, MA

9d•Remote

About The Position

Watts is seeking an experienced Data Analyst to connect business stakeholders, analytics teams, and data engineering teams. The role focuses on gathering business requirements, validating data across SAP and non-SAP systems, and partnering with Data Engineers to create scalable data models for trusted enterprise analytics and reporting. The analyst will support Watts’ transition from a traditional SQL-based data warehouse to a modern SAP Business Data Cloud (BDC) and Databricks ecosystem. The position involves analyzing and documenting business and reporting requirements; developing knowledge of SAP processes and data structures; validating, reconciling, and assessing data quality; and collaborating on enterprise data models and analytics solutions. The analyst will also support data warehouse modernization, User Acceptance Testing (UAT), business validation, production deployment, and resolution of data and reporting issues. The role is performed remotely in an office environment, with occasional travel to the Andover, Massachusetts office for meetings, training, or as directed by management. The expected salary range is $104,000–$117,000 per year. Watts describes its culture as team-oriented and supportive, with opportunities for learning and development.

Requirements

Bachelor’s degree in Information Systems, Computer Science, Engineering, Business Analytics, or an equivalent field.
At least 5 years of experience as a Data Analyst, Analytics Consultant, or in a similar role.
Strong knowledge of SAP data structures and business processes, including SAP MM, SD, PP, 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.
Excellent stakeholder management, analytical, problem-solving, and communication skills.
Commitment to Watts’ values of integrity, accountability, continuous improvement and innovation, and transparency.
Punctuality, dependability, flexibility, and ability to adapt to changing work priorities and stressful conditions.
Ability to meet the physical requirements described, including prolonged sitting and computer use, office mobility, reading and data entry, clear communication, use of standard office equipment, and occasional lifting and carrying of light objects.

Nice To Haves

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, and fact and dimension design principles.
Experience working in Agile/Scrum environments using Jira.

Responsibilities

Gather, analyze, and document business and reporting requirements from stakeholders across 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 analytics and reporting solutions align with business requirements and governance standards.
Work with business users to resolve data and reporting issues and improve analytics adoption.
Maintain productive and collaborative relationships with other Watts employees and follow applicable company policies, procedures, and standards.