Data Analyst

Location:Wayne, PATeam:AccountingJob Type:AccountingFT/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 toolsExcel analysis: Utilize advanced Excel functions (PivotTables, formulas, data modeling) to support reporting processesClose support: Assist with monthly, quarterly and year-end close through reconciliation, validation and reportingFinancial data review: Analyze premiums, claims, commissions, reserves and general ledger dataData integrity: Monitor data quality, investigate discrepancies and resolve variancesProcess improvement: Organize and maintain data structures and automate recurring reporting processesRegulatory reporting: Support statutory, regulatory and management reporting requirementsCross-functional collaboration: Partner with Accounting, Finance, Actuarial and Operations teams to deliver data-driven solutionsDocumentation: Document data sources, methodologies and reporting logicCommunication: Present findings clearly to technical and non-technical stakeholders and support ad hoc requestsWhat 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 opportunitiesQualifications: Education: Bachelor’s degree or equivalent business experience Experience: data extraction, reconciliation and reporting tools. Familiarity with relational databasesKnowledge: Advanced SQL, Power BI and Excel skillsPreferred: 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.