Data Analyst - Marketing Data & Insights

Charlotte, NC (Hybrid)

$100K/yr – $179K/yrMid Level4+ years expPart time

Posted 3 months ago

Top 1% of applicants do these two things.

The other 99% submit and hope. You're about to do something different.

Job Summary

Drive data product design and governance for Wells Fargo’s Marketing Offers Decisioning Utility by leading data requirements, mapping, and test readiness.

  • Must-have: 4+ years in data product or data management with SQL proficiency.
  • Standout: Ability to translate upstream/downstream data needs into user stories and tests across Agile teams.

Job Description

Responsibilities

  • Understand the vision of the Marketing Offers Decisioning Utility team, and participate in technical sessions to brainstorm how to bring that vision to life.
  • Lead technical & data design sessions, working with SME's to understand and capture net new functional and non-functional design requirements, and rules requirements.
  • Identify upstream and downstream data and integration needs, conducting detailed review of articles such as API code, data element mappings, etc. to confirm mutual understanding of both needs and potential deliverables.
  • Support and actively participate in Agile routines; serving as "back up" to the Product Owner when they are not available
  • Engage with CDP, Marketing, and other stakeholders to generate technical requirements (user stories) to support downstream audit, analytical and reporting needs.
  • Leverage AI accelerators to generate (write) and "story point" user stories to capture upstream and downstream data and integration needs, and work with the Product Owner to confirm that stories are assigned to sprints in accordance with delivery expectations
  • Conduct source to target mapping, conduct data lineage exercises in an environment with minimal metadata to identify root source of record and capture necessary transformation to the data from source of record to the point of presentation/consumption
  • Conduct & document repeatable, pattern-based testing scenarios for new product releases according to documented control procedures
  • Leverage analytical & SQL skills to diagnose root cause of noted production or testing defects
  • Work with Technology to generate the necessary stories to remediate noted defects, both in interim and in the long-term
  • Assist the Product team in creating succinct communications to build consensus, communicate change, report issues and report progress to stakeholders
  • Manage risk & compliance: Embed risk, controls, and policy requirements into product design and delivery; ensure audit readiness and operational excellence.
  • Support implementation and validation of Data quality checks, Control Requirements, and data governance documentation
  • Assist with audit responses and production evidence gathering when requested.
  • Escalate data quality risks to senior product leadership as appropriate.

Requirements

  • 4+ years of data product or data management experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
  • Proficiency in SQL, including experience writing complex queries; experience with HiveQL preferred
  • Experience supporting data pipelines, including data ingestion, transformation, curation, and creation of analytical or reporting datasets
  • Experience working in an Agile or Scrum delivery environment, including backlog support, sprint activities, and collaboration with product and engineering teams.

Preferred

  • Exceptional communication, organizational, and stakeholder influence skills
  • Strong UNIX, BTEQ skills
  • Familiarity with Hadoop / HDFS / Hive
  • Familiarity with Hue, Dremio, or other similar data workbenches is a plus
  • Familiarity with Python or a similar programming language for data analysis
  • Experience with DROOLS, rules development, and rules management

Benefits

  • Health benefits
  • 401(k) Plan
  • Paid time off
  • Disability benefits
  • Life insurance, critical illness insurance, and accident insurance
  • Parental leave
  • Critical caregiving leave
  • Discounts and savings
  • Commuter benefits
  • Tuition reimbursement
  • Scholarships for dependent children
  • Adoption reimbursement
Wells Fargo logo

Wells Fargo

3.6 Glassdoor

Wells Fargo & Company (NYSE: WFC) is a diversified, community-based financial services company with approximately $1.9 trillion in assets. Wells Fargo’s vision is to satisfy our customers’ financial needs and help them succeed financially. Founded in 1852 and headquartered in San Francisco, Wells Fargo provides banking, investment and mortgage products and services, as well as consumer and commercial finance, through more than 7,300 locations, 12,000 ATMs, the internet (wellsfargo.com) and mobile banking, and has offices in over 40 countries and territories to support customers who conduct business in the global economy. With approximately 250,000 team members, Wells Fargo serves one in three households in the United States. Wells Fargo & Company was ranked No. 41 on Fortune’s 2022 rankings of America’s largest corporations. News, insights and perspectives from Wells Fargo are also available at Wells Fargo Stories. Relevant military experience is considered for veterans and transitioning service men and women. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected characteristic.© 2016 Wells Fargo Bank, N.A. All rights reserved. Member FDIC.

Founded in 1997
San Francisco, California, USA
218K employees (3,215 in marketing)
63% recommend to a friend
65% CEO approval

Traffic Signals

Monthly Visitors
90.7M
Monthly Google Ads Budget
$7.8M
Traffic Source Mix
Search
20.2%
Direct
76.2%
Referral
2.7%
Social
0.4%
Paid
0.4%

Headcount Trend

Current headcount: ~219.1K

Marketing Team

Marketing Team Size
2,214 (1% of company)
Median Career Experience
21 years
Median Tenure
6.3 years
Marketing Roles Posted (Last 30 Days)
8

Recent News