Senior Analytics Engineer

unlimited holidays - extra holidays
Work set-up: 
Full Remote
Contract: 
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

Proven experience as an Analytics Engineer or similar role with a strong track record in building data models., Expertise in dbt, including developing complex models, macros, and testing frameworks., Advanced SQL proficiency for writing complex, high-performance queries and transforming business logic., Hands-on experience with Snowflake and data modeling principles like Kimball's dimensional modeling..

Key responsibilities:

  • Transform complex data into reliable, business-ready data models using dbt and SQL.
  • Apply software engineering best practices, including version control and CI/CD, within the analytics workflow.
  • Collaborate with stakeholders across departments to understand their data needs and deliver solutions.
  • Lead end-to-end development of critical data assets and proactively improve data model performance.

Thimble logo
Thimble Insurance Startup https://www.thimble.com/
11 - 50 Employees
See all jobs

Job description

About Us
Thimble is a leading insurtech platform for small business customers and agents. Thimble allows customers to quickly get insurance coverage by the job, month or year using its awardwinning app, website, or over the phone.

Founded by serial entrepreneurs, Thimble works with a variety of carriers to bring the best insurance solutions to small businesses, brokers and agents. Since it was founded, Thimble has delivered more than 170,000 policies to small businesses across the United States.

Thimble was acquired by Arch Insurance, a unit of Arch Capital Group Ltd. (Nasdaq: ACGL), a publicly listed Bermuda exempted company with approximately $24.3 billion in capital at March 31, 2025. Arch, which is part of the S&P 500 Index, provides insurance, reinsurance and mortgage insurance on a worldwide basis through its wholly owned subsidiaries.

Thimbles innovative culture and technical expertise are an incredible addition to Arch Capital’s portfolio of offerings. The acquisition expands Arch’s suite of digital solutions for small business customers and brokers. Thimble will remain a separate subsidiary, working closely with the Arch Group team.

For more information, visit thimble.com.


Our Values
Our unique culture is built around our six core values:

Think Wild, Act Tame
Be relentlessly creative. Question everything. Get to know the rules so well, you can use them in new ways. Be the industry’s compliant radicals.

Green Means GO
Act. Move forward. Learn. You can only make a decision based on the best information you have – so make it.

Own Every Detail
Be ruthlessly precise. Disciplined. Sweat the small stuff.

Simplify, Simplify, Simplify
Get to the point. Make it crystal clear. Cut everything else. It’s our job to make insurance easy – however hard that is for us.

Every Moment Counts
Show up early and ready. Deliver on time or before. Make the most of your time, so others can make the most of theirs.

Stay Human
Treat every person, and their ideas, with respect. Cherish diversity.


About the Role
We are seeking a highly skilled Senior Analytics Engineer to be the crucial bridge between our raw data and businesscritical insights. In this pivotal role, you will be responsible for transforming complex data from various sources into clean, reliable, and businessready data models that power decisions across the entire organization. You will own the T in our ELT process, applying software engineering rigor to the analytics workflow within our modern data stack (Snowflake, dbt, Fivetran).

This is a highimpact position for someone who is passionate about building trust in data, thrives on translating business needs into elegant technical solutions, and wants to empower stakeholders in Product, Finance, and Marketing to perform selfservice analytics with confidence using tools like Omni.

