Summary

Position Summary

To support the Financial Transformation within Advantage Solutions, a Financial Planning & Consolidation project is currently underway to implement the Oracle EPM suite of products. This role will have the opportunity to get in on the ground floor and actively participate in the project as the modules are designed and created. This individual will assume responsibility for the Planning modules and associated reporting in EPM after go-live.

This role will also serve as a business partner ensuring that IT initiatives are aligned with the business objectives and priorities of the various Finance teams. This role will have responsibility for ensuring that all Oracle EPM processes are completed in a timely manner to ensure the successful completion of financial planning (budget/forecast) cycles.

Essential Job Duties and Responsibilities (Describe the major duties of the job. List the Essential Duties and Responsibilities)

Responsibilities

• Provide technical oversight of the Planning modules and associated ETL / reporting in the Oracle EPM suite

• Collaborate with Finance teams to identify new/revised EPM requirements, translate requirements into technical solutions, formulate proposed prioritization / timing, gain approval from the EPM leadership council, and complete implementation and testing activities

• Ensure best practices and alignment with other modules of the EPM suite of products are considered when implementing master data, business rule, or other technical modifications

• Provide training, guidance, and support to end-users on financial planning and reporting activities

• Develop and implement IT strategies that align with the business objectives of the various Finance teams

• Ensure the accuracy and integrity of financial data within the various systems and applications

• Develop and manage IT project plans, timelines, and budgets related to financial planning and reporting

• Develop and maintain relationships with external vendors and service providers

• Develop and maintain IT documentation, including process maps, technical diagrams, and training materials

• Maintain a culture of continuous improvement, innovation, and customer service excellence within the IT team

• Stay current with emerging technologies and trends related to financial planning, consolidation, and reporting

Supervisory Responsibilities

Direct Reports

• This position does not have supervisory responsibilities for direct reports

Indirect Reports

• May delegate work of others and provide guidance, direction and mentoring to indirect reports

Travel Requirements

• Travel up to 25 %

Minimum Qualifications The following are the minimum job-related qualifications which an individual needs in order to successfully perform the essential duties and responsibilities of the job

Education Level:

• Bachelor’s or master’s degree in Finance, Accounting, Information Systems, or a related field

Field of Study/Area of Experience:

• Proven experience (5 years) in financial planning and consolidation, preferably in a leadership role

• In-depth knowledge of financial planning and consolidation systems such as Oracle Cloud EPM, Oracle Hyperion, OneStream including implementing master data, business rule, ETL, and reporting changes

• Strong understanding of financial processes, including budgeting, forecasting, reporting, and consolidation

• Strong analytical and problem-solving skills

• Experience managing IT projects related to financial planning and reporting

• Hands-on Project Delivery experience delivering solutions for the planning modules in EPM

• Excellent communication skills with the ability to effectively convey complex technical concepts to non-technical stakeholders

• Familiarity with IT governance, compliance, and risk management frameworks

Skills, Knowledge and Abilities

• Well-organized and detail oriented

• Ability to work in a fast-paced, dynamic environment, managing multiple priorities and deadlines effectively

• Able to build strong working relationships with both Finance and IT colleague at various levels

• Strong written communication and verbal communication skills at Executive and team levels

• Good interpersonal skills and ability to collaborate within/ across teams

• Skill in supervising and delegating responsibility, training and evaluating performance

Environmental & Physical Requirements

Office / Sedentary Requirements

Incumbent must be able to perform the essential functions of the job. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds.

Additional Information Regarding ASM Job Duties and Job Descriptions

Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department.This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. ASM reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law. ASM shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

Responsibilities

The Company is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods. The Company services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today.

Essential Job Duties and Responsibilities

Job Duty

Software Development Management

• Lead project planning and sizing activities, identify resource requirements, and oversee a team of internal and external resources capable of producing specified deliverables

• Create and maintain an software development project plan that communicates tasks, milestone dates, status, and resource allocation

• Identify and communicate major milestones and risks to achieving those milestones in a positive manner

