Business Intelligence Analyst I - SQL (SSMS)/Adv Excel

When you join the team at Unum, you become part of an organization committed to helping you thrive.

Here, we work to provide the employee benefits and service solutions that enable employees at our client companies to thrive throughout life’s moments. And this starts with ensuring that every one of our team members enjoys opportunities to succeed both professionally and personally. To enable this, we provide: 

• Award-winning culture 

• Inclusion and diversity as a priority 

• Performance Based Incentive Plans

• Competitive benefits package that includes: Health, Vision, Dental, Short & Long-Term Disability 

• Generous PTO (including paid time to volunteer!) 

• Up to 9.5% 401(k) employer contribution 

• Mental health support 

• Career advancement opportunities 

• Student loan repayment options 

• Tuition reimbursement

• Flexible work environments 

*All the benefits listed above are subject to the terms of their individual Plans.

And that’s just the beginning…  

With 10,000 employees helping more than 39 million people worldwide, every role at Unum is meaningful and impacts the lives of our customers. Whether you’re directly supporting a growing family, or developing online tools to help navigate a difficult loss, customers are counting on the combined talents of our entire team. Help us help others, and join Team Unum today! 

General Summary:

The Business Intelligence Analyst I is responsible for simple to moderately complex data analysis, preparation and visualization. They will use their technical and domain expertise to translate data into meaningful insights for teams and leaders to confidently take action on. The ideal candidate will be passionate about all things data, and we seek a creative and analytical thinker to help us solve our most challenging problems. This position will work closely with technical and project teams, as well as business teams across the Dental & Vision Network organization for requirements gathering and validation.

​Job Specifications

• 2+ years of experience in a data analytics or technical analytical role

• Proficient experience using SQL (SSMS),

• Experience with BI and visualization tools (Tableau, Power BI, Alteryx, or similar)

• Advanced proficiency in Excel

• Demonstrated ability to translate business questions into technical solutions

• Familiarity with Python or other analytics programming languages

• Experience with Salesforce or API‑based data environments

• Exposure to Access, VBA, or Power Query

• Understanding of data profiling, statistical analysis, and basic data modeling concepts

• Experience working with data warehouses, transactional databases, and structured datasets

• Strong problem‑solving, critical thinking, and communication skills

• Ability to balance priorities, deadlines, and stakeholder expectations 

Principal Duties and Responsibilities

#LI-AD1

~IN1

Unum and Colonial Life are part of Unum Group, a Fortune 500 company and leading provider of employee benefits to companies worldwide. Headquartered in Chattanooga, TN, with international offices in Ireland, Poland and the UK, Unum also has significant operations in Portland, ME, and Baton Rouge, LA - plus over 35 US field offices. Colonial Life is headquartered in Columbia, SC, with over 40 field offices nationwide.

Unum is an equal opportunity employer, considering all qualified applicants and employees for hiring, placement, and advancement, without regard to a person's race, color, religion, national origin, age, genetic information, military status, gender, sexual orientation, gender identity or expression, disability, or protected veteran status.

The base salary range for applicants for this position is listed below. Unless actual salary is indicated above in the job description, actual pay will be based on skill, geographical location and experience.

$60,500.00-$123,400.00

Additionally, Unum offers a portfolio of benefits and rewards that are competitive and comprehensive including healthcare benefits (health, vision, dental), insurance benefits (short & long-term disability), performance-based incentive plans, paid time off, and a 401(k) retirement plan with an employer match up to 5% and an additional 4.5% contribution whether you contribute to the plan or not.  All benefits are subject to the terms and conditions of individual Plans.

Company:

Unum