Data Analyst

Back to Open Opportunities


Returning Applicant? Login Now



Notice: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time. However, USLI reserves its right to provide employment-based immigrant visa assistance on a discretionary basis.


Explore USLI's extensive company benefits, perks, and more below! *Not applicable to External Customer Program


U.S. Benefits


Canada Benefits


Data Analyst Location: Wayne, PA Team: Accounting Job Type: Accounting FT/PT Status: Full Time

*This position requires working onsite at our Wayne, PA office. Candidates must be able to commute to and from this location on a full-time basis.


About Us: At USLI, we're not just about insurance - we are committed to making a difference, both internally and externally. Our community is built upon five values: Caring, Attitude, Respect, Empathy and Energy. Our commitment to these values leads us to make better decisions and furthers our true sense of community. By joining our team, you'll be part of a vibrant organization that values innovation, collaboration and growth. Here, you'll have the opportunity to shape the future of insurance and make a meaningful impact.

Your Role : This role is responsible for transforming financial and operational data into actionable insights that support accounting operations, regulatory reporting, financial analysis and strategic decision-making. The ideal candidate combines strong technical expertise in SQL, Power BI and Excel, with a solid understanding of accounting processes and a natural curiosity to explore data, identify trends and improve reporting accuracy and efficiency.

Key Responsibilities:

• Data analysis : Collect, extract and analyze data from multiple systems to support accounting, finance and insurance reporting needs
• SQL development : Develop, maintain and optimize SQL queries to retrieve, validate and reconcile financial data
• Dashboard reporting : Design, build and maintain interactive dashboards using Power BI and similar tools
• Excel analysis : Utilize advanced Excel functions (PivotTables, formulas, data modeling) to support reporting processes
• Close support : Assist with monthly, quarterly and year-end close through reconciliation, validation and reporting
• Financial data review : Analyze premiums, claims, commissions, reserves and general ledger data
• Data integrity : Monitor data quality, investigate discrepancies and resolve variances
• Process improvement : Organize and maintain data structures and automate recurring reporting processes
• Regulatory reporting : Support statutory, regulatory and management reporting requirements
• Cross-functional collaboration : Partner with Accounting, Finance, Actuarial and Operations teams to deliver data-driven solutions
• Documentation : Document data sources, methodologies and reporting logic
• Communication : Present findings clearly to technical and non-technical stakeholders and support ad hoc requests

What You'll Bring:

• Technical expertise : Advanced SQL, Power BI and Microsoft Excel skills
• Analytical skills : Strong problem-solving ability with a focus on root cause analysis
• Attention to detail : High level of accuracy in financial reporting and reconciliation
• Communication skills : Ability to clearly explain complex data insights to diverse audiences
• Team mindset : Collaborative approach with strong organizational and multitasking abilities
• Curiosity : Proactive mindset to explore data, uncover trends and identify opportunities

Qualifications:

• Education: Bachelor's degree or equivalent business experience
• Experience: data extraction, reconciliation and reporting tools. Familiarity with relational databases
• Knowledge: Advanced SQL, Power BI and Excel skills
• Preferred: Familiarity with insurance industry and/or insurance accounting concepts

What We Offer: One of the advantages of working at USLI is the competitive salary and benefits program we offer full-time and eligible part-time employees. Benefits include performance-based triannual bonuses, medical benefits paid at 100% for full-time employees and 80% for eligible part-time employees, a profit-sharing program, free lunch every day while on-site and more than 450 annual personal and professional development courses. Explore more company benefits .

Why USLI? At USLI, we are committed to fostering a vibrant and inclusive community that celebrates the rich diversity of all ethnicities, nationalities, abilities, genders, gender identities, sexual orientations, ages, religions, socioeconomic backgrounds and life experiences. We understand the importance of continuous learning, self-reflection, acknowledging our biases and expanding our perspectives beyond our own. We actively encourage open dialogue on diversity, equity, inclusion and belonging to support a workplace where every individual feels valued, respected and empowered to contribute at their fullest potential. Join us in building a diverse and inclusive environment where our shared values drive us toward excellence.