What are the responsibilities and job description for the Data Domain Architect Lead position at JPMorgan Chase?
DESCRIPTION:
Duties: Work closely with Finance Planning and Analysis (FP&A), internal Management Information Systems and technology teams to understand business requirements, and drive analysis and design of application builds and sourcing solutions. Support 100 financial reporting and analytical Essbase OLAP cubes month-end accounting close processes by performing data/metadata loads, data reconciliations, and data extracts for downstream systems reporting in a highly complex Production environment. Coordinate with support groups to resolve issues quickly. Work with data and architects to help design optimal end-to-end solutions and provide operational support to internal customers. Advise on applicant best practices, and design and maintain data extract procedures for critical financial reporting and dashboards. Work on the creation of management reporting hierarchies, JIRA stories, functional requirements, and workflow diagrams. Perform data mapping, data modelling, and applications migrations. Support the incident resolutions for issues such as data discrepancies, system performances, and hierarchy anomalies in the systems reported by Finance and Operations teams.
QUALIFICATIONS:
Minimum education and experience required: Bachelor's degree in Software Engineering, Computer Science, Computer Information Systems, or related field of study plus 7 years of experience in the job offered or as a Data Domain Architect Lead, Business Intelligence Lead, Senior Application Analyst, Solution Architect, Technical Lead, or related occupation.
Skills Required: This position requires experience with the following: FP&A processes including bottom-up planning, scenario modelling, allocations, account reconciliations, restatements, currency translation and top-side adjustments; Oracle Essbase development lifecycle, including requirements gathering, process designing, artifacts development, testing, migration and maintenance; Oracle Essbase process automation through ETL tools, SQL stored procedures, REST API, and UNIX and Powershell scripting; Essbase calc scripts, MDX and MaXL scripts, load rules, Oracle SmartView reporting, and performance tuning of large Essbase OLAP Cubes; Integrating cloud and On-premise applications to Oracle Essbase using data management, data maps and Groovy scripting; and P&L, BalanceSheet, and KPIs accounting concepts and processes.
Job Location: 1111 Polaris Pkwy, Columbus, OH 43240.
