Sr. Data Analyst (Excel, SQL) at Roth Staffing Companies in Huntington Beach, California

Job Description:

No Corp-to-Corp, No 3rd party firms



.


Job Title: Sr Data Analyst
Location: Weekly hybrid onsite in Fountain Valley, CA

** Only candidates who are already local to Southern CA will be considered **

Employment Type: Temp-to-hire
Compensation: $35.00 to 43.00 per hour (based on experience)


.


Partnered with a client who specializes in automotive technology and a leader and among the largest automotive parts supplier in the world.


.


Responsibilities


Administer data processing for the Logistics department related to freight costs for Inbound & Outbound shipments through overseeing all Access database functions in the department. Provide all RFP and data through gathering and analyzing shipment history and freight costs of approx. $80 million+ annually. Audit and report the expense of international and domestic transportation versus budgeted amounts through weekly and monthly reporting.
.


Maintain transportation expense via data obtained from web reporting and query data to explain cost trends. Administer, communicate and prepare freight payment expense reporting. Monitor service transit times reported from carrier web sites.
.


Manage carrier RFP and vendor RFP specification and processes. Develop and maintain department KPI dashboards. SME on Access database processes and involvement in special projects relating to cost studies as needed by management.
.


Requirements

• Bachelor's Degree or equivalent experience


• 5+ years experience required


• Experience in related logistics activities such as freight rates, freight bill auditing and other sea/air/land carrier related activities - highly preferred!


• Minimum of 5 years of analysis experience (preferably within the automotive industry in the area of traffic/logistics/parts warehouse and claims).


• Expertise in Excel is required


• Solid working knowledge of SQL


• Advanced skills in MS Access: Ability to create tables, forms, charts, queries, macros and create and maintain new and existing databases as needed.


• Strong analytical skills.


• Previous experience with importing data files from mainframes and test formats to MS Excel/Access.


• Strong oral and written communication skills.

.
.


All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. To the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions. Apply Now