Analytics Specialist

Barfield, Murphy, Shank & Smith LLC.; Birmingham (AL); On-site; USD 55,000 - 75,000; Full time

Job summary

BMSS Advisors & CPAs is seeking an entry-level Data Analyst to transform raw data into actionable insights within a collaborative services environment. You will profile databases with SQL, build dashboards, and support data preparation for decision-making across client engagements.

Ideal candidates hold a bachelor’s in a technical field, have 1–2 years of experience, and are proficient with Excel and BI tools like Tableau or Power BI. A growth-oriented, mentorship-friendly culture awaits.

Qualifications

• Bachelor's degree in computer science, business/data analytics, information systems, statistics, or a related field.
• 1-2 years of professional experience (internships, research or academic projects counted).
• Strong foundation in data principles, logic, and problem-solving.
• Technical skills in SQL with exposure to programming; Excel and data visualization tools (Tableau/Power BI) familiar.
• Exposure to web technologies or database-driven apps (React, HTML, JavaScript); Azure a plus.
• Excellent written and verbal communication; collaborative, detail-oriented, eager to learn.

Responsibilities

• Profile and query system databases using SQL for integrations and end-user reporting.
• Develop and maintain integrations and automate processes via various systems APIs.
• Create dashboards, reports, and visualizations to communicate insights to non-technical stakeholders.
• Support data collection, cleaning, and transformation for analysis.
• Apply statistics and critical thinking to identify trends and actionable insights.
• Collaborate with cross-functional teams to support internal deliverables and reports.
• Continuously grow knowledge in data manipulation, analytics tools, and emerging tech.

Skills

SQL

Excel

Tableau

Power BI

Communication

Collaboration

Education

Bachelor's degree in computer science or data analytics

Tools

Azure

APIs

React

HTML

JavaScript

Job description

Who We Are

At BMSS Advisors & CPAs, we're more than just a top 100 CPA and advisory firm-we're a people-first, relationship-driven team rooted in integrity, collaboration, and community. Founded in Birmingham, AL in 1991, BMSS has grown to ten thriving locations across Alabama and Mississippi-where we're proud to serve our client base with local heart and national reach.

We're known for our family-friendly culture, commitment to mentorship and life-work balance, and deep roots in the communities we serve. In fact, Accounting Today has recognized us as one of the best accounting firms to work for the last 14 years in a row. Whether it's volunteering locally or mentoring the next generation of the firm, we show up-with expertise, empathy, and heart.

The Opportunity

We're seeking a motivated and detail-oriented Data Analyst (Entry Level) to join our growing data analytics team. In this role, you'll apply analytical thinking and technical skills to help transform raw data into meaningful insights that guide business decisions. This position is ideal for early-career professionals eager to build a foundation in data analytics within a collaborative, professional services environment.

What You'll Do

• Use of SQL to profile and query system databases for integrations and end-user reporting
• Frequent use of employing various systems' APIs as a part of creating, maintaining, and innovating integrations and automating processes
• Create dashboards, reports, and visualizations that communicate complex information clearly to non-technical stakeholders
• Support the collection, cleaning, and transformation of datasets for analysis
• Apply statistical and critical thinking skills to identify trends, patterns, and actionable insights
• Collaborate with cross-functional teams to support internal deliverables and reports
• Continuously develop knowledge in data manipulation, analytics tools, and emerging technologies

What We're Looking For

• Bachelor's degree in computer science, business/data analytics, information systems, statistics, or a related field
• 1-2 years of professional experience (internships, research, or academic projects considered)
• Strong foundation in fundamental data principles, logic, and problem-solving
• Technical skills in SQL and exposure to programming; familiarity with Excel and data visualization tools (e.g., Tableau, Power BI)
• Exposure to web technologies or database-driven applications (e.g., React, HTML, JavaScript, or similar), and familiarity with the Azure is a plus
• Excellent written and verbal communication skills
• A collaborative, curious mindset with attention to detail and accuracy. A strong love of learning and a desire to be a life-long learner
• A strong affluence for translating real business problems into technical solutions
• The ability to turn big-picture business processes and thinking into detailed, technical outputs

Why Join BMSS

• Be part of a growing analytics team with opportunities for mentorship and skill development
• Engage in meaningful work that impacts clients across industries
• A culture centered on growth, learning, and community engagement
• Flexible work options and a supportive, team-oriented environment

What We Offer

• Competitive salary and performance-based bonuses
• Company-paid Medical, Dental & Vision insurance
• 401(k) plan with company match
• Generous PTO, paid holidays, and volunteer days
• Training and career development opportunities in data analytics
• A structured career path with opportunities for advancement