Note: The job is a remote job and is open to candidates in USA. Ikon Search is recruiting for a specialty insurance organization with a lean, high-impact technology team. The Senior Data Engineer will own data ingestion infrastructure, pipelines, orchestration, monitoring, and data quality across insurance and business systems, while delivering reliable data for analytics and reporting. The role also involves troubleshooting integrations, improving platform reliability, and supporting data architecture and AI/ML enablement.
Responsibilities
- Design, build, maintain, and own data pipelines ingesting information from carrier feeds, policy and claims systems, third-party platforms, and other sources
- Own pipeline orchestration and scheduling, ensuring jobs run reliably, in the correct sequence, and recover appropriately from failures
- Deliver clean, structured raw and staged data for downstream analytics and transformation
- Build and maintain extraction and delivery pipelines supporting recurring carrier and regulatory reporting, including bordereaux reporting
- Implement data-quality controls including validation, reconciliation, monitoring, testing, and automated alerting
- Identify data-feed issues before they impact reporting or business users
- Support integrations between the cloud data warehouse, Salesforce, and other business applications
- Independently troubleshoot and resolve pipeline, ingestion, and synchronization failures
- Improve pipeline reliability, scalability, observability, and performance
- Maintain thorough technical documentation covering pipelines, dependencies, processes, and recovery procedures
- Partner with Analytics Engineering, business stakeholders, and technology leadership on improvements to the broader data platform
- Develop a strong understanding of the organization's data ecosystem
- Take ownership of critical and fragile pipelines
- Improve monitoring and reduce recurring pipeline failures
- Ensure failures are identified and addressed before impacting business users
- Own ingestion and orchestration processes end to end
- Establish reliable carrier, bordereaux, and reporting pipelines
- Consistently provide clean and dependable staged data to the analytics engineering function
- Eliminate major single points of failure within the data-ingestion environment
- Establish proactive monitoring and data-quality processes
- Improve documentation, reliability, and scalability across the data platform
- Contribute to the future direction of the organization's data architecture and AI capabilities
Skills
- 5+ years of data engineering experience or closely related experience
- Strong proficiency with SQL and Python
- Hands-on experience with a cloud data warehouse such as Snowflake, BigQuery, Redshift, or similar
- Experience building and maintaining production data ingestion and ELT pipelines using tools such as Fivetran, Airbyte, or equivalent technologies
- Experience with data orchestration platforms such as Airflow, Dagster, Prefect, dbt Cloud Jobs, or similar
- Strong understanding of relational databases such as SQL Server, Azure SQL, or comparable platforms
- Demonstrated experience owning data pipelines throughout their lifecycle, including development, deployment, monitoring, troubleshooting, and production support
- Strong problem-solving skills and the ability to independently investigate unfamiliar technologies or data issues
- Ability to work effectively in a lean environment where ownership and accountability are important
- Insurance, MGA, financial services, or other regulated-industry data experience
- Experience with bordereaux, carrier reporting, or regulatory reporting
- Exposure to insurance platforms such as Insurity, Sure, or similar policy/claims systems
- Salesforce data integration experience
- Experience within the Microsoft Azure data ecosystem
- Working knowledge of dbt and modern analytics engineering practices
- Exposure to AI/ML or LLM-based technologies and tooling
- Familiarity with data governance, cybersecurity, or regulatory frameworks such as NY DFS 23 NYCRR Part 500
Company Overview