BA Ops Support, ROC Analytics

- Bachelor's degree - 0-1 years of SQL, Excel VBA macros writing experience
About the Org Surface Transportation (ST) is seeking a highly skilled and a motivated team player to be part of the dynamic ROC team which supports NA and EU Surface Transportation Operations. The Surface Transportation Operations team addresses disruptions in the Middle Mile network, supporting drivers and carriers faced with unexpected events (poor weather, road closures, unexpected surges in volume, mechanical breakdowns, etc.) to allow them to deliver packages safely and on time. As a BA Ops Support, you will be responsible for retrieving and aggregating data from multiple sources and transforming it into actionable insights. You will own the delivery of assigned KPIs that support critical business deliverables and ensure operational sustainability. Your role includes communicating key analyses and insights to stakeholders through both verbal and written formats. The analytics and metrics you provide will drive focus on priority areas, enhance decision-making clarity, and contribute to an improved customer experience. Key job responsibilities Understand the various operations across ROC • Design and develop highly available dashboards and metrics using SQL and Excel/Quicksight • Own the delivery and backup of periodic metrics, dashboards to the leadership team • Draw inferences and conclusions, and create dashboards and visualizations of processed data, identify trends, anomalies • Perform business analysis and data queries using appropriate tools