Data Engineer, Security

<div class="content-intro"><h4><span style="color: rgb(0, 0, 0);">About us</span></h4> <p>Coalition is the world's first Active Insurance provider designed to help prevent digital risk before it strikes. Founded in 2017, Coalition combines comprehensive insurance coverage and innovative cybersecurity tools to help businesses manage and mitigate potential cyberattacks. </p> <p>Opportunities to make an impact with bold thinking are real—and happening daily at Coalition.</p></div><h4><span style="color: rgb(0, 0, 0);">About the role</span></h4> <p>We are hiring a Data Engineer to build our data platform across our Cyber Security value chain. This includes Security and Sales management. You will be the go-to partner for Stakeholders, Research team and Data Science team requiring Cyber Security related Data.</p> <p>As a Data Engineer, you will design and develop our data lifecycle, transforming raw data into high-performance data products. You will build and scale our Medallion Architecture on Snowflake, utilizing dbt to ensure our data is clean, modeled, and ready for both business intelligence in Looker and advanced AI/ML applications.</p> <h4><span style="color: rgb(0, 0, 0);">Responsibilities</span></h4> <ul> <li><strong>Data Modeling Architecture:</strong> Design and implement robust Star Schema models within a Medallion Architecture (Bronze/Silver/Gold) to support complex Cyber Insurance and Cyber Security analytics .</li> <li><strong>Pipeline Engineering:</strong> Build scalable ELT pipelines using Snowflake and dbt, ensuring high data quality and observability .</li> <li><strong>Monitoring Observability:</strong> Define and implement critical SLIs—specifically around data freshness, volume, and schema integrity. Build automated alerting to ensure SLOs are met .</li> <li><strong>BI Enablement:</strong> Develop and maintain the LookML semantic layer for business stakeholders .</li> <li><strong>Security Compliance:</strong> Implement data masking, RBAC, and secure data handling practices .</li> <li><strong>Engineering Excellence Mentorship:</strong> Act as a technical peer helping the team level up through Code Reviews and sharing dbt/Python best practices </li> <li><strong>AI Integration:</strong> Build feature stores and data foundations for AI-driven risk scoring and automated underwriting.</li> </ul> <h4><span style="color: rgb(0, 0, 0);">Skills and Qualifications</span></h4> <ul> <li><strong>BI Tools: </strong>Experience with Looker (LookML) .</li> <li><strong>Modern Tooling:</strong> Active user of Cursor or other AI-assisted coding environments .</li> <li><strong>Industry Experience: </strong>Prior experience in Cybersecurity or Cyber Insurance .</li> <li><strong>AI/ML Interest:</strong> Experience building data foundations for AI Agents.</li> </ul> <h4><span style="color: rgb(0, 0, 0);">Compensation</span></h4> <p><span style="color: rgb(0, 0, 0);">Our compensation reflects the cost of labor across several US geographic markets. The US base salary for this position ranges from $115,900.00/year in our lowest geographic market up to $155,250.00/year in our highest geographic market. Consistent with applicable laws, an employee's pay within this range is based on a number of factors, which include but are not limited to relevant education, skills, job-related knowledge, qualifications, work experience, credentials, and/or geographic location. Your recruiter can share more on target salary for your location during the interview process. Coalition, Inc. reserves the right to modify this range as needed.</span></p> <h4><span style="color: rgb(0, 0, 0);">Perks</span></h4> <ul> <li><span style="color: rgb(0, 0, 0);">100% medical, dental and vision coverage</span></li> <li><span style="color: rgb(0, 0, 0);">Flexible PTO policy</span></li> <li><span style="color: rgb(0, 0, 0);">Annual home office stipend and WeWork access</span></li> <li><span style="color: rgb(0, 0, 0);">Mental physical health wellness programs (One Medical, He ... (truncated, view full listing at source)