Finance Data Domain Architect - Vice President

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 Lead within the Consumer and Community Banking Finance Data & Insights Team, you will play a pivotal role in delivering monthly internal, external, and regulatory financial results for our Wealth Management line of business. You will pinpoint opportunities to eradicate manual processes and employ automation tools such as Alteryx, and collaborate with our Information Technology partners for system enhancements.

You will extract, analyze, and summarize data for ad hoc stakeholder requests, and play a significant role in transitioning our data environment to a modernized cloud platform.

• Contributing to the transformation and modernization of our data environment to serve the analytical and reporting needs of the CCB WM Finance Organization
• Lead intelligence solution requirements gathering sessions with varying levels of leadership, complete detailed project planning utilizing JIRA to record planned project execution steps
• Partnering 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
• Understanding data architecture, data integration, and data warehousing, as well as strong interpersonal skills to collaborate with stakeholders and ensure alignment with the organization's objectives
• Source and maintain the Financial and Operational data required to transform and maintain the Wealth Management reporting
• Conduct detailed reconciliation of results between data systems and business intelligence tools
• Partner in the development of data wrangling workflows, data visualization solutions utilizing Thought Spot and Tableau and other end-user reporting interfaces and that provides intuitive insights to our key stakeholders
• Work with IT to migrate to production the developed solutions and as an SME/escalation point for the deployed solutions
• Work closely with end-users/IT during the UAT phase of the project and validate that production results comply with business requirements and expected results
• Provide a high level of responsiveness to ad-hoc requests, what-if scenario data analytics, and regulatory inquiries
• Develop expertise in our financial reporting platforms and support data analysis requests while supporting team members in becoming more proficient themselves

• Minimum 8 years of experience in data analytics, architecture, or financial reporting systems
• Proficient user of the Microsoft Office Suite (primarily Excel)
• Experience with business intelligence analytic and data wrangling tools such as Alteryx, SAS, or Python
• Experience with relational databases optimizing SQL to pull and summarize large datasets, report creation and ad-hoc analyses
• Data Quality Management:
  Understanding of strategies and tools for data profiling, cleansing, and validation to maintain high data quality
• Domain Knowledge:
  Deep understanding of the specific industry or business domain in which the organization operates
• Demonstrated experience delivering process improvement or automation
• Highly motivated, self-directed, curious to learn new technologies
• Strong analytical and problem-solving ability
• 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…