Data Domain Architect Lead

Job Description
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.
About Us
Chase is a leading financial services firm, helping nearly half of America's households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs.
We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
Equal Opportunity Employer/Disability/Veterans
About the Team
Our Consumer & Community Banking division serves our Chase customers through a range of financial services, including personal banking, credit cards, mortgages, auto financing, investment advice, small business loans and payment processing. We're proud to lead the U.S. in credit card sales and deposit growth and have the most-used digital solutions - all while ranking first in customer satisfaction.