Consumer Bank - Data Domain Architect - Vice President

Our vision is to improve the employee experience 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.

You are able to think beyond raw data and understand the underlying business context and opportunities hidden in data. Your passion lies in eliminating user tools, saving time and increasing the ability to generate insights through data, dashboards, and developing new capabilities.

As a Data Domain Architect on the Field Performance Management Product, you will contribute to the transformation and modernization of our data environment to serve the analytical and reporting needs of the Consumer and Community Banking (CCB) Finance Organization.

You will partner with the Area Product Owner, Data Owner and Technology Team to source, design and deliver data domains into the Databricks powered Data Mart that brings together essential data categories to enable the Finance function to support their analytical and reporting needs.

You will understand the need of Finance and make data discoverable and available for analytical and reporting needs. Through your ability and passion to think beyond raw and disparate data, you will use both existing and cutting edge software solutions to empower team to get rapid answers to key performance questions that will be utilized by the organizations top leaders to reach out key strategic imperatives.

Job Responsibilities

• Lead intelligence solution requirements gathering sessions with varying levels of leadership, complete detailed project planning utilizing JIRA to record planned project execution steps
• Source and maintain the Financial and Operational data required to transform and maintain the Field Performance Reporting scorecards on a weekly basis
• Conduct detailed reconciliation of results between systems and intelligence solution
• Generate detailed metadata on existing and new data models
• Partner in the development of, or individually create data wrangling workflows, data visualization solutions utilizing ThoughtSpot and Tableau and other end-user reporting interfaces and that provides intuitive insights to our key stakeholders
• 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
• Seek to become a subject matter expert and understand the stakeholder use cases empowering you to anticipate stakeholders requirements, questions, and objections

Required qualifications, capabilities and skills

• Minimum of 7 years of experience in data architecture, data warehousing, and data integration, with a focus on the retail banking or financial services industry
• Bachelor’s degree in MIS or Computer Science / IT, Mathematics, Engineering, Statistics or other quantitative or financial subject areas
• Experience with relational databases optimizing SQL to pull and summarize large datasets, report creation and ad-hoc analyses
• Experience with business intelligence analytic and data wrangling tools such as Alteryx, SAS, Essbase or Python.
• Experience building visualization with ThoughtSpot or Tableau
• Experience with Hive, Spark SQL, Impala or other big-data query tools
• Strong knowledge and experience with data management, data lineage, data dictionaries, and making data discoverable
• Experience as a hands-on leader, leading by example and diving in along side your team rather than just directing
• Data Modeling and Design : Proficiency in designing data models that effectively represent the business requirements and ensure data integrity
• Data Governance : Understanding of data governance principles, policies, and practices to ensure data quality, security, and compliance
• Database Management : Expertise in managing various types of databases (SQL, NoSQL) and understanding of their strengths and limitation

Preferred qualifications, capabilities and skills

• Experience in reporting development and testing, and ability to interpret unstructured data and draw objective inferences given known limitations of the data
• Hyperion Essbase cube design and administration experience
• Strong knowledge of AWS and Amazon S3 Data Lake. Databricks, Snowflake, or other Cloud Data Warehouse experience
• Experience on market leading data catalog systems

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

Candidates must be able to physically work in our Columbus, OH office 3 days a week and remotely from home 2 days per week.

The specific schedule will be determined by direct management.

LI-HYBRID