Tagetik Technical Architect

Schneider Electric•Franklin, OH

35d•Onsite

About The Position

Schneider Electric USA, Inc. seeks a Tagetik Technical Architect in Franklin, TN. This role involves creating Analytical Workspace (AIH) and Financial Workspace (FW) dimensions, developing code using Query Analyzer to consolidate data from multiple sources into a single interface, and setting up schedulers for daily data refreshes and automation of various data sources. The architect will also gather requirements for designing, building, and consulting on Financial Consolidation, planning and budgeting solutions using Hyperion Financial Management (HFM), Hyperion Planning and Essbase, Financial Quality Management Enterprise Edition (FDMEE), Financial Reporting (HFR), and Smart View. Expertise in ETL Financial Data Quality Management Enterprise Edition is required, including developing import formats and underlying logic in ETL FDMEE, writing and automating consolidation scripts, and executing parent nodes in HFM and Essbase. The role also includes setting up source interface tables for data staging before FDMEE import, identifying and eliminating intercompany transactions through the ICP module, understanding and developing logic for ICP accounts, developing data forms in HFM and planning, managing end-to-end mappings for Hyperion Planning and Essbase cubes (BSO and ASO), and setting up and managing HFM, planning, and Essbase security for global business users.

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's degree.
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
Fixing FDMEE validation issues and mapping errors.

Responsibilities

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.