Tagetik Technical Architect

Job Description: Create Analytical Workspace (AIH) and Financial Workspace (FW) dimensions. Develop code using Query Analyzer to source multiple sources of data into one single interface. Setup scheduler for daily data refreshes and automate the various data sources within scheduler. Gather requirements for designing, building, and consulting Financial Consolidation. Plan and budget solution through Hyperion Financial Management (HFM), Hyperion Planning and Essbase, Financial Quality Management Enterprise Edition (FDMEE) Financial Reporting (HFR), and Smart View along with expert knowledge on ETL Financial Data Quality Management Enterprise Edition. Develop import formats and underlying logic in ETL FDMEE. Write and automate consolidation scripts and execute each parent node in hyperion financial management and Essbase. Setup source interface tables to have data staging before FDMEE import. Identify and eliminate intercompany transactions through ICP module. Understand and develop a logic, Job Description: Create Analytical Workspace (AIH) and Financial Workspace (FW) dimensions. Develop code using Query Analyzer to source multiple sources of data into one single interface. Setup scheduler for daily data refreshes and automate the various data sources within scheduler. Gather requirements for designing, building, and consulting Financial Consolidation. Plan and budget solution through Hyperion Financial Management (HFM), Hyperion Planning and Essbase, Financial Quality Management Enterprise Edition (FDMEE) Financial Reporting (HFR), and Smart View along with expert knowledge on ETL Financial Data Quality Management Enterprise Edition. Develop import formats and underlying logic in ETL FDMEE. Write and automate consolidation scripts and execute each parent node in hyperion financial management and Essbase. Setup source interface tables to have data staging before FDMEE import. Identify and eliminate intercompany transactions through ICP module. Understand and develop a logic for ICP accounts. Develop data forms in HFM and planning based on specific intersections and dynamic combination of data. Develop and manage end-to-end mappings for Hyperion Planning and Essbase cubes BSO and ASO. Setup and manage HFM, planning and Essbase security for business users across the globe.

for ICP accounts. Develop data forms in HFM and planning based on specific intersections and dynamic combination of data. Develop and manage end-to-end mappings for Hyperion Planning and Essbase cubes BSO and ASO. Setup and manage HFM, planning and Essbase security for business users across the globe.

Requirements: Bachelor's degree, or foreign equivalent, in Business Administration, Computer Science, or related. Employer will accept a combination of post-secondary academic degrees evaluated as the equivalent of a Bachelor's in lieu of a Bachelor's degree. Three (3) years of experience in technical architecture or related. Employer will accept pre- or post- degree experience including pre-Bachelor'sdegree. Academic background, internship, or work experience to include: Experience with at least two (2) end-to-end Tagetik implementation and application development cycles; CCH Tagetik Data Model Design and Configuration, ETL development and Integrations, and TQL Scripting; Designing and implementing Tagetik's Performance management, Consolidation, Budgeting and Planning modules; Implementing Enterprise Management applications HFM, FDMEE and Essbase & Planning; Developing Data Transformation Package (DTPs), virtual datasets and data sources; Setting up target dataset, typology, reporting layers and run conditions; Developing Tagetik dataset Operations including Enrichment with formulae and matching fields; Configuring data pipelines between AIH and FW; Developing Quick Data loader (QDL) and defining source and target data integrations dynamically; Porting of technical objects from DEV to UAT and using MDM approach; Writing SQL queries and using Query Analyzer to retrieve big volume of data from HANA database; and Fixing FDMEE validation issues and mapping errors.

When you are thinking about joining a new team, culture matters. At Schneider Electric, our values and behaviors are the foundation for creating a great culture to support business success. We believe that our IMPACT values - Inclusion, Mastery, Purpose, Action, Curiosity, Teamwork - starts with us. IMPACT is also your invitation to join Schneider Electric where you can contribute to turning sustainability ambition into actions, no matter what role you play. It is a call to connect your career with the ambition of achieving a more resilient, efficient, and sustainable world. We are looking for IMPACT Makers; exceptional people who turn sustainability ambitions into actions at the intersection of automation, electrification, and digitization. We celebrate IMPACT Makers and believe everyone has the potential to be one. Become an IMPACT Maker with Schneider Electric - apply today! €40 billion global revenue +9% organic growth 150 000+ employees in 100+ countries You must submit an online application to be considered for any position with us. This position will be posted until filled. Schneider Electric aspires to be the most inclusive and caring company in the world, by providing equitable opportunities to everyone, everywhere, and ensuring all employees feel uniquely valued and safe to contribute their best. We mirror the diversity of the communities in which we operate, and 'inclusion' is one of our core values. We believe our differences make us stronger as a company and as individuals and we are committed to championing inclusivity in everything we do. At Schneider Electric, we uphold the highest standards of ethics and compliance, and we believe that trust is a foundational value. Our Trust Charter is our Code of Conduct and demonstrates our commitment to ethics, safety, sustainability, quality and cybersecurity, underpinning every aspect of our business and our willingness to behave and respond respectfully and in good faith to all our stakeholders. You can find out more about our Trust Charter here