Sql data analyst Jobs in Allentown, PA

Job Description

The primary responsibility of the Sr. Data Analyst, People Analytics is to deliver high quality HR data, reporting and analysis support for the HR function. This role will partner with Olympus colleagues across HR and other corporate functions to design reports, translate the data into key areas of action and identify data audit and process improvement opportunities to continually improve the value of HR data. The incumbent will perform a variety of analytical tasks including but not limited to: standardized and ad-hoc report generation, data analysis and trending, process automation, and system auditing and testing. This individual serves as an HR data steward and translator across HR and ensures operational excellence in data analysis, reporting, and process efficiency.

Job Duties

• Analyze data, reports, and dashboards and provide summaries highlighting areas of opportunity and risk for the leadership team.
• Work with stakeholders to gather business requirements. Design and build reports and dashboards to deliver insight to HR team and business leaders.
• Conduct ad hoc and project analysis and prepare presentations of findings.
• Drive operational excellence in the HR by identifying process or workflow inefficiencies and process improvement opportunities. Create increased efficiencies through building automated solutions and process workflows to streamline.
• Identify and document system deficiencies and recommend and build solutions.
• Support and maintain scheduled reporting, including manual distribution, troubleshooting and support for automated delivery
• Conduct regular quality control activities to assure accurate data and processes. Ensure data integrity for all HR processes and programs. Develop and promote data integrity through audit processes and resolution of data discrepancies. Assist in creating and revising standard practices as discrepancies are resolved.
• Create and maintain required operational regulatory and legal compliance related reports such as the annual EEO-1 Veterans and Affirmative Action reports.
• Analyze data to recommend process and customer service improvements, innovative solutions or policy changes that add increased value and efficiency to the organization.
• Develop user procedures, guidelines and documentation related to the data maintenance and reporting solutions.
• Train clients on reporting functionality, data dashboard navigation, and building stories with data.
• Other duties as assigned.
• Partner with regional Talent Management teams and Regional/Global HRBPs to address skill gaps, support upskilling/reskilling initiatives, and enable career mobility

Job Qualifications

Required:

• Bachelors Degree is required preferably in human resources, business administration, or management.
• With a Bachelor’s Degree: minimum of 5 years of experience in data analytics, process automation, project management or human resources is required
• With a Master’s Degree: minimum of 3 years of experience in data analytics, process automation, project management or human resources is required.
• Experience with data visualization tools (Power BI required).
• Experience with RPA (robotic process automation) tools (Power Automate required).
• Demonstrated experience with cleaning and analysing complex data and presenting to high levels of leadership required.
• Excellent knowledge of Microsoft applications particularly advanced Excel knowledge.
• Acts as a champion for HR data quality accuracy and maintenance.
• Excellent customer service capabilities and demonstrated high level of responsiveness.
• Ability to effectively respond to and interact with all levels of organizational staff including senior leadership.
• Strong analytical capabilities with the ability to independently use data and analysis to convey findings and recommendations to all levels within the organization.
• Demonstrates learning agility in working with new complex business problems and to provide innovative value added solutions. Develops original work in response to business needs.
• Flexible innovative with the ability to quickly adapt as business needs change.
• Able to maintain productivity and positivity during times of change and potentially difficult business challenges.
• Ability to execute assignments or projects with excellence, minimal supervision or rework, and resulting in high degree of accuracy and early/on-time delivery.
• Excellent verbal/written communication skills detail oriented and ability to prioritize.
• Ability to effectively implement the strategy of the People Analytics team.
• Demonstrated ability to find, research, and develop creative solutions to analytical problems making use of spreadsheets databases and graphics.
• Ability to maintain confidentiality, lead projects and work independently. High degree of professionalism.
• Cooperate and participate as an effective team member in creating a positive working environment.

Preferred:

• SuccessFactors Employee Central or SAP HCM strongly preferred.
• Advanced education or certification in data analytics, such as certificates or coursework in data analytics.
• Experience with programming tools (R preferred).
• Understanding and experience with advanced analytical techniques and concepts.

Why join Olympus? We offer a holistic employee experience supporting personal and professional well-being through meaningful work, equitable offerings, and a connected culture. Equitable Offerings you can count on:

• Competitive salaries, annual bonus and 401(k)* with company match

• Comprehensive medical, dental, vision coverage effective on start date

• 24/7 Employee Assistance Program

• Free live and on-demand Wellbeing Programs

• Generous Paid Vacation and Sick Time

• Paid Parental Leave and Adoption Assistance*

• 12 Paid Holidays

• On-Site Child Daycare, Café, Fitness Center**

Connected Culture you can embrace:

• Work-life integrated culture that supports an employee centric mindset

• Offers onsite, hybrid and field work environments

• Paid volunteering and charitable donation/match programs

• Employee Resource Groups

• Dedicated Training Resources and Learning & Development Programs

• Paid Educational Assistance

*US Only **Center Valley, PA and Westborough, MA Are you ready to be a part of our team? Learn more about our benefits and incentives: . At Olympus, we are committed to Our Purpose of making people’s lives healthier, safer and more fulfilling. As a global medical technology company, we partner with healthcare professionals to provide best-in-class solutions and services for early detection, diagnosis and minimally invasive treatment, aiming to improve patient outcomes by elevating the standard of care in targeted disease states. For more than 100 years, Olympus has pursued a goal of contributing to society by producing products designed with the purpose of delivering optimal outcomes for its customers around the world. Headquartered in Tokyo, Japan, Olympus employs more than 31,000 employees worldwide in nearly 40 countries and regions. Olympus Corporation of the Americas, a wholly owned subsidiary of Olympus Corporation, is headquartered in Center Valley, Pennsylvania, USA, and employs more than 5,200 employees throughout locations in North and South America. For more information, visit . You Belong at Olympus We are deeply committed to fostering a respectful, fair, and welcoming workplace for all individuals, perspectives, and lifestyles. We believe in fostering a non-discriminatory, inclusive work environment where everyone feels a sense of belonging, in full compliance with legal standards. Empathy and unity are core to our company culture, empowering employees to contribute fully and flourish. We warmly encourage all who wish to bring their talents to Olympus to apply. Let’s realize your potential, together. It is the policy of Olympus to extend equal employment and advancement opportunity to all applicants and employees without regard to race, color, national origin (including language use restrictions), citizenship status, religious creed (including dress and grooming practices), age, sex (including pregnancy, childbirth, breastfeeding, medical conditions related to pregnancy, childbirth and/or breastfeeding), gender, gender identity and expression, sexual orientation, marital status, disability (physical or mental) and/or a medical condition, genetic information, ancestry, veteran status or service in the uniformed services, and any other characteristic protected by applicable federal, state or local law. Posting Notes: || United States (US) || Pennsylvania (US-PA) || Center Valley || Human Resources