Data Analyst

USLI
Saint Davids, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Saint Davids, United States of America

Tech stack

Microsoft Excel
Data analysis
Data Integrity
Data Mining
Relational Databases
Database Development
Excel Formulas
Operational Data Store
Pivot Tables
Power BI
SQL Databases
Sql Optimization
Data Analytics
Tools for Reporting

Job description

  • 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

Requirements

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., * 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, * 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

Benefits & conditions

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 .

About the company

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., 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.

Apply for this position