Data Domain Architecture Associate

We have an opportunity to impact your career and provide an adventure where you can push the limits of whats possible.

As a Data Domain Architect in the consumer and community banking Finance PXT Reporting and Insights product team you partner closely with business stakeholders and analytics colleagues to define and evolve our data domains and architecture. You use your expertise in modern data platforms data modeling and data governance to design trusted scalable data marts and reporting solutions that make data accessible discoverable and ready for this role you play a key part in shaping the data strategy and enabling datadriven decisions across PXT Finance.

Job Responsibilities

• Design and implement comprehensive and efficient data mart schemas that consolidate key data categories from various source systems tailored to the needs of the PXTRI functions.
• Collaborate with Business stakeholders to understand requirement and accordingly map source & calculation logic
• Collaborate with cross-functional teams including data engineers data analysts and technical specialists to gather and analyze business requirements.
• Develop implement and optimize data workflows Extract Transform Load (ETL) processes and data pipelines using Databricks.
• Utilizing Databricks and ThoughtSpot tools create a robust and efficient reporting environment for PXT Finance data analytics and reporting.
• Work closely with your business domain Product teams and business stakeholders to: 1) design and develop insightful reporting and analytics solutions that drive informed decision-making; 2) apply design led thinking to meet their needs including making data discoverable and accessible for analytical needs.
• Maintain up-to-date documentation on data mart architecture data models ETL processes and data governance policies.

Required qualifications capabilities and skills:

• Overall 4 years of experience in Data Analysis Metadata Management Data lineage and making data discoverable
• Strong knowledge and experience with data Engineering data lineage data dictionaries and making data discoverable
• Good Knowledge of data architecture data warehousing and data integration with a focus on the retail banking or financial services industry.
• Expertise in designing and implementing scalable and efficient data mart architectures including star schema snowflake schema and other data modeling techniques.
• Bachelors degree in Computer Science Information System or related discipline
• Experience with Python Databricks Snowflake or other Cloud Data Warehouse Data Modeling ERWIN
• Proven track record of successfully managing and delivering complex data projects in a fast-paced dynamic environment.
• ThoughtSpot Tableau Alteryx or Essbase experience

Preferred qualifications capabilities and skills:

• Demonstrated senior leadership in terms of attitude initiative and inclusivity
• Agile backlog management tools (JIRA Confluence)

Required Soft Skills:

• Excellent communication and presentation skills
• Strong command of the English language (written and verbal)
• Excellence in the creation of presentations especially PowerPoint
• Team player