Finance Data & Insights Senior Associate
at J.P. Morgan
Posted a month ago
No clicks
- Compensation
- Not specified
- City
- Wilmington
- Country
- United States
Currency: Not specified
Join the Marketing Finance Data & Insights team to design, develop, and optimize data mart architectures, ETL pipelines, and reporting solutions that support Marketing Finance and Business Management. You'll work with Databricks, Snowflake, Python, and reporting tools like ThoughtSpot to build scalable data workflows and analytics environments. The role requires close collaboration with business stakeholders, product teams, and cross-functional data engineers and analysts to translate requirements into robust data models and discoverable datasets. Maintain documentation and data governance while delivering insights that drive financial decision-making.
Location: Wilmington, DE, United States
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 DataMart, efficient ETL processes, and insightful analytics and reporting solutions.
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 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 ThoughtSpot 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.
Required qualifications, capabilities, and skills
- 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.
- ThoughtSpot, Tableau, Alteryx, or Essbase experience.
