Kaygen, Inc. ยท 2 months ago
Human Resource Analyst 3
Los Angeles, CA
Full-time
Onsite
Mid Level
$50.54/hr - $56.37/hr
4+ years expKAYGEN is an emerging leader in providing top talent for technology-based staffing services. They are seeking a Human Resource Analyst 3 to leverage advanced Excel and data analysis skills for reporting and analysis in a dynamic team environment.
AnalyticsBig DataData ManagementInformation ServicesInformation TechnologyStaffing Agency
Responsibilities
Mastery of formulas and functions: VLOOKUP, XLOOKUP, INDEX/MATCH, IF/IFS, SUMIF(S), COUNTIF(S), and text functions
Strong experience with PivotTables, Power Query, and Power Pivot
Ability to design dynamic reporting tools using modern Excel functions (UNIQUE, FILTER, SORT)
Data validation, conditional formatting, and protection/sharing for report integrity
(Optional) VBA/Macro automation for repetitive tasks
Access Database knowledge a plus
Qualification
Required
Mastery of formulas and functions: VLOOKUP, XLOOKUP, INDEX/MATCH, IF/IFS, SUMIF(S), COUNTIF(S), and text functions
Strong experience with PivotTables, Power Query, and Power Pivot
Ability to design dynamic reporting tools using modern Excel functions (UNIQUE, FILTER, SORT)
Data validation, conditional formatting, and protection/sharing for report integrity
Bachelor's degree from an accredited college or university in a related field, and (4) yrs. of relevant experience
Classification and compensation experience
Reporting and analysis experience
Advanced excel and data analysis proficiency
Maintains confidentiality
Personable, Flexible, Multitask and Handles pressure well
Professional, organized with strong written and verbal communication skills a must
Valid CA driver license that allows you to drive in the course of your employment
Preferred
VBA/Macro automation for repetitive tasks
Access Database knowledge
Benefits
Free Healthcare Insurance
Vision and Dental Insurance
401(k) Retirement Plan
Free Life Insurance
Sick Time Off
Certifications
Mentorship Program
Referrals
Family and Wellness benefits
Continuous Growth and Career Development
Company
Kaygen, Inc.
Kaygen, an award-winning technology consulting and talent firm, assists organizations to achieve digital transformation.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Anshul Chaturvedi
Founder & CEO
Rashmi Chaturvedi
Co-founder & President
Company data provided by crunchbase