Adv Excel

Unum•Portland, ME

About The Position

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 Business Analysts, BI Analysts, Data Scientists, Data Engineers and directly with the business units for requirements gathering and validation.

Requirements

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
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

Nice To Haves

Familiarity with Python or other analytics programming languages
Experience with Salesforce or API‑based data environments
Exposure to Access, VBA, or Power Query

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

Benefits

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