Data Domain Architect- Associate

You are a strategic thinker passionate about driving solutions in Data and Financial Analysis. You have found the right team.

As a Senior Associate in Finance Consolidation and Planning, you will support Finance stakeholders during critical accounting close cycles. You will be a key contact for finance teams on data and metadata inquiries in Essbase cubes, ensuring effective communication with system administrators to facilitate financial consolidation. This includes assisting with hierarchy changes, data retrievals, and reconciliations. You will work closely with the Consumer and Community Banking Planning & Analysis Business Analysis team, participating in daily meetings with Planning and Analysis teams to coordinate critical business day processes, help manage the forecast and budget submission calendar, and assist in maintaining reporting hierarchies such as local charts of accounts, cost centers/Lines of Business, and Key Performance Indicators. You will contribute to continuous improvement initiatives to streamline financial consolidation and reporting workflows, supporting the efficiency of Month-End, Quarter-End, and Year-End close processes. You will help oversee forecast submissions, support Planning & Analysis stakeholders, assist with daily reconciliations, and address data validation and system performance issues. By supporting process automation in collaboration with internal technology teams, you will help eliminate manual tasks and establish sustainable, repeatable processes for supporting Planning & Analysis teams with monthly submissions and validations, ultimately enhancing Business As Usual support mechanisms and improving the overall user experience with production issues. You will also support special projects aimed at deepening the understanding of financial statements and hierarchies, providing analytical support and insights.

Job Responsibilities:

• Serve as a key contact for finance stakeholders, supporting communication and collaboration between finance teams and system administrators for financial consolidation and reporting processes.
• Assist Finance and P&A teams in identifying business needs and help translate them into business requirement documents for enhancements and the development of new finance analytics applications and Essbase cubes.
• Help develop and maintain documentation for financial processes and requirements, ensuring accessibility and understanding for all stakeholders involved in financial planning and analysis.
• Support the implementation of enhancements and new applications, working with development teams to ensure alignment with business objectives and minimal disruption to existing processes.
• Participate in training sessions and workshops to enhance team members’ and stakeholders’ understanding and effective use of financial systems and analytics tools.
• Monitor financial processes and analytics applications, identifying opportunities for improvement and supporting initiatives to enhance efficiency and data accuracy.
• Demonstrate a client service focus, promptly addressing queries and providing deliverables to finance stakeholders, while supporting the development and validation of finance analytics solutions.
• Support special projects to enhance understanding of financial statements and hierarchies, providing analytical support and insights.

Required Qualifications, Capabilities and Skills:

• Bachelor’s degree in Accounting, Financial Planning, or Management Information Systems.
• Minimum of 3 years of experience as a user of Essbase cubes, with familiarity in Hyperion Essbase add-ins such as Dodeca and Hyperion SmartView for data analysis and troubleshooting.
• Solid financial acumen in planning, budgeting, and reporting cycles, with the ability to help translate business needs into technical requirements.
• Good understanding of financial statements, including P&L and Balance Sheet hierarchies, as well as alternate hierarchy management and non-financial metrics like KPIs.
• Strong communication skills, both written and verbal, to engage effectively with finance stakeholders and peers.
• Experience working in teams and supporting process improvements to achieve stakeholder satisfaction.

Preferred Qualifications, Capabilities and Skills:

• MBA in Finance or Accounting.
• Familiarity with business analysis tools such as Alteryx, Tableau, Databricks, and SQL Server.
• Proficiency in Excel functions and macros for effective data manipulation.
• Familiarity with Oracle Essbase cubes, power user experience is preferred.
• Prior experience working with financial institutions, especially supporting consumer banking such as credit cards, home lending, and auto LOBs FP&A teams.

Shift timings: 2 PM to 11 PM India time zone