Data Analyst II Transportation

Overview

A Data Analyst -II is a seasoned analytical professional who takes ownership of complex reporting and data initiatives from concept through deployment. In this role, you will lead the design of advanced Power BI models, dashboards, and automated reporting solutions, while mentoring Data Analyst - I team members and serving as a subject matter expert across multiple operating locations. The Analyst - II is expected to translate ambiguous business problems into structured data solutions, drive standardization of KPIs and reporting practices company-wide, and partner directly with operations leadership to influence decision-making. This position reports to a senior analyst and is expected to provide functional guidance to Data Analyst - I team members.

Responsibilities

• Design, build, and maintain advanced Power BI data models, DAX measures, and enterprise-level dashboards used by operations leadership across multiple profit centers
• Knowledge and understanding of both Transportation and Fleet and Maintenance needs, including working with Assets, Maintenance Shops, Fuel, Tolls, etc.
• Lead end-to-end reporting projects, from requirements gathering and data architecture through development, testing, and deployment
• Mentor and provide technical guidance to Data Analyst - I team members, reviewing their work and helping develop their SQL, Power BI, and data modeling skills
• Own the relationship with operations leadership, serving as the primary analytics point of contact and translating business needs into technical solutions
• Write and optimize complex SQL queries against TMW/Trimble and other operational databases, including multi-table joins, stored procedures, and performance tuning
• Develop automation solutions (Power Automate, Python, Copilot Studio, or similar) to eliminate manual reporting processes and improve data accuracy
• Establish and enforce data governance standards, naming conventions, and QA processes for reports and datasets across the team
• Lead root-cause analysis on data discrepancies and reporting issues, coordinating with IT and business stakeholders to implement lasting fixes
• Develop and deliver SOP documentation and training programs for both internal analysts and field operations teams
• Identify opportunities for new analytics products and proactively pitch and build proof-of-concept solutions
• Communicate findings and recommendations clearly to both technical and non-technical audiences, including senior leadership
• Support forecasting, statistical modeling, and ad-hoc analysis for strategic initiatives
• Exhibit strong project management skills, managing multiple concurrent initiatives with competing deadlines
• Able to take on new tasks, special projects, and cross-functional responsibilities as needed

Qualifications

• Bachelor's degree in Supply Chain/Logistics, Computer Science, MIS, Business, or other related field; advanced coursework or certifications in data analytics a plus
• 3+ years of professional experience in data analysis, business intelligence, or a related analytical role (or equivalent combination of education and experience)
• Advanced proficiency in Power BI, including complex DAX, data modeling, and Power Query required; experience with Tableau or Minitab a plus
• Strong SQL skills, including multi-table joins, stored procedures, and query optimization (TMW/Trimble experience a plus)
• Experience with automation and scripting tools such as Python, Power Automate, or similar
• Advanced Excel skills, including complex formulas, macros, or Python-based automation (e.g., openpyxl)
• Demonstrated ability to apply business statistics in problem solving (descriptive statistics, probability, frequency distribution, time-series forecasting, correlation & regression models)
• Proven ability to lead projects independently and mentor junior team members
• Demonstrated ability to manage multiple complex projects simultaneously in a fast-paced environment
• Excellent written, verbal, communication, and presentation skills, including experience presenting to leadership
• Ability to lead calls with operational leaders
• Ability to work seamlessly across teams and locations, demonstrating strong cross-functional collaboration
• Ability to be flexible and adapt quickly when urgent matters require it
• Travel expectations up to 25%
• Strong problem analysis and resolution skills at both a strategic and functional level

•

We are excited to share that the base salary range for this position is $60,978.06 - $81,304.08. This position is also eligible for an annual discretionary bonus. NFI takes into consideration applicants' qualifications, experience, education, and geographic location when determining a starting rate of pay.

Employees are also eligible for a robust benefit program, which includes Medical, Dental, Vision, Prescription Drug Coverage, 401k Plan, Wellness Program, Life Insurance, Paid Time Off, and Paid Parental Leave, among other benefit plan options.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

LA County Applicants: The Company will consider qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local laws.

• Design, build, and maintain advanced Power BI data models, DAX measures, and enterprise-level dashboards used by operations leadership across multiple profit centers
• Knowledge and understanding of both Transportation and Fleet and Maintenance needs, including working with Assets, Maintenance Shops, Fuel, Tolls, etc.
• Lead end-to-end reporting projects, from requirements gathering and data architecture through development, testing, and deployment
• Mentor and provide technical guidance to Data Analyst - I team members, reviewing their work and helping develop their SQL, Power BI, and data modeling skills
• Own the relationship with operations leadership, serving as the primary analytics point of contact and translating business needs into technical solutions
• Write and optimize complex SQL queries against TMW/Trimble and other operational databases, including multi-table joins, stored procedures, and performance tuning
• Develop automation solutions (Power Automate, Python, Copilot Studio, or similar) to eliminate manual reporting processes and improve data accuracy
• Establish and enforce data governance standards, naming conventions, and QA processes for reports and datasets across the team
• Lead root-cause analysis on data discrepancies and reporting issues, coordinating with IT and business stakeholders to implement lasting fixes
• Develop and deliver SOP documentation and training programs for both internal analysts and field operations teams
• Identify opportunities for new analytics products and proactively pitch and build proof-of-concept solutions
• Communicate findings and recommendations clearly to both technical and non-technical audiences, including senior leadership
• Support forecasting, statistical modeling, and ad-hoc analysis for strategic initiatives
• Exhibit strong project management skills, managing multiple concurrent initiatives with competing deadlines
• Able to take on new tasks, special projects, and cross-functional responsibilities as needed
• Bachelor's degree in Supply Chain/Logistics, Computer Science, MIS, Business, or other related field; advanced coursework or certifications in data analytics a plus
• 3+ years of professional experience in data analysis, business intelligence, or a related analytical role (or equivalent combination of education and experience)
• Advanced proficiency in Power BI, including complex DAX, data modeling, and Power Query required; experience with Tableau or Minitab a plus
• Strong SQL skills, including multi-table joins, stored procedures, and query optimization (TMW/Trimble experience a plus)
• Experience with automation and scripting tools such as Python, Power Automate, or similar
• Advanced Excel skills, including complex formulas, macros, or Python-based automation (e.g., openpyxl)
• Demonstrated ability to apply business statistics in problem solving (descriptive statistics, probability, frequency distribution, time-series forecasting, correlation & regression models)
• Proven ability to lead projects independently and mentor junior team members
• Demonstrated ability to manage multiple complex projects simultaneously in a fast-paced environment
• Excellent written, verbal, communication, and presentation skills, including experience presenting to leadership
• Ability to lead calls with operational leaders
• Ability to work seamlessly across teams and locations, demonstrating strong cross-functional collaboration
• Ability to be flexible and adapt quickly when urgent matters require it
• Travel expectations up to 25%
• Strong problem analysis and resolution skills at both a strategic and functional level

•

We are excited to share that the base salary range for this position is $60,978.06 - $81,304.08. This position is also eligible for an annual discretionary bonus. NFI takes into consideration applicants' qualifications, experience, education, and geographic location when determining a starting rate of pay.

Employees are also eligible for a robust benefit program, which includes Medical, Dental, Vision, Prescription Drug Coverage, 401k Plan, Wellness Program, Life Insurance, Paid Time Off, and Paid Parental Leave, among other benefit plan options.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

LA County Applicants: The Company will consider qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local laws.