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 Bachelors Degree preferred, and/or equivalent experience 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 Conduct data profiling and analysis to evaluate and identify the best data sources for business needs Acquire, transform, and translate data into dashboards, reports, datasets, and analytical outputs Perform statistical analyses and present findings that inform decision‑making and guide leadership Support recurring and ad‑hoc reporting requests through a shared analytics request queue Collaborate with technical and project teams, and data engineers on data validation, testing, and quality assurance Work directly with internal customers to refine requirements, validate outputs, and ensure solutions meet expectations Provide technical support for in‑flight projects across data teams and the broader organization Develop a strong understanding of internal systems, databases, and operational processes Identify opportunities for process improvements and contribute actionable recommendations #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 Join our talent community to receive notifications about jobs relevant to your interest. Join our Talent Community! At Unum Group, we're a Fortune 500 company and leading international provider of workplace benefits and services, helping workers and their families thrive for more than 175 years. Through our Unum and Colonial Life brands, our company offers disability, life, accident, critical illness, dental and vision insurance; leave and absence management support; and behavioral health services. Our 10,000+ employees work across operations in the US, UK and Poland, as well as our dedicated Technology Centre in Ireland. Unum Group is committed to working with and providing reasonable accommodations for any applicant with a disability. If you are disabled and need a reasonable accommodation to participate in the application or hiring process, please contact us by submitting a request here.