Schneider Electric USA, Inc. seeks a Tagetik Technical Architect in Franklin, TN.
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.
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; and Fixing FDMEE validation issues and mapping errors.
To Apply: Visit http://careers.se.com and search Req#117658
€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.
