Back to Job Search

Senior Data Analyst, Banking Marketing

  • Location: San Francisco, 94111
  • Job Type:Contract

Posted 18 days ago

Senior Marketing Data Analyst (Banking)
San Francisco, CA (Bay Area) – Hybrid Remote

Target Start Date: May 2022

What you’ll do as a Data Analyst:

  • Analyze and Document Data requirements from Databases, Marts and Business.
  • Run ad-hoc analysis for Product and Business Managers using standard query languages and operationalize for repeatable use via Tableau reporting suite.
  • Code and modify SQL based on dashboard requirements.
  • Maintain validation of business rules, documentation and distributions to proper stakeholders (especially Marketing and Intelligence Stakeholders).
  • Train and educate co-workers on data analysis and best practices.
  • Participate in design and delivery of curriculum related to rollout of new views to drive adoption and to enhance business decision-making capability.
  • Work closely with Product and Business team to understand business requirement and perform data analysis
  • Ability to derive insights from Data and promote its value to Stakeholders.

You could be a great fit if you have:

  • BA or BS in Management Information Systems, Mathematics, Computer Science, or Engineering required.
  • 8+ years of experience writing advanced SQL, performance tuning of BI queries, data modeling, and data mining from multiple sources (SQL, ETL, data warehousing).
  • Knowledge of Banking & Marketing – with ability to interpret definitions and calculations from business language to developer logic.
  • Experience with portfolio management, CDP (Customer Data Platform) and related reporting.
  • Have experience using business intelligence reporting tools like Tableau, PowerBI.
  • Expertise with Data Analytics best practices.
  • Strong experience required in documenting Data requirements, analyzing gaps, identifying data solutions and insights and building consensus on the same.
  • Possess a strong foundation in data analytics, an understanding and foundation in data science.
  • Have exposure to statistical modeling experience (R, SAS, SPSS). (Preferred).
  • Strong visualization design and development experience with Tableau (and other Business Intelligence tools).
  • Expert in writing SQL.
  • Excellent attention to detail and experience debugging code.
  • Proven track record of delivery for business-critical BI/Analytics projects.
  • Ability to operate with cross-functional teams.
  • Strong quantitative and analytical skills - ability to quickly analyze data to identify key insights and apply them to the business.
  • Clear, high-level understanding of complex data models and software integration/delivery.
  • Excellent communication skills, including ability to present effectively to both business and technical audiences at all levels of the organization.
  • Experience working with Marketing Team, Intelligence Team in a Bank is a plus.
  • Experience working with Digital Data, Marketing Data and its analysis is a plus.
  • May need to support the project as a Scrum Master / Project lead. Proven leadership capabilities, assisting as Scrum Master, experience with JIRA/Confluence and Project lead would be helpful.

Additional Requirements:

  • Must be able to review and analyze data reports and manuals.
  • Must be able to communicate effectively via telephone and in person.
  • Nice to have: Present in Bay area, California and open to come to work at-least 2-3 days per week.  

Primary Deliverables:

  • Work with business stakeholders in documenting requirements based on the identified and prioritized use cases.
  • Understand Customer Data Platform and collect mapping requirements. Prepare CDP requirements document.
  • Ability to run SQL, create view and Analyze Data sources and prepare Data Analysis review document. 
  • Work with functional & technical teams to finalize, document and review the design.
  • Prepare SQL and Perform Data analysis to ensure correctness and quality of data
  • Work with CDP and ETL team for Production readiness
  • Work with QA teams to ensure the deliverables are tested and signed-off.
  • Prepare UAT Test cases, regression Test cases and work with business to validate User Acceptance Testing
  • Assist the Team as a scrum master, managing standups and daily scrums, as needed.
  • Prepare project weekly and monthly status and governance report.