Finance Data & Insights Senior Associate

Overview

Be an essential member of a diverse team of professionals dedicated to making a lasting impact!

As a Finance Data & Insights Associate on the Marketing Finance Data & Insights team, you will play a key role in designing, developing, and optimizing data solutions that support the Marketing Finance & Business Management functions. This position requires strong collaboration with business stakeholders and cross-functional teams to deliver a robust Data Mart, efficient ETL processes, and insightful analytics and reporting solutions.

• Design and implement comprehensive and efficient data mart schemas that consolidate key data categories from various source systems, tailored to the needs of the Marketing Finance & Business Management 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 Thought Spot tools, create a robust and efficient reporting environment for marketing 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.

• 5+ years of experience in data management, data engineering, data lineage, data dictionaries, and making data discoverable.
• Bachelor’s degree in Computer Science, Information System, or related discipline.
• 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.
• Experience with Python, Databricks, Snowflake, or other Cloud Data Warehouse, Data Engineering, Data Modeling, ERWIN.
• Ability to deliver complex data projects in a fast-paced, dynamic environment.
• Thought Spot, Tableau, Alteryx, or Essbase experience.