Overview
On Site
USD 30.00 - 60.00 per hour
Full Time
Skills
FP&A
Finance
Process Flow
FOCUS
Project Management
Reporting
Management
Decision-making
Business Analysis
Data Governance
Data Analysis
VBA
Pricing
SQL
Database
Master Data Management
Collaboration
Forecasting
Microsoft Excel
Reference Data
Oracle
Insurance
Taxes
Life Insurance
Business Transformation
Law
Job Details
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:
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.
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.