Sr Analyst, Business Intelligence Finance

About Gap Inc.

Our brands bridge the gaps we see in the world. Old Navy democratizes style to ensure everyone has access to quality fashion at every price point. Athleta unleashes the potential of every woman, regardless of body size, age or ethnicity. Banana Republic believes in sustainable luxury for all. And Gap inspires the world to bring individuality to modern, responsibly made essentials.     

This simple idea—that we all deserve to belong, and on our own terms—is core to who we are as a company and how we make decisions. Our team is made up of thousands of people across the globe who take risks, think big, and do good for our customers, communities, and the planet. Ready to  learn fast, create with audacity and lead boldly? Join our team.

About the Role

As part of reshaping the future of Finance, Gap Inc. is embarking on a digital and process transformation within the Finance organization. In this role, you will support the overall Finance function for a large, multi-brand retailer in a
fast-paced, complex environment.
Gap Inc.’s headquarters Finance team provides financial reporting and analytics support to various business units and the Executive Leadership teams.

The Senior Analyst - Business Intelligence Finance, is responsible for building, analyzing, enhancing, and supporting best in class, business focused reporting and analytics. The teams are responsible for leading several key financial performance management activities for Gap Inc., including the annual budget / operating plan, long-range plan, and monthly forecast. Using these activities as a foundation, they provide the executive leaders and other relevant stakeholders with forward-looking financial projections, performance perspective, and foundations for optimal decision-making.

What You'll Do

• Design, develop, and maintain Freeform reports within Oracle EPM Suite, leveraging Oracle EPM tools such as Oracle Planning and Budgeting Cloud Service (PBCS), Oracle Financial Consolidation and Close Cloud Service (FCCS), and other related modules.
• Prepare monthly financial reports for Gap Inc.'s management and ensure reports are accurate and distributed in a timely manner.
• Develop complex queries and reports using Oracle Essbase, Smart View, and other EPM tools to deliver meaningful insights and support business decision-making
• Collaborate with data teams to integrate data from various source systems into Oracle EPM applications, ensuring seamless data flow for reporting.
• Deliver financials for the company, whether related to financial close, internal, or external reporting, or analysis for key stakeholders in Finance
• Engage in prototyping, designing, developing, and publishing Oracle EPM dashboards and reports including freeform, EPM automate, Narrative reporting and data integration.
• The Oracle EPM Financial Analyst plays a crucial role in applying finance, accounting principles, and developing dashboards using best practices for visualizations and data security.
• Collaborate with Business Analysts to gather business requirements for Analytics and Reporting
• Design, configure and test systems functionality changes, such as but not limited to creating flex fields, modifying fast formulas, building elements and table setup
• Stay up to date with advancements in Oracle EPM, Power BI and related technologies, recommending and implementing new features and functionalities to enhance data analytics capabilities
• Exposure to configure, maintain and optimize calculation rules, metadata hierarchies, mappings, and reports in Oracle EPM cloud environment
• Leveraging Oracle Narrative Reporting platform and partnering with the Controllership, use best practices to lead the automation of financial report generation and distribution.
• Provide technical guidance, training, and support to the finance team on Oracle EPM usage, troubleshooting, and optimization
• Ensure compliance with regulatory standards and data security protocols in financial reporting automation efforts.
• Assist in preparation of presentations that provide insightful analysis, identify required action items, and effectively frame decisions to be made
• Deliver accurate financial results, including comprehensive analysis of key expenses during the budget, forecast and close processes
• Identify and research variances to forecast, budget and prior year expenses, proactively identifying opportunities for improvement and collaborating with others on a solution
• Develop and maintain effective relationships with business partners and cross functional teams at all levels of the organization

Who You Are

• Minimum 3-5 years of experience in Oracle EPM Reporting, with a focus on Freeform Reporting in Oracle PBCS, FCCS, or similar Oracle EPM tools.
• Candidate should have 3 to 5 years' experience in the Finance domain implementing SQL integrations for Oracle EPM Applications such as Narrative reporting, financial reporting studio, SmartView and Essbase
• Developer with understanding of one or more of the Oracle EPM Cloud Suite modules – Narrative Reporting, Freeform, FCCS, EDM, EPM, freeform and willing to learn and venture into any new modules
• Knowledge of EPM system architecture, including metadata, data integration, and security.
• Experience working with Essbase, planning modules, and data validation.
• Expertise in Oracle EPM Freeform reports, Smart View, and Essbase.
• Proficiency in writing MDX queries, SQL, and experience with EPM Data Management and integration.
• Solid understanding of accounting principles and financial reporting processes.
• Basic understanding of the financial consolidation and budgeting processes.
• Excellent verbal and written and communication skills
• Strategic thinking, strong analytical and problem-solving skills
• Personal presence and ability to clearly communicate compelling messages
• Strong execution ability and a sense of urgency
• Relevant knowledge or experience in Data Governance
• Ability to lead through complex design solutions
• Minimum 5 years of experience in finance or accounting, with at least 3 years developing Oracle EPM suite reports
• Bachelor's degree in Accounting, Finance, MIS/CIS or related field.
• • Excellent analytical and problem-solving skills

Benefits at Gap Inc.

• Merchandise discount for our brands: 50% off regular-priced merchandise at Old Navy, Gap, Banana Republic and Athleta, and 30% off at Outlet for all employees.
• One of the most competitive Paid Time Off plans in the industry.*
• Employees can take up to five “on the clock” hours each month to volunteer at a charity of their choice.*
• Extensive 401(k) plan with company matching for contributions up to four percent of an employee’s base pay.*
• Employee stock purchase plan.*
• Medical, dental, vision and life insurance.*
• See more of the benefits we offer.

*For eligible employees