Data Domain Architect Associate Sr

Job Description

Are you a skilled data professional with a passion to transform raw data into actionable insights, and a demonstrated history of learning and implementing new technologies? The Finance Data & Insights Team is an agile product team responsible for the development, production, and transformation of Financial data and reporting across Consumer and Community Banking (CCB). Our vision is to improve the lives of our people and increase value to the firm by leveraging the power of our data and the best tools to analyze data, generate insights, save time, improve processes & control, and lead the organization in developing skills of the future.

As a Data Domain Architect - Sr. Associate in the CCB Finance Data & Insights Team, you will play a key role in delivering monthly internal, external, and regulatory financial results for the Wealth Management line of business. Responsibilities include providing operational business-as-usual (BAU) support, maintaining and enhancing data controls to ensure accuracy and compliance, and identifying opportunities to eliminate manual processes. You will have the opportunity to utilize automation tools such as Alteryx and collaborate with Information Technology partners for system enhancements. The role involves extracting, analyzing, and summarizing data for ad hoc stakeholder requests, as well as contributing to the modernization of our data environment by leveraging new tools and technologies related to artificial intelligence (AI).

Job Responsibilities :

• Contribute to the transformation and modernization of our data environment to serve the analytical and reporting needs of the CB Finance Organization
• 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
• Participate in requirements gathering sessions with varying levels of leadership, complete detailed project planning utilizing JIRA to record planned project execution steps
• Translate business requirements into prototype solutions for new/enhancement requests, with appropriate standards.
• Provide a high level of responsiveness to ad-hoc requests, “what-if” scenario data analytics, and regulatory inquiries
• 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

Required qualifications, capabilities, and skills:

• Bachelor’s degree in MIS, Computer Science, Finance, Accounting, or other related area with relevant work experience
• 3+ 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
• Domain Knowledge: Deep understanding of the specific industry or business domain in which the organization operates
• Data Quality Management: Understanding of strategies and tools for data profiling, cleansing, and validation to maintain high data quality
• Demonstrated experience delivering process improvement or automation
• Highly motivated, self-directed, curious to learn new technologies, strong team player