Senior Analytics Engineer

Summary

Join Thimble, a leading insurtech platform, as a Senior Analytics Engineer and bridge the gap between raw data and crucial business insights. Transform complex data into clean, reliable models to power organizational decisions. You will own the transformation layer in the ELT process, using your software engineering expertise within our modern data stack (Snowflake, dbt, Fivetran). This high-impact role requires passion for building data trust, translating business needs into technical solutions, and empowering stakeholders with self-service analytics using tools like Omni. You will partner with Product, Finance, and Marketing teams, leading data asset development from requirement gathering to deployment. Proactively identify opportunities to enhance data model performance and business impact.

Requirements

• Proven experience as an Analytics Engineer, or a similar role such as a BI Developer or data-focused Software Engineer, with a strong track record of building production-grade data models
• Core expertise in dbt, including developing and deploying complex models, writing macros, and implementing a robust testing and documentation framework
• Expert-level, production-grade SQL proficiency, with the ability to write complex, highly-performant queries and transform intricate business logic into code
• Strong hands-on 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 Kimball's dimensional modeling (star/snowflake schemas)
• Experience transforming and un-nesting complex, semi-structured data sources, particularly nested JSON
• Proficiency in Python for scripting data quality tests, automation, and light API interactions
• 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, CI/CD, 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 non-technical audiences
• Experience with data ingestion tools like Fivetran and event tracking platforms like Fullstory or Amplitude
• A proactive, product-oriented mindset with a passion for building trustworthy data solutions that have a measurable business impact

Responsibilities

• Data Modeling and Transformation: Take ownership of the transformation layer in our data stack, developing, testing, and deploying robust, scalable, and well-documented 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, data-informed decision-making 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 CI/CD 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
• End-to-End 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 you've 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 self-service; you will often conduct the initial deep-dive 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 end-to-end, 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 go-to expert for that data
• Proactively identify opportunities to improve data model performance, simplify logic, and increase the business impact of our analytics platform

Preferred Qualifications

Familiarity with deploying scripts on AWS Lambda is a plus

Benefits

• 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 company-wide 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 co-working space and/or 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!