Why this persona fits the audience
Handles customer and product exports for a 40-person ecommerce company in Chicago. Moves between CSV files in Excel, JSON snippets in support tickets, and the occasional TOML or YAML config when reconciling data from internal tools; has never paid for a dedicated formatter.
- Age: 31
- Location: Chicago, US
- Occupation: Product Operations Analyst
- Income: $78k/year
- Education: BA in Economics
- Company size: 40
- Years in role: 4
“I didn't realize how much time I'd spend playing data janitor when I got into product ops. Everyone talks about the strategy, but no one warns you about the comma errors.”
Kelly Lueilwitz graduated with an economics degree during the 2016 job market slump, taking a temp position at a Chicago e-commerce startup that eventually hired her permanently. Her degree taught her data patterns but not technical implementation, forcing her to become self-taught in spreadsheet hacks and format conversions. After four years, she's the team's de facto data wrangler, known for her ability to spot inconsistencies others miss. Her current role involves harmonizing customer export data across systems that weren't designed to talk to each other. She's currently navigating the transition from knee-jerk manual fixes to advocating for process improvements, though budget constraints make systemic changes rare. Recent projects include building a crude monitoring system in Excel that alerts her to data anomalies, and she's still waiting for the week when her inbox doesn't contain at least three JSON-related support tickets. Her BA prepared her to think analytically about data, but not for the daily reality of malformed TOML configs and engineers who assume everyone knows how to read JSON at a glance. She's increasingly frustrated by how much time she spends on Data Cleanup Theater instead of strategic analysis. Her side project - a shared Google Sheet with standardized conversion templates - has become the de facto ops team resource, though she still hasn't been given time to document the process officially. Kelly maintains a careful work-life balance, using her weekends to recharge through cooking and local history walks, but the looming Black Friday data surge always casts a shadow over her fall planning.
Background & daily life
A day in their life
Kelly's alarm goes off at 6:30AM. After a quick bowl of oatmeal and green tea, she walks the 15 minutes to her downtown office, listening to a business podcast. Her first task is usually cleaning up overnight exports - removing duplicate order IDs and standardizing shipping addresses in Excel. By 10AM, she's fielding Slack questions from customer support about JSON payloads in their tickets. Lunch is usually a meal-prepped container eaten at her desk while reviewing the day's BI dashboard anomalies. Afternoons are spent coordinating with engineers about data inconsistencies, often requiring her to manually compare CSV exports with database records. She leaves promptly at 5PM to meet her college friends at a quiet tavern downtown, where the conversation invariably drifts to work frustrations over gin and tonics.
Lifestyle
Kelly rents a two-bedroom apartment in a walkable Chicago neighborhood, careful to keep her rent at 30% of income after a tight post-grad period. She meal preps on Sundays, making big batches of lentil soup or braised short ribs that last through the week. Her health is good thanks to daily walks to the office (when not virtual) and a standing desk habit, though her dentist nags her about flossing more. Financially, she automates savings into a mid-risk index fund and pays off her student loans aggressively. Socially, she has a tight-knit group of college friends who meet monthly for game nights, and she stays in touch with her parents in Wisconsin through weekly video calls. Her cat, Basil, is her most vocal companion.
Work life
Kelly's days are a mix of Excel juggling and ad-hoc data diplomacy. Her mornings are spent reconciling customer order exports with inventory systems, often finding herself knee-deep in CSV files with quirks like mismatched delimiters or inconsistent time formats. Afternoons involve translating support tickets with JSON snippets into actionable product updates. She's the accidental expert on TOML formatters after last year's CRM migration left her fixing the last 5% of unprocessed configs. Her team values her attention to detail, though she's occasionally frustrated by workflows that force manual data wrangling. Recent pressures include preparing for Black Friday surges and a looming migration to a new analytics platform. She's become the de facto spreadsheet guru for three other ops team members, though she'd prefer actual documentation over daily ad-hoc training.
Relationships
Kelly's closest relationships are with her college friends - an architect, a nurse, and a freelance writer - who meet monthly for board games and candid career venting. She's protective of her weekends, which she usually spends with her parents (both retired teachers) via video call or a rare trip to Milwaukee. At work, she's friendly but not overly social, known for her no-nonsense approach to data quality. Her mentor in the ops team, Raj, has been her go-to for career advice since she joined three years ago.
How they decide
Kelly prefers to research options thoroughly before committing, especially for work tools that affect her daily productivity. She's skeptical of glossy marketing claims but values practical peer reviews. She tends to try free versions of tools before considering any investment, and she's been burned by overly complex solutions in the past - her current workflow is a patchwork of free tools she's mastered through trial and error.
How they sound
Kelly speaks in measured, precise sentences with occasional midwesternisms ('I shoulda known that would break'). She avoids jargon when talking about data tasks to her non-technical friends, but drops into technical shorthand with coworkers ('We're getting another malformed JSON payload'). She has a dry sense of humor that surfaces in workplace Slack channels but rarely at meetings. She's more likely to say 'That's not ideal' than 'This is terrible' when frustrated.
Personality traits
- Methodical but impatient with inefficient systems
- Loyal to tools she knows well but open to minor upgrades
- Hates asking for IT help unless absolutely necessary
- Keeps a personal spreadsheet for meal planning and budgeting
- Pragmatic in work conflicts but dislikes passive-aggressive communication
- Proud of her ability to read JSON but irritated when it's malformed
- Socially reserved at work but warm with close friends
- Tends to nitpick small inconsistencies in data
- Prefers quiet bars with good wine lists over loud nightclubs
- Uses sticky notes to track minor personal to-dos
Goals
- Get promoted to senior analyst within two years
- Learn basic Python scripting to automate repetitive data tasks
- Save a 20% down payment for a condo within 5 years
- Improve her public speaking through Toastmasters
- Start a small urban herb garden on her balcony
- Maintain her no-spend weekends habit
Problems & frictions
- Frustrated with how often she needs to manually format JSON in emails to engineers
- Feels she's spending too much time on data cleanup that should be automated
- Wants better visualization tools for presenting data to non-technical stakeholders
- The company's
- The company's
- The company's internal wiki is always out of date for new data formats
- Struggles to find reliable YAML-to-CSV converters when dealing with legacy configs
- Occasionally anxious about making data-driven decisions when source files are inconsistent
- Her cat's habit of walking across her keyboard during virtual meetings
Values
- accuracy
- pragmatism
- collaboration
- work-life balance
- self-reliance
Interests
- BI dashboards
- home cooking (especially soups and stews)
- business podcasts
- urban gardening
- local history
Media habits
- Listens to *The Daily* and *Planet Money* during her commute
- Reads *The Economist* and *The Verge* on weekends
- Follows Substack newsletters about data workflows
- Occasionally watches cooking shows when unwinding