About Your Role:

You will be responsible for developing and incorporating spatial analytics techniques into Dollar Tree’s existing real estate planning and new store site selection process. The position will serve as a key player in growing our Dollar Tree store base by hundreds of new stores each year and analyzing our existing fleet of 9,000+ stores in North America. You will use and enhance the Dollar Tree Sales Forecasting process to provide sales and cannibalization projections, develop Market Optimizations to guide our Real Estate team to open high-performing stores, and derive market insights using the latest tools in data analytics. Furthermore, you will operate as a Team lead for a geographic region, assuming responsibilities in reviewing reporting, aiding in projects, overseeing regional FAT production, and monitoring the Market Optimization schedule.

1. Act as Team Lead guiding one and/or two junior level analysts.

• Lead onboarding for new analysts: train in sales forecasting, location analysis, market optimizations, and relevant systems.

• Act as first reviewer for reporting, market optimizations, site analysis, and P&L adjustments.

• Partner with other analysts on team to develop, plan, execute, and implement value-add projects.

2. Develop and deliver advanced reporting, and effectively communicate conclusions to manager.

• Generate advanced reporting on areas such as cannibalization and competitive impacts to senior management.

• Leverage dashboarding tools such as Power BI and ESRI to effectively visualize data.

• Use reporting tools to discover insights leading to an increased understanding of store and/or market performance.

• Build, maintain, and refine Alteryx modules to automate reporting and deliver ad hoc data requests.

• Serve as subject matter expert on customer mobile data visualization as it relates to trade area delineation and cannibalization potential of existing stores.

3. Build, maintain, and refresh predictive models via regression analysis.

• Intimately understand the existing regression models used for projecting sales in assigned region and how certain variables and site characteristics impact performance.

• Update existing forecasting models annually to refine the regression variables and or coefficients and/or develop new models to account for changing markets and new statistically significant performance variables.

4. Serve as a store level profit and loss (P&L) expert.

• Study store and market performance to become an expert in current store P&L metrics, and identify trends, opportunities, and challenges facing store level P&L.

• Use P&L analysis to forecast margin and expenses of prospective real estate projects.

5. Support Portfolio Management Team.

• Serve as subject matter expert on asset write-downs and sales recapture for closing store locations.

• Assist in financial scenario analysis of potential store closings.

• Ensure REC closing presentations are financially accurate and meaningful to executive team.

6. Act as lead analyst in an assigned territory.

• Generate sales and enterprise profitability projections for new/relocating/expanding stores via thorough analyses involving the use of sales forecasting models.

• Work closely with Real Estate, Operations, Asset Protection, and Sr. Management in developing Market Optimization strategies to determine the optimal deployment of stores in a market.

• Perform post audits of sales forecasts to continuously improve the forecasting process.

7. Gain market/site intelligence through research and by working closely with the Real Estate Department.

• Foster a strong working relationship between the Finance and Real Estate departments.

• Visit existing stores and potential new store locations to understand the factors impacting sales.

***8. Prepare ad hoc real estate analyses and mapping requests for senior management.**9. Assist in Real Estate in fully leveraging GIS applications through training and day-to-day interaction.*Required Skills and Experience:

• Bachelor’s degree in Finance, Business, Geography, Statistics, or other quantitative discipline.

• 4+ years of related experience.

• Willingness to travel. (10%)

• Experienced in Site Location Research and sales forecasting in a retail environment.

• Experienced with ESRI or other GIS software.

• High proficiency in Microsoft Excel and databases.

• Experience with Alteryx.

• Strong analytical and problem-solving skills with ability to effectively manage large amounts of data.

• High level of initiative, willingness to assume responsibility, and ability to multi-task while meeting multiple deadlines.

• Attention to detail required.

Preferred (Desired) Qualifications:

• Master's degree in Finance, Business, Geography, Statistics, or other quantitative discipline.

• Knowledge of and experience with statistical analysis and regression-based modeling.

• Previous experience with R statistical software.

• Previous experience with Power BI.

• Previous experience with other advanced statistical software and analytic techniques.

Our success is a team effort… When we reach our goals, you’ll be eligible for a yearly bonus!Your Perks and Benefits:

We offer a wide variety of rewards to support your health, wealth, and mental well-being. In addition to medical, pharmacy, dental, and vision insurance, we offer:

• Employee Assistance Program

• Retirement plans with matching contribution

• Employee Stock Purchase Program

• Educational Assistance

• Access to Perk Spot, an employee discount platform for goods and services

• And much more!

Who We Are:

• At Dollar Tree, we make a difference in the lives of our customers every day by exceeding their expectations and delivering value – it’s what our business is built on.
• Our associates play an important role in this commitment by embracing change and showing up for their teams and their communities.
• We see an exciting path forward as our company continues to grow and transform – and we know that this path starts with you.

Join our team today and discover The Value of You.

Dollar Tree is an Equal Opportunity Employer committed to complying with the Americans with Disabilities Act (ADA) and providing reasonable accommodations to qualified individuals with disabilities.

This job specification should not be construed to imply that these requirements are the exclusive standards of the position. This is not to be considered a complete list of job duties, which appear in the job description for this position, and which may be amended from time to time at the discretion of Dollar Tree. Incumbents will follow any other instructions and perform any other related duties as may be required by their supervisor.

Please note, this job description is not a contract of employment and may be modified to meet evolving business needs. Employment at Dollar Tree, meaning that either the employee or the company may terminate the employment relationship at any time, with or without cause or notice.

Full time

500 Volvo Parkway,Chesapeake,Virginia 23320

Market Strategy

Dollar Tree