Data Domain Architect Senior Associate

JPMorganChase•Wilmington, NC

About The Position

As a Data Domain Architect - Sr. Associate in the CCB Finance Data & Insights Team, you will be a skilled data professional focused on transforming raw data into actionable insights. This role involves delivering monthly internal, external, and regulatory financial results for the Wealth Management line of business. Key responsibilities include providing operational business-as-usual (BAU) support, maintaining and enhancing data controls for accuracy and compliance, and identifying opportunities to eliminate manual processes. You will utilize automation tools like Alteryx, collaborate with Information Technology partners for system enhancements, and extract, analyze, and summarize data for ad hoc stakeholder requests. The position also contributes to modernizing the data environment by leveraging new tools and technologies related to artificial intelligence (AI).

Requirements

Bachelor’s degree in MIS, Computer Science, Finance, Accounting, or other related area with relevant work experience.
5+ years of experience in data analytics, architecture, or financial reporting systems.
Experience with relational databases optimizing SQL to pull and summarize large datasets, report creation and ad-hoc analyses.
Experience with business intelligence analytics and data wrangling tools such as Alteryx, SAS, or Python.
Deep understanding of the specific industry or business domain in which the organization operates (Domain Knowledge).
Understanding of strategies and tools for data profiling, cleansing, and validation to maintain high data quality (Data Quality Management).
Demonstrated experience delivering process improvement or automation.
Highly motivated, self-directed, curious to learn new technologies, strong team player.
Strong analytical and problem-solving ability; Excellent written and verbal communication skills.
Experience in reporting development and testing, and ability to interpret unstructured data and draw objective inferences given known limitations of the data.
Strong knowledge and experience with data management, data lineage, data dictionaries, and making data discoverable.

Nice To Haves

Experience with Hive, Spark SQL, Impala or other big-data query tools.
Experience with ThoughtSpot.
AWS, Databricks, Snowflake, or other Cloud Data Warehouse experience.
Hyperion Essbase cube design and administration experience.
Experience eliminating user tools, saving time, and increasing ability to generate insights through data, dashboards, and developing new capabilities.
Proficient user of the Microsoft Office Suite (primarily Excel).

Responsibilities

Contribute to the transformation and modernization of our data environment to serve the analytical and reporting needs of the CCB WM Finance Organization.
Execute and take ownership of operational processes with an emphasis on accuracy and timeliness of meeting deliverables on prescribed timetables / calendars.
Identify hidden problems and patterns in data proactively and use those insights to drive process improvements.
Conduct detailed reconciliation of results between data systems and business intelligence tools.
Work with IT to migrate to production the developed solutions and as an SME/escalation point for the deployed solutions.
Provide a high level of responsiveness to ad-hoc requests, "what-if" scenario data analytics, and regulatory inquiries.
Participate in requirements gathering sessions with varying levels of leadership, complete detailed project planning utilizing JIRA to record planned project execution steps.
Partner with the Technology Team to design and deliver data domains into the Finance Data Mart that brings together essential data categories to enable the Finance function to support their analytical and reporting needs.
Source and maintain the Financial and Operational data required to transform and maintain the Wealth Management reporting.
Become a subject matter expert in our financial reporting platforms and support team members in becoming more proficient themselves.