"Alerted.org

Description

3 month contract (no option to extend)

Candidates must currently be local to Redmond, WA

Hybrid - 3 days/week are onsite

Client is seeking a Senior FP&A Analyst to join their finance teams to build an automated process to set the prices for updated price points and new products. This person will have to have senior level excel experience and be able to work with the business to understand the process flow, and then build the price automation tool within excel. To accomplish this they will have to organize the data and implement management/governance over their data that currently sits within Excel.

Required Skills

- High technical skills in Excel with special focus on VBA, Excel Automate and PowerQuery to automatize the process (incl. potentially using tools like MS Access for a streamlined front end to kick-off the process)

- Experience creating structured databases (we are expecting to turn our semi-structured Excel data into properly structured tables in Excel or potentially SQL)

- Project management experience (all the above are our rough requirements, but no final definition or design of the solution has been created yet – the person we’re looking for would need to drive this process while reporting to management

- Price Setting and Margin based analysis and decision making

- Experience creating streamlined processes coordinating multiple teams around a new toolset

Skills

Sql, Data, Analysis, Microsoft excel, vba, Excel Automate, Powerquery, Data analysis, Business analysis, Sql queries, Data governance

Top Skills Details

Sql,Data,Analysis,Microsoft excel,vba,Excel Automate,Powerquery

Additional Skills & Qualifications

• Improve process for how things are priced.

• Currently very manual process

• This should be able to be replicated for similar products but it's a very manual process

• Also has to be able to do margin analysis for new products

• Build this on top of forecast data which is unstructured in excel tabs

• Work to automate and organize this data (master data tables structure)

• Requirements

• Pricing and margins background

• Excel and power query

• SQL and tables and databases. Needs to build the schema and connect tables and master data

• Work together with other teams and how to access types of master and forecast data

• Quantity forecast provided by another team.

Current Process

• Input via request email of a new price point or a new product

• Input in excel structure

• Price, product code

• Open other excels for reference data and past approvals.

• Uploaded into Oracle.

• Missing piece is the cost structure that varies depending on item, they should look at margin return and if it falls without parameter they should reassess the price and it flags it

• Has a ton of variables and they want this to be conditioned so they can adapt to variables.

Experience Level

Expert Level

We reserve the right to pay above or below the posted wage based on factors unrelated to sex, race, or any other protected

classification. Eligibility requirements apply to some benefits

and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. This temporary role may be eligible for the following:

+ Medical, dental & vision

+ 401(k)/Roth

+ Insurance (Basic/Supplemental Life & AD&D)

+ Short and long-term disability

+ Health and Dependent Care Spending Accounts (HAS & DCFSA)

+ Transportation benefits

+ Employee Assistance Program

+ Time off/Leave (PTO, Vacation, or Sick Leave)

Pay and Benefits

The pay range for this position is $30.00 - $60.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

• Medical, dental & vision • Critical Illness, Accident, and Hospital • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Voluntary Life & AD&D for the employee and dependents) • Short and long-term disability • Health Spending Account (HSA) • Transportation benefits • Employee Assistance Program • Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a hybrid position in Redmond,WA.

Application Deadline

This position is anticipated to close on Jun 11, 2025.

About TEKsystems and TEKsystems Global Services

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.