Lenox Data Analyst Intern - Summer 2025 - Military Veterans
at NFP
NFP Corp
To apply for this position please CLICK HERE
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 10 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
NFP is an Equal Opportunity Employer that provides equal opportunities to all employees and applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, genetic predisposition or carrier status, or any other characteristic protected by federal, state or local law. The Company is committed to this policy with respect to recruitment, hiring, placement, promotion, transfer, training, compensation, benefits, employee activities and general treatment during employment. It’s expected that all of our employees are aware of this policy and that they create an environment that’s sensitive and respectful to all individuals.
NY
Who We Are
NFP, an Aon Company, 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 are an organization of consultative advisors and problem solvers. We help companies and individuals around the globe address their most significant risk, workforce, wealth management and retirement challenges through custom solutions and a people-first approach. To learn more, please visit: https://www.NFP.com.
Our teams strive to embody excellence in everything we do – and we’re proud to be recognized for it. Our vision isn’t all about the numbers. But we’ve found that our reputation as an exceptional provider of personal and corporate consultative services hasn’t gone unnoticed. We’re proud to say we’re the:
- #7 Largest benefits broker by global revenue, Business Insurance
- #8 Best place to work in insurance, Business Insurance
- #8 Commercial lines agency, Insurance Journal
- #10 Largest property & casualty agency, Insurance Journal
- #13 Personal lines agency, Insurance Journal
- #13 Global insurance broker, Best's Review
- #13 Largest broker of US business, Business Insurance
We’re also proud to offer a competitive salary, PTO & paid holidays, 401(k) with match, exclusive discount programs, health & wellness programs, and more. Our PeopleFirst culture focuses on building and nurturing lifelong relationships with our employees because, at the end of the day, we exist to be there for others.
NFP and You... Better Together!
NFP is an inclusive Equal Employment Opportunity employer.