Roles and Responsibilities
  • Data Modeling and Transformation:
  • Take ownership of the transformation layer in our data stack, developing, testing, and deploying robust, scalable, and welldocumented data models using dbt and advanced SQL.
  • Apply data modeling best practices, including dimensional modeling (Kimball), to structure raw data—including heavily nested JSON from our application databases (MongoDB)—into performant and intuitive fact and dimension tables.
  • Collaborate with stakeholders (including Product, Engineering, Finance, Acquisition, and Business Development) to drive deeper, datainformed decisionmaking across the company.
  • Develop and maintain curated data layers that serve as the single source of truth for downstream consumption in our BI tool (Omni) and reverse ETL platform (Hightouch).
  • Applying Software Engineering Practices to Analytics:
  • Champion and implement software engineering best practices within the analytics workflow, including version control (Git) for all dbt models and CICD pipelines for automated testing and deployment.
  • Build a comprehensive suite of automated data quality and integrity tests (e.g., using dbt tests, custom Python scripts) to ensure the reliability and trustworthiness of all data products.
  • Create and maintain extensive documentation and a data catalog, ensuring that key business metrics are clearly defined and that valuable datasets are easily discoverable by all users.
  • EndtoEnd Analytics Development and Business Partnership:
  • Serve as the primary analytics partner for key business functions, embedding directly with stakeholders in Product, Finance, and Marketing to understand their strategic goals and challenges. You will independently translate their ambiguous questions into formal technical requirements and project documentation.
  • Execute on the requirements youve defined by personally designing, building, and implementing the curated, reliable data models in dbt that power our BI platform (Omni). Your role extends beyond just enabling selfservice; you will often conduct the initial deepdive analysis yourself to deliver immediate answers and insights back to the business.
  • Use Python and AWS Lambda where appropriate to enhance our analytics capabilities, such as for performing advanced data quality checks or automating data enrichment tasks.
  • Project Ownership:
  • Lead the development of critical data assets from endtoend, including requirement gathering, technical design, implementation in dbt, and validation with business users.
  • Take ownership of specific business domains within our data warehouse (e.g., product engagement, customer lifecycle, financial performance), becoming the goto expert for that data.
  • Proactively identify opportunities to improve data model performance, simplify logic, and increase the business impact of our analytics platform.

  • What We’re Looking For
  • Proven experience as an Analytics Engineer, or a similar role such as a BI Developer or datafocused Software Engineer, with a strong track record of building productiongrade data models.
  • Core expertise in dbt, including developing and deploying complex models, writing macros, and implementing a robust testing and documentation framework.
  • Expertlevel, productiongrade SQL proficiency, with the ability to write complex, highlyperformant queries and transform intricate business logic into code.
  • Strong handson experience with a cloud data warehouse, particularly Snowflake, with a focus on advanced usage, query optimization, and leveraging platform features for efficient modeling.
  • Deep, practical understanding of data modeling principles, especially Kimballs dimensional modeling (starsnowflake schemas).
  • Experience transforming and unnesting complex, semistructured data sources, particularly nested JSON.
  • Proficiency in Python for scripting data quality tests, automation, and light API interactions. Familiarity with deploying scripts on AWS Lambda is a plus.
  • Experience creating curated data layers to power BI tools (Omni or similar) and reverse ETL platforms (Hightouch).
  • A disciplined approach to applying software engineering best practices to analytics, including Git, CICD, and automated testing.
  • Excellent communication and collaboration skills, with a demonstrated ability to translate ambiguous business requirements into precise technical specifications for both technical and nontechnical audiences.
  • Experience with data ingestion tools like Fivetran and event tracking platforms like Fullstory or Amplitude.
  • A proactive, productoriented mindset with a passion for building trustworthy data solutions that have a measurable business impact.

  • What You’ll Do in 30 Days
  • Gain a deep understanding of our business logic and key metrics by diving into our dbt project and core Omni dashboards.
  • Familiarize yourself with our data architecture, including how data flows from sources like Fivetran and our application database through Snowflake and into Omni and Hightouch.
  • Meet with key stakeholders in Product, Finance, and Marketing to understand their primary analytical challenges and how they use data today.
  • Get your development environment fully configured and make your first contributions to our dbt project, such as improving documentation, adding tests to an existing model, or fixing a bug.

  • What You’ll do in 60 Days
  • Take ownership of your first data domain (e.g., Engineering and Product Management data from Jira).
  • Begin refactoring and optimizing a core set of dbt models to improve performance, clarity, and reliability, implementing a robust suite of data quality tests.
  • Deliver your first significant enhancement to a businessfacing dataset, collaborating with an analyst to validate the changes and roll them out in Omni.
  • Establish yourself as a key resource for stakeholders in your owned domain, proactively answering questions and providing guidance on data usage.

  • What You’ll do in 90 Days
  • Independently lead the development of a major new data model from scratch, from gathering stakeholder requirements to designing the schema and deploying the final, tested models to production.
  • Demonstrate clear business impact by launching a new set of analytical capabilities powered by the data models you’ve built.
  • Become a primary advocate for data quality and best practices, mentoring other team members and confidently shaping the technical direction of our analytics code base.
  • Proactively identify and scope your next major project, demonstrating a deep understanding of both our technical stack and our strategic business priorities.
  • Thimbler Benefits & Perks!
    Fully remote company
    Thimble Fridays! (out of office at 12:00pm local time)
    Comprehensive health, vision, and dental coverage
    401(k) auto enrollment and matching (100% of the first 3% and 50% of the next 3%)
    PTO: 20 days vacation + 8 floating days + 10 companywide holidays + 1 VTO (Volunteer Time Off) + unlimited sick time
    Parental Leave: 100% paid 12 weeks + 2 weeks gradual return
    Computer choice of Mac or PC
    Work from home setup reimbursement
    Monthly coworking space andor child care reimbursement
    Monthly ClassPass credit
    Quarterly wellness reimbursement
    Other health & wellness perks including: One Medical, Teladoc, Talkspace, Kindbody, and Health Advocate
    Virtual events, happy hours, trivia, and fun!
  • Required profile

    Experience

    Level of experience: Senior (5-10 years)
    Industry :
    Insurance
    Spoken language(s):
    English
    Check out the description to know which languages are mandatory.

    Other Skills

    • Collaboration
    • Communication
    • Problem Solving

    Related jobs