• Coordinate delivery of development (beta) and production releases that meet quality assurance standards

• Manage software development projects around the BI platform to ensure quality, on time, within budget delivery from requirement definition through testing, rollout, and support

• Perform work breakdown and task identification, assign tasks to project resources, track progress on assigned tasks, and manage the assembly of completed tasks into coherent deliverables

Technical Leadership

• Architect, design, develop, test, and deploy code for business intelligence and database technology platforms

• Plan and execute efforts to address technical debt for legacy systems and processes

• Share acquired skills/knowledge with team members and mentor junior engineers

• Collaborate with test team in creating a Quality Assurance strategy for supporting both new and legacy BI systems

• Develop and enforce development best practices

• Lead code reviews and technical exchange sessions

• Manage the development and maintenance of technical documents

End User Support

• Create a user support structure that addresses user requests with minimal impact on ongoing project work

• Manage user training and onboarding activities.

• Perform technical liaison functions to all clients/customers

Supervisory Responsibilities:

Direct Reports

• Hires, retains, trains, coaches, guides, directs, and develops direct reports using company-wide processes, tools and resources

Indirect Reports

• May delegate work of others and provide guidance, direction and mentoring to indirect reports

Travel and/or Driving Requirements:

• Travel and Driving are not essential duties or functions of this job

Minimum Qualifications

The following are the minimum job-related qualifications which an individual needs in order to successfully perform the essential duties and responsibilities of the job

Education Level: (Required): Bachelor's Degree or equivalent experience

Field of Study/Area of Experience: computer science, engineering or related education/professional work experience

• 6+ years of significant experience with SQL Server, SSIS, SSRS

• 6+ years of relevant experience with Systems Analysis and documentation

• Deep knowledge of related technologies such as SSAS, Microsoft and third party BI tools, .NET

• Current experience presenting technical solutions to business and technical audiences

• Experience leading software development teams through all phases of the SDLC

• Experience managing business clients or customers

• Advanced communication, organization, and project management skills

• SCRUM Master and working within an Agile process a plus

• Prior consulting experience is a big plus

Skills, Knowledge and Abilities

• The ability to analyze ambiguous technical and customer situations and determine appropriate solutions as necessary

• Self-starter, problem solver, resourceful

• Demonstrated ability to provide cross-functional leadership

• Ability to create and maintain a positive work environment by motivating and managing people

• Experience architecting technical solutions for complex problems

• Experience architecting systems and leading a small team in a Microsoft BI development environment:

• SQL Server 2008 (or newer)

• Microsoft Visual Studio

• Microsoft Team Foundation Server

• Microsoft Office

• SharePoint

• Third party BI visualization and end user tools

• Working knowledge of related systems and platforms:.NET, Active Directory, BizTalk, Dynamics and application architecture

Environmental & Physical Requirements:

Office / Sedentary Requirements: Incumbent must be able to perform the essential functions of the job. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds.

Additional Information Regarding The Company Job Duties and Job Descriptions:

Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. The Company reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law. The Company shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

Any estimate, schedule, or guideline provided to associates in this job description or elsewhere in connection with their jobs is only intended to help describe job duties and for planning purposes. Regardless of any such estimate, schedule, or guideline, associates must always record all time worked for our company (which includes but is not limited to on-site work time in an assigned store, office, or other work location; required waiting time; administrative time; and work-related travel time).

Important Information

The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of associates so classified.

The Company is committed to providing equal opportunity in all employment practices without regard to age, race, color, national origin, sex, sexual orientation, religion, physical or mental disability, or any other category protected by law. As part of this commitment, the Company shall provide reasonable accommodations of known disabilities to enable an applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

Job Locations US-MO-Saint Louis

Primary Posting Location : City Saint Louis

Primary Posting Location : State/Province MO

Primary Posting Location : Postal Code 63101

Primary Posting Location : Country US

Requisition ID 2023-430657

Position Type Full Time

Category Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)

Minimum USD $100,000.00/Yr.

Maximum USD $175,000.00/Yr.