Senior BI & Data Warehouse Analyst

MKS Inc.; United States; On-site; USD 130,000 - 180,000; Full time

Job summary

MKS, Inc. is seeking a Principal Business Systems Analyst to partner with business and IT teams, gathering BI requirements, mapping data, and creating report/dashboard wireframes.

You will analyze source data, identify gaps, and work with cross-functional teams to implement high-quality BI solutions under the Data Warehouse and BI Reporting leadership. You will lead requirements definition, BRDs/FSDs, testing (including UAT), and drive data integrity and end-user training to maximize BI

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field.
• 8+ years of IT, systems/data analysis, and SAP data warehouse experience.
• Strong understanding of data warehousing and ETL with SQL data analysis.
• Experience with SAP BW architectures (BW 7.x, BW on HANA, BW/4HANA).
• Experience with SAP Datasphere or cloud data warehouse solutions desired.
• Proficiency with reporting/visualization tools: SAP BusinessObjects, SAP Analytics Cloud, Power BI, Tableau.
• Knowledge of Sales & Distribution, Order-to-Cash, Procure-to-Pay, MM, and Finance (FICO) in manufacturing.
• Strong analytical, problem-solving, communication, and stakeholder management skills.

Responsibilities

• Gather, analyze, and document reporting and analytics requirements, converting business needs into functional specs and user stories.
• Design, develop, test, and implement data and reporting solutions to support enterprise BI initiatives.
• Lead BRDs and FSDs, secure stakeholder alignment and approval.
• Collaborate with PMs, architects, and tech teams to define roadmaps, delivery plans, and reporting strategies.
• Lead testing activities, coordinate UAT, and manage issue resolution for successful deployments.
• Serve as SME for reporting/analytics, troubleshoot data issues, validate data integrity, and deliver end-user training.

Skills

IT/data analysis experience

SQL & ETL

SAP BW / SAP ERP knowledge

BI reporting tools (BO, SAC, Power BI,

Business process understanding

Analytical & stakeholder management

Independent work ability

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field

Tools

SAP BW

SAP BW on HANA

SAP ECC

Oracle

SAP Datasphere

Power BI

Tableau

Job description

MKS, Inc. is seeking a Principal Business Systems Analyst to partner with business and IT teams, gathering BI requirements, mapping data, and creating report/dashboard wireframes.

You will analyze source data, identify gaps, and work with cross-functional teams to implement high-quality BI solutions under the Data Warehouse and BI Reporting leadership. You will lead requirements definition, BRDs/FSDs, testing (including UAT), and drive data integrity and end-user training to maximize BI