Henderson Brothers, Inc. is hiring for an entry level Data Analyst role in US

Position:

• Business Data Analyst

Company:

• Henderson Brothers, Inc.

Location:

• Pittsburgh, PA

Job type:

• Full-time

Job mode:

• On-site

Job requisition id:

• Not mentioned

Years of experience:

• 0-3 years

---

Company Description

• Henderson Brothers, Inc. is a fourth-generation, family-owned insurance brokerage headquartered in Pittsburgh, PA.

• The company has been in business since 1893, establishing itself as a trusted source of insurance services across both local and global markets.

• Henderson Brothers provides a broad range of offerings including commercial insurance, employee benefits, personal insurance, and financial services.

• Their client base includes small businesses, large enterprises, and individual policyholders.

• The firm places a strong emphasis on core values like humility, kindness, and exceptional client service.

• It’s not just about insurance at Henderson Brothers—it's about crafting meaningful, long-lasting client relationships and offering bespoke, risk-mitigating solutions.

• Known for their ethical business practices and people-first culture, they have earned recognition as a Top Workplace in the Pittsburgh region.

• They have more than 175 skilled professionals serving customers and collaborating with some of the nation's top insurance carriers.

• The team works cohesively, driven by a strong sense of purpose and dedication to client success and internal collaboration.

• Diversity, equity, and inclusion are central to their workplace philosophy, creating an environment where people of all backgrounds can thrive.

---

Profile Overview

• As a Business Data Analyst, you will be at the intersection of data analysis and strategic decision-making.

• This role sits within the Employee Benefits department, focusing on transforming raw datasets into actionable insights.

• You will regularly work with internal stakeholders, clients, and technical teams to ensure the accuracy and usability of analytics deliverables.

• A major part of your work involves generating visual and analytical reports through tools like Power BI or Tableau, assisting clients in making informed benefit-related decisions.

• You'll be responsible for not just crunching numbers but also contributing to business strategies through thoughtful, data-backed storytelling.

• Collaboration will be crucial—expect to work closely with IT teams, operations staff, and account managers to fine-tune reporting tools and analytics models.

• The role demands continuous interaction with various data sources such as insurance claim feeds, agency systems, and third-party data repositories.

• You’ll also be expected to bring innovation into workflow processes, identifying bottlenecks and automating repetitive tasks.

• From the get-go, you’ll be handling real client data and participating in team discussions that shape employee benefits offerings.

• Overall, this is a role that offers exposure to technical, business, and client-service dimensions, making it an ideal stepping stone for analysts aiming to build robust professional foundations.

---

Qualifications

• A Bachelor’s degree is mandatory, preferably in fields like Data Analytics, Information Systems, Mathematics, Statistics, or related business analytics disciplines.

• Candidates should ideally have 0 to 3 years of work experience in data analytics or a similar field.

• Exposure to IT systems and databases is considered a valuable asset, especially in data integration and automation contexts.

• Previous hands-on experience with data management, data wrangling, or business intelligence tools will be helpful.

• Strong proficiency in Microsoft Excel is essential. Familiarity with advanced Excel features like pivot tables, VLOOKUP, data models, and Power Query is expected.

• Experience with data visualization platforms such as Power BI or Tableau is highly preferred.

• You must be comfortable preparing and presenting insights to both technical and non-technical stakeholders.

• Excellent communication skills are crucial, particularly the ability to translate complex findings into simple business terms.

• Strong attention to detail, time management, and independent problem-solving abilities are important.

• A curious and proactive mindset is valued, especially someone who enjoys streamlining processes and finding hidden insights in datasets.

---

Additional Info

• This role comes with a competitive and guaranteed base salary along with bonus opportunities tied to performance and company success.

• Employees enjoy access to comprehensive health benefits including medical, dental, and vision insurance.

• The firm provides a 401(k) retirement plan with a 4% company match, encouraging long-term financial planning.

• Flexible work schedules are available to support better work-life integration.

• Tuition reimbursement and student loan relief programs help support continued education and financial wellness.

• The company offers a sizable time-off policy that includes paid holidays, vacation days, and sick leaves.

• Employees also have access to mentoring and growth opportunities through cross-functional team projects and client-facing initiatives.

• You will be joining a collaborative team that values mutual respect and support, where every contribution counts.

• Henderson Brothers is deeply committed to fostering a diverse and inclusive workplace. They welcome applicants from all walks of life and ensure fair hiring practices.

• As a Business Data Analyst, you’ll be joining a workplace with a median employee tenure of 7.4 years, indicating a high level of employee satisfaction and retention.

---

Responsibilities

Data Collection and Cleaning

• Gather data from multiple sources including:

  • Internal agency management systems

  • External vendor feeds

  • Health insurance claims databases

• Ensure regular data validation checks are performed to maintain data accuracy and integrity.

• Maintain adherence to compliance and data security standards.

Data Analysis

• Evaluate benefit plan performance using collected datasets.

• Identify key cost drivers, employee usage patterns, and emerging trends in benefits consumption.

• Translate complex data sets into strategic recommendations to support internal and client-side decision-making.

Data Visualization and Reporting

• Design and maintain interactive dashboards using tools like Tableau or Power BI.

• Develop customized reports for different stakeholders including clients, internal teams, and leadership.

• Deliver insights in a format that aligns with both technical and non-technical audiences.

Process Automation and Optimization

• Discover and implement ways to automate manual data entry tasks.

• Integrate various data sources using Excel-based tools or third-party APIs.

• Design streamlined workflows to enhance operational efficiency.

Cross-functional Collaboration

• Partner with IT teams to align back-end reporting tools with analytics outputs.

• Work closely with client service teams to ensure reports are meeting client expectations and timelines.

• Participate in business meetings to present findings and support data-driven decision-making.

Strategic Forecasting

• Use predictive analytics to anticipate future trends in healthcare and benefits utilization.

• Help design benefit packages that are cost-effective and aligned with workforce expectations.

• Provide insights that directly contribute to client retention and satisfaction.

Documentation and Training

• Maintain proper documentation of workflows, data dictionaries, and dashboard functionality.

• Offer training sessions to new employees or clients on how to interpret and use reports effectively.

• Continuously update internal knowledge bases as data infrastructure evolves.

Please click here to apply.

✖

Before you go further ...

or

Direct apply link!