Data Analyst - SQL to Big Query

Dollar Tree • Chesapeake, VA

137d

About The Position

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.

Requirements

• Technical expertise in SQL, Alteryx, Tableau, Python.
• Strong knowledge of and experience working with data stores, 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).

Nice To Haves

• Master’s degree preferred.
• 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.).

Responsibilities

• Performs advanced business analysis using various techniques, e.g. statistical analysis, explanatory and predictive modeling, data mining.
• Create informative reports, dashboards, 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 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.
• Conduct insightful ad hoc analyses to investigate ongoing or one-time operational issues.
• 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.
• This will also support the managing OpEx & CapEx supply chain budget.

Benefits

• Health and wellness programs.
• Perks, programs, and resources that help you at every stage of your life and career.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees