**Position** : Project Coordinator 1 **Location** : Whittier, CA Atlas is a nationwide leader in civil engineering, materials testing and geotechnical consulting services for environmental, industrial and infrastructure construction projects. Headquartered in Austin, TX, Atlas currently has over 3,500 employees with offices throughout the US, including Alaska & Hawaii. It’s no accident that Atlas creates a better experience for infrastructure and environmental projects. It’s how we are built – with the best people in the industry, with the reach and expertise to help at any and every step of the project, and with a heart-led approach that puts quality and safety at the center of everything we do. We’re just built to be better. We are a great company. We are seeking a **Project Coordinator 1** to join our Southern CA team! The successful candidate will possess expert level skills listed below. Come join us! + **Expertise in Advanced Formulas and Functions:** + Proficiency with complex formulas such as nested IF statements, array formulas, and advanced functions like INDEX-MATCH and dynamic array functions (e.g., FILTER, SORT). + **Advanced Data Analysis and Visualization:** + Mastery of PivotTables and PivotCharts, and the ability to create sophisticated charts and data visualizations, including custom and interactive charts. + **Automation and Scripting Skills:** + In-depth knowledge of VBA (Visual Basic for Applications) for automating tasks, creating custom functions, and developing complex macros. + **Data Management and Integration:** + Expertise in using Power Query for data transformation, Power Pivot for managing large datasets, and integrating Excel with other data sources and tools. + **Troubleshooting and Performance Optimization:** + Advanced skills in debugging and optimizing formulas and VBA code, as well as managing performance issues in large and complex workbooks. **Job responsibilities include but are not limited to:** + Performing dispatch of material testers. + Managing certifications and assisting with renewals. + Generate schedules and perform data entry. + Review material tester reports for accuracy. + Review and approve timesheets. + Review and approve expenses. + Review daily field reports. + Project/Billing Setup. + Overseeing safety standards and requirements for the office. + Supporting other departments where needed. **Minimum requirements:** + College Degree + 2+ years of related professional experience + Mastery of Microsoft Excel (A MUST), Word, and Outlook **Technical requirements:** + Ability to operate independently, or constructively with others + Ability to balance multiple tasks and prioritize appropriately + Possess a valid California driver’s license + Ability to travel to Whittier, CA office + Ability to lift and carry a minimum of 50 lbs. + Strong verbal and written communication skills **Compensation:** $25 - $30 hourly The expected salary range for the position is displayed in accordance with the state’s law. Final agreed upon compensation is based upon individual qualifications and experience. **Benefits:** Atlas offers a comprehensive benefit program to meet the diverse needs of our employees. Depending on your employment status, Atlas benefits include health, dental, vision, life, AD&D, voluntary life / AD&D, disability benefits, leaves of absence, 401k, paid time off, paid holidays, employee assistance program, educational assistance program. **Who We Are:** We strive to be the most sought-after infrastructure and environmental solutions company, known for our unique, values-driven approach and brought to life by the industry’s most exceptional people. Atlas provides professional testing, inspection, engineering, environmental and consulting services from more than 100 locations nationwide. We deliver solutions to both public and private sector clients in the transportation, commercial, water, government, education and industrial markets. With a legacy of providing consistent quality and results, Atlas creates a better experience at every stage of an infrastructure project. We connect the best experts in the industry to deliver value from concept to completion and beyond. This means doing everything our clients expect and then raising the expectations in a way that only our people can. **Our Values:** **Life:** We enhance quality of life. We value people and safety above all else. **Heart:** As our hallmarks, we act with compassion, empathy and respect. **Trust:** We work together as partners, doing what we say with full accountability. **Mastery:** Always striving for the highest quality, we ensure greatness inspires all our work. **Diversity, Equity & Inclusion are at the core of our purpose & values:** We are committed to enhancing the lives of our employees, customers, shareholders, and the communities where we live and work. We believe in our heart-led approach and place a strong focus on conducting our business in an ethical, compassionate, and respectful way. Through our Diversity, Equity & Inclusion Program, we seek to hire, develop, and promote a talented and diverse team of professionals nationwide. We believe in leveraging the power of our different backgrounds, beliefs, perspectives and capabilities to create value for our company and our communities. Our values of Life, Heart, Mastery and Trust are the principles by which we operate, the character of our people, and the culture of our organization. We’re Stronger Together. **Atlas EEOC Statement** Atlas is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. Atlas makes hiring decisions based solely on qualifications, merit, and business needs at the time. For more information, read through our EEO Policy https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf \#LI-KK1 #LI-Onsite