Remote Data Excellence Analyst - Insights that Drive Outcomes

Socotra, Inc.; Town of Poland (NY); Remote; USD 36,798 - 46,660; Full time

Benefits offered by this job

100% Remote Work

Unlimited Paid Time Off

Private Healthcare (Lux Med)

Helping Hand Program

Meaningful Equity

High-Growth Startup Environment

Exposure to the U.S. Insurance Market

Career Growth Opportunities

International Team & Cross-Border Coll

Job summary

Ledgebrook is seeking an experienced Data Analyst, Data Excellence to join our Product & Data team. You will lead efforts to transform insurance data into clear insights, collaborate across data engineering, insurance product, claims, finance and operations, and automate reporting using VBA, SQL and Python.

You will deliver deep-dive analyses, build tools, and create solutions to automate workflows while enabling data-driven decision making across the organization.

Qualifications

• Strong proficiency with SQL and Excel (ideally including VBA and Power Query).
• Good knowledge of Power BI or other BI tools (e.g. Tableau, Looker).
• Exposure to or proficiency in programming languages (e.g. Python, R) and experience with modern databases, ideally with Snowflake.
• Exposure to Power Automate and Power Apps, DataGrip / Cursor, and Jira would be an asset.
• Ability to translate complex data into actionable business insights.
• Excellent communication and presentation skills to collaborate with stakeholders across the organization.
• Navigating a startup environment, fast paced and dealing with uncertainty.
• Nice to have: Property, Specialty or Casualty insurance data experience, strong interest in AI and ML tools.

Responsibilities

• Lead analytical efforts to drive data-informed decision-making across the organization by gathering, analyzing, and visualizing/analyzing technical insurance data.
• Collaborate with data engineering, insurance product, claims, finance and operations teams to improve data integrity and automate reporting capabilities using VBA, SQL and Python.
• Transform complex insurance data into clear, compelling insights for both technical and non-technical stakeholders through reporting and data visualization.
• Develop analytical tools, deliver dedicated solutions to help other departments automate workflows, and identify opportunities to enhance business performance.
• Provide ad hoc analytical support and research to ensure data-driven precision.

Skills

SQL

Excel

VBA

Power Query

Power BI

Python

R

Snowflake

Jira

Communication

Presentation

Data visualization

Tools

DataGrip

Cursor

Jira

Job description

Ledgebrook is seeking an experienced Data Analyst, Data Excellence to join our Product & Data team. You will lead efforts to transform insurance data into clear insights, collaborate across data engineering, insurance product, claims, finance and operations, and automate reporting using VBA, SQL and Python.

You will deliver deep-dive analyses, build tools, and create solutions to automate workflows while enabling data-driven decision making across the organization.