Data Analyst - Transportation

Dollar Tree•Chesapeake, VA

About The Position

Data Analyst - Transportation Overview: This position is for a Data Analyst who can manage Supply Chain’s SQL server data, Big Query data warehouse, Alteryx workflow (ETL) and Tableau Dashboard development. The candidate should be an excellent Alteryx and Tableau modeler who can build from requirement documentation with limited support. Responsibilities: Performs advanced business analysis using various techniques, e.g. statistical analysis, explanatory and predictive modeling, data mining Create informative reports, dashboards, visualizations, and presentations to communicate data findings to stakeholders, translating complex information into actionable insights and opportunities for improvement Works closely with the internal or external client to understand available data elements, where they reside across various systems. Manages, architects, and automates the flow of information from various source systems through the supply chain SQL Server and ultimately into the Supply Chain Data Warehouse, ensuring clean, harmonized, and accurate data. Ability to work and communicate with business stakeholders and technical teams while bridging the communication gap between the two. Ensure a high degree of accuracy and timeliness in generating reporting outcomes for business leaders, including near-time operational reporting. Conduct insightful ad hoc analyses to investigate ongoing or one-time operational issues, including key Transportation initiatives. This role will also be critical in managing and integrating financial, operational, and transactional data to support our Transportation and Distribution Center (DC) network—comprising 9 DCs and handling approximately 500+ million annual case transactions. Support the managing OpEx & CapEx supply chain budget, including cost optimization and ad hoc financial tracking. Other duties as assigned. Here, you’ll have the opportunity to connect with people every day — creating memorable experiences for our customers while also building a career that can take you anywhere. Join our team and see where your journey can take you. We're invested in your health and wellness. That’s why we invest in perks, programs, and resources that help you at every stage of your life and career.

Requirements

Technical expertise in SQL, Alteryx, Tableau, Power BI, and Python.
Strong knowledge of and experience working with data stores, data extraction & cleansing, analyzing large volumes of data using analytical tools, and in building data models.
Knowledge of statistics and experience analyzing large datasets.
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
Advanced working knowledge of Microsoft PowerPoint, MS Excel
Technical expertise IBM (Financial), OTM (Transport management Systems), Catalyst (Warehouse Management Systems)
Bachelor's Degree - Data Science, Engineering or Mathematics
3-5 years of experience working with the data required (preferably in a data warehouse, data management team, or repository)
Project management, business, practice, and people development experience
Expert knowledge of business intelligence reporting solutions (Tableau, MicroStrategy, Business Objects, etc.)

Nice To Haves

Master’s degree preferred.

Responsibilities

Performs advanced business analysis using various techniques, e.g. statistical analysis, explanatory and predictive modeling, data mining
Create informative reports, dashboards, visualizations, and presentations to communicate data findings to stakeholders, translating complex information into actionable insights and opportunities for improvement
Works closely with the internal or external client to understand available data elements, where they reside across various systems.
Manages, architects, and automates the flow of information from various source systems through the supply chain SQL Server and ultimately into the Supply Chain Data Warehouse, ensuring clean, harmonized, and accurate data.
Ability to work and communicate with business stakeholders and technical teams while bridging the communication gap between the two.
Ensure a high degree of accuracy and timeliness in generating reporting outcomes for business leaders, including near-time operational reporting.
Conduct insightful ad hoc analyses to investigate ongoing or one-time operational issues, including key Transportation initiatives.
This role will also be critical in managing and integrating financial, operational, and transactional data to support our Transportation and Distribution Center (DC) network—comprising 9 DCs and handling approximately 500+ million annual case transactions.
Support the managing OpEx & CapEx supply chain budget, including cost optimization and ad hoc financial tracking.
Other duties as assigned.