About the Role:

Grade Level (for internal use):

The Team: The Center of Excellence Accounting team within Corporate Controllers is responsible accounting across S&P Global related to revenue and centralized accounting support across the income statement. The team values collaboration and the ability to think critically while problem solving.

The Impact: We are seeking an individual with Alteryx, Tableau, SQL Server, Visual Basic, and MS Access Development skills.

The individual will develop Alteryx workflows and Tableau Dashboards to assist the revenue and expense teams. The individual is responsible for learning the excel based accrual calculation model and building Alteryx workflows for the purpose of improved speed and accuracy. Additionally, the individual will be responsible for maintaining an MS Access system with SQL Server back-end. The system uses stored procedures to handle several database related transactions. The individual should understand basic accounting concepts for Alteryx, there will be a focus on developing failsafe checks to ensure data quality and process checks. The individual will also be helping with the ad hoc reporting requests and ensure the adherence to our SOX policies and procedures related to AR and Revenue accounting.

The role will also assist a team responsible with the calculation of complex revenue and expense accruals impacting multiple business units across S&P Global. Accounting is dependent on using data form multiple sub-systems across the company that are organized and linked to calculation models that drive revenue accruals, customer invoicing and expense accruals. This may include the ownership if a revenue model and accounting close responsibilities.

The individuals will also be responsible for developing Tableau dashboards for the Revenue and Expense teams. The dashboards will require joining/blending data from multiple sources. SQL Server skills required to manage the data warehouse. Individual will be responsible for managing the tableau server and access rights.
The candidate will also provide support for existing Alteryx and Tableau dashboards. They will also be responsible for coaching accounting staff on how to best operate Alteryx workflows.
Experience with Oracle and SAP ERP navigation a plus.

What’s in it for you:

• Opportunity to be part of S&P Global, a growing global organization that powers the markets of the future.
• Be part of a global accounting team and collaborate with domestic and international staff, third parties; AP and OTC teams and all global business units focusing on achieving team / company objectives.

• To work in the latest cutting edge technologies including our initiatives into automation and lean Six Sigma projects

Responsibilities:

• Night shift required, same hours as New York team. Can be adjusted after training period completion.
• Learn, absorb, and design Alteryx workflows to automate accrual models across various business groups.
• Design and develop Tableau dashboards to help explain Revenue and Expense trends and insights
• Provide Alteryx and data support to revenue and expense accruals teams.
• Assisting with reporting to internal FP&A teams.
• Work closely with other team members across the S&P Global Corporate Controllers team.
• Use broader knowledge of financial principles and theories to continually improve processes.
• Strong written and verbal communication skills to interact and collaborate with internal (employees) and external customers at all levels including third parties to achieve results.
• Strong ability to analyze and resolve issues timely and efficiently while ensuring SOX compliance is imperative.
   

Qualifications:

• 3-5 years of Tableau experience required.
• 3-5 years of MS Access and VB development experience required
• 3-5 years of SQL Server and Stored Procedure development experience required
• 1-3 years of Alteryx experience preferred.
• 2-3 years of experience working with Finance/Accounting teams.
• College level accounting degree required.
• Experience with SAP/Oracle and the willingness to learn revenue and expense accounting concepts/principles related to ASC 606.
• Strong Excel skills such as Pivots and formulas
• Experience in Oracle/MS SQL Server DB design and implementation.
• Willingness to learn our new systems and legacy systems at a fast pace.
• Excellent oral and written communication skills are required.
• Ability to interact and collaborate with internal and external customers at all levels of management and staff globally.
• High degree of accuracy and management of heavy workload; understanding of contributions to the overall end to end process.
• Knowledge of a