HR Data & Reporting Analyst 4

The Impact You’ll Make

Ensures that trusted, accurate HR data is available at the right time for business users. Documents metrics, builds solutions and automates tasks to eliminate manual process steps, whenever possible.  Responds to employee data and reporting inquiries, questions and bugs/tickets, across all business units.

What You’ll Do

• Review existing Power BI reports and the related SQL code and optimize both for performance, upgrade to align with current corporate enterprise standards and update reports to implement current HR and Power BI best practices for reporting and analytics
• Create new Power BI reports for HR reporting requirements, querying using SQL to pull data from Microsoft Fabric databases - Lakehouses & Synapse. 
• Regularly participate in enterprise analytics review meetings, to gain approval for HR reports, learn about other work going on across the business and build relationships
• Analyze existing HR datasets and provide input into a fresh HR data model to be used for the next 3-5 years.
• Act as HR Data Analyst and Librarian for HR Data and HR metrics
• Expand and enhance Visier People Analytics per business requirements
• Create data validation queries, perform data audits and other data quality checks.  Then, automate each.
• Provide L2 and L3 support for issues across all HR reporting technologies: tools, data warehouses and systems
• Act as Reporting Solutions team representative on project teams, to ensure data- and reporting-related requirements are identified early in the project lifecycle and solutions are delivered that meet both current and future needs.

Who We’re Looking For

• Bachelor's degree or equivalent practical experience
• 5+ years of strong SQL coding experience
• 5+ years of experience in building complex reports, dashboards, and applications in Power BI (especially for Human Resources). Strong proficiency and expertise in DAX.
• 5+ years of experience with Microsoft Office applications, including advanced Excel Skills (i.e., Power Query, Power Pivot, VLookup, data tables, pivot tables, VBA, etc.)
• 3+ years of experience driving success through partnerships with Global Information Systems (GIS) for ETL creation, data modeling, security modeling, testing, implementation, annual audits, and required sustaining activities for a reporting data warehouse
• Significant experience performing data analysis, data cleanup, and report publishing
• Experience working in fast-paced, agile multi-geographic environments
• Strong understanding of relational and dimensional modeling, with experience using various technologies (i.e., Azure, SAP BW, Power BI)
• Proven problem-solving skills and excellent communication & presentation skills in the English language
• Strong experience in optimizing and troubleshooting the dashboards and providing the recommendation on the design
• Ability to work independently and must be able to articulate and successfully implement the proposed solution

Preferred Qualifications

• 8+ years’ experience with reporting and analytics projects, teams, tool creation, and data management, across multiple business models
• 8+ years of experience with writing, debugging and optimizing SQL code across multiple database technologies (SQL Server, Microsoft Lakehouse, Denodo, etc.)
• 5+ years of experience working with Human Resources (i.e, Leadership, Support, Centers of Excellence, Business Partners) in delivering people-related reports and analytics
• 2+ years of experience with Visier People Analytics
• Experience in data federation, master data management, virtualization tools and data processing and audit automation (i.e., Informatica, Axon, Denodo)
• Experience with Microsoft Fabric and Power technologies (Lakehouse, Synapse, notebooks, PowerApps, etc.)
• Technology - Understands many technology applications (i.e., SuccessFactors HCM, Visier, ServiceNow, PowerBI, WorkHuman, Excel, PowerApps, SharePoint, Teams) and coding languages (i.e., SQL, M Query, DAX, VBA, .Net, Visier VFL)
• Experience in conducting exploratory data analysis and providing recommendations for improvements that better enable business insights

Our Commitment

We believe it is important for every person to feel valued, included, and empowered to achieve their full potential. By bringing unique individuals and viewpoints together, we achieve extraordinary results.

Lam Research ("Lam" or the "Company") is an equal opportunity employer. Lam is committed to and reaffirms support of equal opportunity in employment and non-discrimination in employment policies, practices and procedures on the basis of race, religious creed, color, national origin, ancestry, physical disability, mental disability, medical condition, genetic information, marital status, sex (including pregnancy, childbirth and related medical conditions), gender, gender identity, gender expression, age, sexual orientation, or military and veteran status or any other category protected by applicable federal, state, or local laws. It is the Company's intention to comply with all applicable laws and regulations. Company policy prohibits unlawful discrimination against applicants or employees.

Lam offers a variety of work location models based on the needs of each role. Our hybrid roles combine the benefits of on-site collaboration with colleagues and the flexibility to work remotely and fall into two categories – On-site Flex and Virtual Flex. ‘On-site Flex’ you’ll work 3+ days per week on-site at a Lam or customer/supplier location, with the opportunity to work remotely for the balance of the week. ‘Virtual Flex’ you’ll work 1-2 days per week on-site at a Lam or customer/supplier location, and remotely the rest of the time.