Data Analyst 3

LIDAS (Lam India Data Analytics and Sciences) team is responsible to provide best-in-class analytics solutions that help improve business decisions in Global Operations and other business sub-functions across Lam.  This Organization, a “Center of Excellence” (CoE), consists of a high-performing team of experts who collaborate cross-functionally and provide analytics solutions to various business functions to suit their business needs. This team strives to improve the productivity & efficiency of business processes through business analytics, data science & automation projects. The resulting projects help accelerate businesses/stakeholders in decision-making by providing data insights. The team continuously develops the required technical skills and business acumen to help solve complex business problems & Use Cases in the semiconductor, manufacturing, and supply chain domains for the company. Eligibility Criteria:

Years of Experience :       Minimum 7-9 years Job Experience:              Data Analysis/ Statistical Analysis, Data Profiling

Expert in Database and Data warehouse tech (MS Fabric /PySpark/Azure Synapse/ SQL Server/SAP HANA)                                                      Experience with Visualization tools ( Power BI)

Educational :                     Bachelor’s Degree: Math/Statistics/Operations Research/Computer Science

Master’s Degree : Business Analytics (with a background in Computer Science)

Designs, Develops, and Tests Data Models to import data from source systems to meet Project requirements Effectively analyzes the heterogeneous source data and writes SQL/PySpark scripts to integrate data from multiple data sources Statistical Analysis and assess the results to generate actionable insights and presents the findings to the business users for informed decision making . Performs Data mining which provides actionable data in response to changing business requirements. Understands business requirements and develops dashboards to meet business needs Adapts to the changing business requirements and supports the development and implementation of best-known methods with respect to data analytics Migrates data into standardized platforms (Power BI) and builds critical data models to improve process performance and product quality. Owns technical implementation and documentation associated with datasets. Provides updates on project progress, performs root cause analysis on completed projects and works on identified improvement areas (like process, product quality, performance, etc.) Provides post-implementation support and ensures the target project benefits are successfully delivered in a robust and sustainable fashion. Builds relationships and partners effectively with cross-functional teams to ensure available data is accurate, consistent and timely Independently manages expectations from stakeholders, optimally utilizes time for larger initiatives with minimal guidance on prioritization or dependencies Provides mentorship and guidance to peers and junior team members Mandatory Skills required to perform the job:

Data Analysis & Statistical Analysis skills, experience in extracting information from databases, Office 365 Solid knowledge on SQL, PySpark.

Experience in advanced Statistical techniques. Knowledge of SAP systems (SAP S4, SAP ECC T-Codes & Navigation) Expert in Data Base Development, Troubleshooting & Problem-solving skills (MS Fabric, SQL Server, SAP HANA, Azure Synapse) Experience in project requirements gathering and converting business requirements into analytical & technical specs. Excellent verbal and written communication & presentation skills, able to communicate cross-functionally. Expert in Reports & Dashboard development (Power BI) . Desirable Skills:

Agile/SCRUM development using any