Data Analyst

Pay: $55,000-$65,000At a Glance

Application Requirement: Candidates must complete the required pre-employment assessments to be considered for this position.

• Location: Lake Barrington, IL (On-site)
• Schedule: Full-time
• Pay: $55,000–$65,000 annually (based on experience)
• Experience: 1–3 years
• Tools: SQL, Python (Pandas), Excel, Microsoft Access, Power BI/Tableau
• Benefits: Health, Dental, Vision, 401(k) Match, PTO, Bonus Opportunities, Onsite Gym

Who We Are

Union One is a growing benefits management firm focused on providing essential income protection solutions to union members. As we continue to expand, we are committed to building an inclusive, ethical, and collaborative workplace where every team member is heard, ideas are valued, and innovation is encouraged.

Our mission is to deliver peace of mind through smart, supportive, and secure group benefit solutions. Guided by our core values—integrity, service, insight, and advocacy—we take pride in supporting union members through life’s unexpected moments.

It’s an exciting time to join Union One as we continue to grow and make a meaningful impact.

Position Overview

As a Data Analyst at Union One, you will play a key role in turning data into meaningful insights that drive strategic business decisions. As a Data Analyst at Union One, you will transform complex data into actionable insights that support business strategy, operational efficiency, and informed decision-making. Working closely with stakeholders across the organization, you'll help identify trends, improve reporting processes, and support data-driven initiatives.

Key Responsibilities

• Develop and manage databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.
• Interpret data, analyze results using statistical techniques, and provide ongoing reports.
• Design and construct SQL queries for data analysis and access.
• Work closely with management to prioritize business and information needs.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Collaborate with engineering and product development teams to enhance data collection procedures.
• Drive the design and implementation of new data analysis projects.

Required Qualifications

• Bachelor's degree in Mathematics, Statistics, Computer Science, Economics, Information Management, or a related field
• 1+ year of experience with SQL
• 1+ year of experience with Python and Pandas
• 1+ year of experience with Microsoft Excel
• Experience working with relational databases and large datasets
• Strong analytical, problem-solving, and communication skills

Preferred Qualifications

• Experience with Power BI or Tableau
• Experience creating process documentation
• Experience in insurance, benefits administration, or financial services

Work Authorization

The Company does not currently sponsor employment visas.

Why Join Us?

• Competitive compensation and comprehensive benefits
• Opportunities for career growth and advancement
• A collaborative, innovative, and people-first culture built on trust, transparency, and teamwork
• Exposure to leadership and participation in cross-functional initiatives
• Access to modern tools and technologies that support your success
• A supportive workplace culture that promotes work-life balance, inclusion, and belonging

License/Certification:

• Illinois Drivers License (Required)

Equal Employment Opportunity

Union One is an Equal Employment Opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, pregnancy, national origin, ancestry, age, disability, veteran status, marital status, or any other protected status.

Accommodations

Union One provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable law.

Apply

If you're analytical, detail-oriented, and passionate about turning data into actionable insights, we'd love to hear from you. Join a collaborative team where you'll have opportunities to grow your skills and make a meaningful impact.

As part of the application process, candidates will be required to complete two pre-employment assessments. Completion of both assessments is necessary for consideration.

Job Type: Full-time

Pay: $55,000.00 - $65,000.00 per year

Benefits:

• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid holidays
• Paid time off
• Vision insurance

Application Question(s):

• Explain your recent personal projects.
• Please complete the assessments at the following link: https://www.ondemandassessment.com/o/JB-WN44B9O1J/landing?u=1210202. • To be considered for this role, candidates must complete the required assessment as part of the application process. Please indicate below if you have completed the assessment.

Education:

• Bachelor's (Required)

Experience:

• SQL: 1 year (Required)
• Python: 1 year (Required)
• Microsoft Excel: 1 year (Required)

License/Certification:

• Illinois Drivers License (Required)

Ability to Commute:

• Lake Barrington, IL 60010 (Required)

Work Location: In person