Crew Data Analyst

FedEx Group; Memphis, Northern (TN, KY); On-site; USD 57,000 - 92,000; Full time

Job summary

FedEx is seeking an analytics-focused professional to support crew compensation data analysis in Memphis. The role requires SQL/SAS expertise to ensure accurate credit-hour compensation in line with the CBA and procedures.

Responsibilities include auditing crew compensation processes, maintaining sick and vacation banks, and collaborating with Payroll and Finance to ensure timely reporting. A Bachelor's degree and 2 years of related experience are preferred.

Qualifications

• Bachelor's degree in a quantitative field is required.
• At least 2 years of experience with automated compensation systems and data analytics.
• Proficiency in Excel, SAS, and SQL for data analytics.

Responsibilities

• Perform data analysis using Excel, SQL and SAS to ensure accurate compensation of crews’ credit hours.
• Plan, develop, analyze, audits, and evaluate crew compensation per the CBA and SOPs.
• Audit, maintain, and reconcile crews’ sick and vacation banks.

Skills

Excel

SQL

SAS

Pivot tables

VBA/macros

VLOOKUPs

Education

Bachelor's degree in business, accounting, finance, mathematics

Tools

FedEx crew management systems

Job description

Duties for this role include but are not limited to: Performs data analysis utilizing Excel, SQL and/or SAS to ensure accurate compensation of crews’ credit hours. Plans, develop, analyze, audits, and evaluate crew compensation to ensure accurate and timely accounting of crews’ credit hours in accordance with the crews’ collective bargaining agreement (CBA) and the department's standard operating procedures. Audits, maintains, and reconciles the crews’ sick and vacation banks to ensure compliance with the CBA.

Essential Functions

• Knowledge of Microsoft Excel (including pivot tables, v-lookups, advanced formulas, and use of VBA/macros)

• Knowledge of pilot's collective bargaining agreement and duty time regulations

• Knowledge of statistics, accounting, and the FedEx computerized crew management systems

• Strong analytical, communication, human relation skills and decision-making/problem solving abilities

• Performs other duties as assigned

Minimum Education

Bachelor’s degree in business, Accounting, Finance, Mathematics, or related quantitative discipline.

Minimum Experience

Two (2) years related experience with automated compensation systems, financial and operational analysis, and/or computerized crew management systems. Assist with tracking, controlling, and substantiating incoming data. Ability to perform data analytics utilizing Excel, SAS and/or SQL.

Knowledge, Skills and Abilities

• Demonstrated planning, organizing and attention to details

• Ability to work independently and as part of a team

Preferred Qualifications:

Emphasis in Finance or Accounting, with demonstrated ability to apply cross-functional organizational and contractual knowledge in a complex operational environment. This includes collaboration across departments such as Payroll, HR, Finance, IT, and Operations; interpreting and applying contractual (CBA) provisions; partnering with system and data teams to support payroll processing and reporting; and effectively communicating financial impacts and requirements to stakeholders.

Pay Transparency:

This is a hybrid position located in Memphis, TN. Candidates must live within 50 miles of the campus location. Employees will be required to work at the FedEx campus location several times per week

Pay:

Memphis pay range: $5,152.82 - $8,244.52 USD Monthly FEC-B24

Federal Express Corporation is an Equal Opportunity Employer including, Vets/Disability.

Reasonable accommodations are available for qualified individuals with disabilities throughout the application process. Applicants who require reasonable accommodations in the application or hiring process should contact [e-mail].

Applicants have rights under Federal Employment Laws:

• Know Your Rights
• Pay Transparency
• Family and Medical Leave Act (FMLA)
• Employee Polygraph Protection Act

• E-Verify Notice (bilingual)
• Right to Work Notice (English) / (Spanish)