Lenox Data Analyst Intern - Summer 2024

Who We Are

Lenox Advisors brings together sophisticated solutions in wealth management and insurance services to high-net-worth individuals and their families. As a wholly owned subsidiary of NFP, an Aon Company, we combine the culture of a boutique firm with the stability and backing of a large corporation to create an environment that's truly unique. NFP is a multi-year Best Places to Work award winner in Business Insurance who has also earned the 5-Star Diversity, Equity and Inclusion (DEI) award from Insurance Business magazine and the WORK180 employer endorsement. We’re a recognized Elite Agency award winner and a leading property and casualty broker, benefits consultant, wealth manager, and retirement plan advisor. NFP provides solutions enabling client success through the expertise of over 8,000 global employees, investments in innovative technologies, and enduring relationships with highly rated insurers, vendors and financial institutions. To learn more, please visit: https://www.NFP.com.

Position Summary & Overall purpose:

Lenox is committed to fostering a people-centric workplace that helps you learn and grow as you prepare for life after college. The Business & Strategic Solutions intern will spend 8 weeks assisting with a wide range of data projects across the organization.  This is a cross-functional role and will give the intern a wide variety of opportunities to work with employees from multiple departments.  The data analyst role will be doing significant work leveraging Microsoft Excel, Power BI, and other Microsoft tools.

JOB ACCOUNTABILITIES:

Primary responsibilities include the following:

• Process Improvement & Support
  • Assist with extraction, aggregation, and merging of data across multiple data sources.
  • Help to organize and formalize datasets across multiple departments.
  • Work with Data Analyst to document and formalize data curriculum for organization.
  • Assists with the analysis and recommendation of data processes improvements.
• Data Analysis
  • Assist in analyzing data and preparing reports using Excel or other tools.
  • Conduct basic research on industry trends, competitors, and best practices.
  • Support subject matter expert with documentation on data best practices.
  • Assist with building the automation of data clean-up tasks leveraging Power BI.
• Administrative Support:
  • Help schedule and coordinate meetings, including preparing agendas and taking minutes.
  • Assist with general administrative tasks such as organizing and maintaining team documentation and files.
• Communication and Collaboration:
  • Collaborate with team members to ensure smooth communication and workflow.
  • Assist in preparing internal communications and announcements.
  • Assist with maintenance of Department Intranet Page.

JOB KNOWLEDGE, SKILLS AND/OR ABILITIES:

• Excellent verbal and written communication skills.
• Strong analytical and data interpretation skills.
• Strong client service.
• Extremely detail oriented.
• Positive attitude and team player.
• High level of integrity and strict adherence to protecting confidential information.
• Good organizational and planning skills.
• Experience with Power BI, Tableau, Microstrategy, or other data analytics tools.
• Advanced Microsoft Excel skills.

EDUCATION/EXPERIENCE/LICENSE REQUIREMENTS

• Rising senior of a four-year university preferred.
• Demonstrated leadership experience in college, community, internship, etc.

The hourly range for this position is $20.00 – $25.00 per hour. The base salary offered will be determined by factors including, but not limited to, experience, credentials, education, certifications, skill level required for the position, the scope of the position, and geographic location. Actual base salary offered will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

NFP and You... Better together!

NFP and Lenox Advisors is an inclusive Equal Employment Opportunity employer

FARE2024

STJOHNS2024