WHAT YOU'LL DOThe candidate will have a hands-on role for all technical activities relating to BCG’s Financial Consolidation and Reporting function. This scope includes management of the existing Hyperion Financial Management (HFM) platform and the future SAP S/4 Hana platform, plus all associated integrations with on-prem/ SaaS products within BCG. Responsibilities will cover future system design and configuration changes, business rule and financial report development, data integration design, patching and system maintenance, as well as playing a critical role on future architecture design decisions. The candidate will provide operational support within an agile team, system enhancements following our two-week sprint process as well as perform all other related tasks, such as:Support and maintain the HFM platform as a technical subject matter expert, including patching on at least a bi-annual basis on 3 environments (Dev, Test, Production)Participate in the migration of consolidation and reporting capabilities from HFM to SAP S/4 Hana and transition support and maintenance activities to that new platform in 2024.Lead team development tasks with road map activities and be a contributing participant during the decision-making processLead small and medium size projects as a technical subject matter expert. Be responsible for the full delivery of the solution including but not limited to architecting design, development and go live activitiesProvide technical oversight during the monthly and annual financial close processes, and act as a primary point of contact for Global Accounting and ControlAssist with updates / maintenance of existing ETL process utilizing various tool such as ODI / FDMEE as well as updating SQL queriesEnhance and support automation activities utilizing existing technical capabilities and third party toolsUse industry standards to ensure code version controls are followed during object updates / code correction (business rules)Work collaboratively with team in supporting the monthly Hierarchy update processAssist and provide technical support on issues, to ensure proper root cause analysis and quick remediationProvide third tier guidance and support to the team on Hyperion Financial Reports as well as be the technical subject matter expert on new report developmentSupport and assist Hyperion Smart View related issuesYOU'RE GOOD ATAbility to work closely with users and provide a high level of customer service in a friendly, professional mannerStrong analytical abilities and creative problem solving to understand full end to end processes, and data modelsHighly skilled in Microsoft ExcelExcellent documentation skillsAbility to work independently with general directionExcellent communication skills across cultures in EnglishIntegrity and a positive attitudeReliability and being a cooperative team player; consideration and respect for othersTact, patience, and the ability to handle stressful situations with aplombHigh flexibility and commitment to personal goals and directionsAttention to detail, well organized, able to prioritizeSome travel might be needed for this roleYOU BRING (EXPERIENCE& QUALIFICATIONS)College degree and experience in the development and support of business applications in a commercial IT setting, or in consulting3-5 years of IT/Financial Accounting experience, previous analytic or business analysis experience required3- 5 years of combined experience with Hyperion Financial Management (11.1.2.4 or higher), Hyperion Financial Reports, SmartView and Hyperion Shared Services, or equivalent in the SAP S/4 Hana platform.3- 5 years of experience supporting data integrations using FDMEE and ODI, building ODI data models and creating topology for various technologies, both inbound and outbound.Advanced experience with scripting languages, specifically Visual Basic (required), Python/Jython (preferred).Familiarity with Planning application design and development, including Oracle Essbase and Hyperion Planning (Essbase Cube design, maxL/mdx scripting etc) (preferred).Strong database background in Oracle, including advanced knowledge of PL/SQL, ODIExperience working with PBCS or EPBCS (preferred)Experience with EPMAutomate and batch scripting languages (preferred)Diverse experience in application tools, languages and frameworksExperience with SAP S/4 HANA Public Cloud a plusYOU'LL WORK WITHBCG’s information technology group collaboratively delivers the latest digital technologies that enable our consultants to lead and our business to grow. For our IT jobs, we seek individuals with expertise in the areas of IT infrastructure, application development, business systems, collaborative and social technologies, information security, and project leadership.ADDITIONAL INFORMATIONCandidates should be aware that BCG currently maintains a policy requiring all US & Canada based employees to be fully vaccinated against COVID-19. Newly hired employees must be fully vaccinated prior to their employment start date. BCG is an equal opportunity employer and will provide a reasonable accommodation to those unable to be vaccinated for medical or religious reasons where it is not an undue hardship to the company to do so as provided under applicable federal, state, provincial and local law.