Data Domain Architect - Senior Associate

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 our Wealth Management line of business. You will identify opportunities to eliminate manual processes and utilize automation tools such as Alteryx and partner with our Information Technology partners for system enhancements. You will extract analyze and summarize data for ad hoc stakeholder requests and play a role in transforming our data environment to a modernized cloud platform.

Job 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
• Participate in intelligence solution 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
• 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
• 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
• Become a subject matter expert in our financial reporting platforms and support team members in becoming more proficient themselves

Required qualifications capabilities and skills

• Bachelors 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 business intelligence analytics 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 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

Preferred qualifications capabilities and skills

• 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)

For this particular role we are unable to sponsor any type ofwork visa including but not limited to H1B H4 EAD OPT E3 TN or L visas.

This role does not have a relocation allowance tied to it so all candidates must be local to Columbus OH Wilmington DE or Jersey City NJ offices or willing to relocate on their own immediately upon hiring.

Final Job Grade level and corporate title will be determined at time of offer and may differ from this posting.