Scope of PositionWe 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 modernSAP 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.
- Adherence to Watts' seven cultural beliefs: Growth Mindset, Customer-Focused Innovation, Constant Communication, Clear Goals, Collaborate Globally, Be Inclusive, and Take Action.
Working ConditionsWhile performing the job duties, you will be working remotely in an office environment. You may be required to occasionally travel to and work in the office at the Andover, MA location for meetings, trainings, or as otherwise required by Company management.
Physical Requirements: Specific physical abilities required for this position include, but are not limited to:
- Ability to remain seated at a desk or workstation for extended periods.
- Ability to perform repetitive tasks like typing on a keyboard or using a mouse for extended periods.
- Ability to physically move around the office, organize or transport files, packages, or other office-related materials.
- Ability to read documents, use a computer, and perform data entry tasks.
- Ability to communicate clearly with management and coworkers, particularly in meetings or phone calls.
- Ability to operate standard office equipment such as computers, printers, phones, and copiers.
- Ability to occasionally lift and carry light objects, such as office supplies, documents, or small equipment.
Pay RangeThe expected salary range for this position is $104,000 - $117,000 yearly. Actual compensation will be dependent upon individual skills, experience, qualifications, and applicable law.
Nothing in this job description restricts Watts' right to assign or reassign duties, responsibilities, and working hours/conditions to this position at any time. This position is "at will," which means that either the employee or Watts may terminate the employment relationship at any time, with or without notice, and for any lawful reason.
#LIRemoteWatts in it for you:
Please note that the following benefits apply only to permanent roles and do not apply to internship roles.- Competitive compensation based on your skills, qualifications and experience
- Comprehensive medical and dental coverage, retirement benefits
- Family building benefits, including paid maternity/paternity leave
- 10 paid holidays and Paid Time Off
- Continued professional development opportunities and educational reimbursement
- Additional perks such as fitness reimbursements and employee discount programs
- Learn more about our benefit offerings here: https://tapintowattsbenefits.com/
