Lead Data Domain Architect

Overview

On Site
USD 176,000.00 - 205,000.00 per year
Full Time

Skills

FP&A
Management Information Systems
Systems Analysis/design
Sourcing
Management
Change Management
Issue Resolution
Financial Reporting
Dashboard
Microsoft SQL Server
Database
Reporting
Acceptance Testing
Analytics
Business Administration
Business Analytics
Information Systems
Computer Engineering
Data Domain
Business Analysis
Modeling
Account Reconciliation
Translation
Requirements Elicitation
Development Testing
Process Automation
Linux
Operating Systems
Shell Scripting
MaxL
Meta-data Management
MDX
Scripting
Oracle
SmartView
Performance Tuning
OLAP
Cubes
Cloud Computing
Data Management
Writing
SQL
Stored Procedures
Data Engineering
Extract
Transform
Load
Profit And Loss
Presentations
KPI
Management Reporting
Functional Requirements
Workflow
Data Mapping
Data Modeling
Essbase
Migration
Jersey
Health Care
Backup
Finance
Coaching
Recruiting
SAP BASIS
Law
Financial Services
Banking
Financing
Payment Processing
Credit Cards
Sales
Customer Satisfaction

Job Details

Job Description

DESCRIPTION:

Duties: Work closely with Finance Planning and Analysis (FP&A), internal Management Information Systems and technology teams to understand business requirements, drive analysis and design of applications builds and sourcing solutions. Partner with Finance and Business teams to identify new and changing reporting requirements and manage development of end-to-end solutions including development, UAT and change management to production. Coordinate with support groups such as database administrators and server administrators for issue resolution. Work with data and architecture to help design optimal end-to-end solutions and provide operational support to internal customers. Design and maintain data extract procedures for critical financial reporting and dashboards. Partner with SQL server administrators to develop Oracle and SQL databases and ETL procedures to support new reporting solutions. Test and deploy the procedures in UAT and in the production environment. Communicate with internal finance teams/stake holder to comprehend the business requirements and convert them into technical solutions. Validate the finance teams' submissions in the system and resolve queries.

QUALIFICATIONS:

Minimum education and experience required: Bachelor's degree in Finance, Financial Analytics, Business Administration, Business Analytics, Computer Information Systems, Computer Engineering, or related field of study plus 7 (Seven) years of experience in the job offered or as Lead Data Domain Architect, Data Domain Architect, Business Analysis Manager, Business Analyst, Essbase Developer, or related occupation.

Skills Required: This position requires experience with the following: Finance Planning and Analysis processes including bottom-up planning, scenario modeling, 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 and SQL stored procedures; Linux Operating System and shell scripting; Essbase OLAP tool including Essbase multidimensional cube design and development, Calculation scripts and MaXL scripts, and data and metadata load rules development; MDX scripts; Essbase Load rules; Oracle SmartView; Performance tuning of large Essbase OLAP Cubes; Integrating Cloud and on-premise applications to Oracle Essbase using data management; Writing SQL queries, stored procedures for finance data engineering and data pipeline development; Analyzing Profit & Loss statement hierarchies and presenting insights; Analyzing Balance Sheet account types including Assets, Liabilities, and respective time balance aggregation types and presenting insights; Analyzing business requirements for different financial KPIs and translating them into Essbase formulas; Creating management reporting hierarchies, functional requirement, and workflow diagrams; Creating data mapping, data modelling, and Essbase applications migrations.

Job Location: 545 Washington Blvd, Jersey City, NJ 07310.

Full-Time. Salary: $176,000 - $205,000 per year.

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.