Entry-Level Data Analyst

About the job
About Us

Framing Ideas LLC is a Chicago-based graphic design and web development company that has proudly served over 2,000 small businesses across the U.S. We specialize in crafting visually compelling and strategically effective design and web solutions tailored to the needs of entrepreneurs and small business owners.
As we continue to grow, we are expanding our use of data to improve internal operations, better understand our customers, and provide added value to our clients. We are seeking an Entry-Level Data Analyst to help us do just that-while also contributing to select client projects that require data insight and reporting.

Job Description

As our Entry-Level Data Analyst, you’ll collaborate with Sales, Design, and Web Development teams to collect and analyze data critical to our growth. You'll track internal performance, forecast trends, and deliver customer insights that inform our marketing and operational strategies. You’ll also assist with client-facing data projects, providing valuable analysis and reports to help our customers make informed business decisions.
This is a remote position required to present findings or support on-site client meetings.

Key Responsibilities

Gather, clean, and organize internal data from the Sales, Design, and Web Development teams
Analyze sales data to assess trends, forecast revenue, and evaluate individual/team performance
Analyze customer data to determine:
Geographic distribution (e.g., city, region)
Industry segmentation
High-value client profiles
Growing industries for future outreach and marketing
Forecast business expenses and resource needs as the company scales
Develop dashboards and reports to support internal decision-making
Assist in data-focused client projects, such as cleaning datasets, building dashboards, and generating insights
Present data clearly and effectively to both internal stakeholders and clients, including during occasional in-person meetings

Qualifications

Bachelor’s degree in Mathematics, Economics, Statistics, Business Analytics, or related field
Proficiency in Excel and working knowledge of SQL
Strong analytical and problem-solving skills
Familiarity with data visualization tools (e.g., Tableau, Power BI, or Google Data Studio)
Strong communication skills, both written and verbal
Detail-oriented and capable of working independently in a remote setting

Nice to Have

Experience with Python or R for data analysis
Understanding of small business needs or creative agency workflows
Comfort working with clients and presenting data in non-technical terms

What We Offer

Flexible remote work structure
Hands-on experience with both internal business data and external client projects
Opportunities for growth and professional development
A creative, fast-paced work environment where your work has real impact