Data Operations Analyst

Job Location: Chicago, Raleigh, Charlottesville

How to Apply:

Please send your resume to Harrison Brendle, harrison@hopperblue.com. In your email please include why this role aligns with your strengths as a data-focused analyst.

The Role

Come put your skills to work alongside the largest names in the IT industry!

We are seeking a highly analytical, detail-oriented Data Operations Analyst who thrives on cleaning, structuring, and connecting complex datasets. This role is centered on account matching, dataset alignment, and turning multiple data sets into a single, trustworthy view.

The ideal candidate loves working in Excel, SQL, and Python, enjoys solving messy data problems, and has a strong instinct for how entities relate to one another across systems (accounts, companies, partners, vendors, locations, and hierarchies).

This is a remote position, with a preference for candidates based in the Chicago area. 

Who are you? You…

• Have a passion for solving complex problems, a love for data, and an understanding of how to connect data sets
• Think in tables, joins, and relationships
• Possess strong analytical skills with the ability to untangle inconsistent, incomplete, or misaligned data
• Have a strong intuition for how businesses, accounts, and entities connect
• Value accuracy, structure, and repeatable processes
• Take pride in creating clean, auditable datasets others can rely on
• Have a keen attention to detail and experience in data analytics, statistics, relational databases, and manipulating large data sets using a variety of technical tools
• Are organized, resourceful, and proactive
• You are energized by turning “spreadsheet chaos” into clarity

What You will be doing:

The Data Operations Analyst partners closely with internal teams and clients to prepare, align, and analyze data that supports sales, marketing, and channel initiatives.
 

Core Responsibilities:

• Clean, normalize, and transform large datasets from multiple sources
• Transpose, restructure, and standardize data for analysis and matching
• Perform account matching and entity resolution across vendors, distributors, resellers, and end customers
• Build and maintain data relationships between operational, sales, and marketing datasets
• Identify patterns, overlaps, gaps, and growth opportunities through relational analysis
• Execute data alignment projects using SQL-based matching tools and logic
• Validate data accuracy and resolve inconsistencies across systems
• Produce structured outputs that feed reporting, dashboards, and downstream workflows
• Analyze sales, marketing, and operational data to identify trends, growth opportunities, and inefficiencies 

Analytical & Technical Work:

• Develop automated workflows and reporting tools using Excel, Power Query, and Python to streamline repetitive tasks
• Document assumptions, matching logic, and data rules for repeatability
• Support projects by delivering clean, reliable datasets
• Write Python scripts for data transformation, enrichment, and automation
• Apply SQL concepts to join, filter, and reconcile relational datasets

Skills Required:

• 3+ years of experience in data analysis, data operations, or business intelligence
• Advanced Excel skills (Power Query, Pivot Tables, formulas, modeling)
• Working knowledge of SQL and relational database concepts
• Hands-on experience with data cleaning, normalization, and deduplication
• Proven experience with account matching, entity resolution, or data alignment
• High attention to detail and strong data-quality instincts

Nice to Have:

• Experience working with CRM, ERP, or sales/marketing data 
• Familiarity with IT channel data (vendors, distributors, resellers)
• Strong Python experience (Pandas, NumPy, data transformation workflows)
• Experience supporting sales or marketing analytics
• Exposure to BI tools (Power BI, Tableau, Domo)
• Understanding of how data supports revenue programs and partner strategy

Who are we?

HopperBlue is a Chicago-based consulting firm specializing in channel and sales data analytics. We help clients turn fragmented data into actionable insight, enabling smarter collaboration, better targeting, and measurable ROI.

Our work sits at the intersection of data, operations, and strategy—supporting large, multi-company sales and marketing initiatives through clean data and strong analytical foundations.

We offer competitive pay and benefits, including health insurance, 401(k), profit sharing, paid time off, and a flexible work environment.
 

How to Apply:

Please send your resume to Harrison Brendle, harrison@hopperblue.com. In your email please include why this role aligns with your strengths as a data-focused analyst.

We look forward to reviewing your application and potentially having you join our team. 

HopperBlue is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.