Data Engineer II
Job Description
Ignite Insurance Systems is hiring a Data Engineer II in Jersey City, NJ (hybrid) to build and operate cloud data pipelines and data platform capabilities for data products and reporting.
Responsibilities
- Design and develop cloud-based data pipelines using serverless and container technologies (managed functions, batch compute, container orchestration, workflow/orchestration frameworks) alongside cloud data warehousing platforms.
- Design, review, and deliver dimensional (Kimball-style) data models for business intelligence reporting and downstream data products.
- Build and maintain CI/CD pipelines and deployment automation for data pipelines and infrastructure using version-controlled, repeatable release practices.
- Support data platform access provisioning and lifecycle management, including role-based permissions and audit/compliance controls aligned with security and governance standards.
- Build and consume REST APIs to integrate with web services and gateways as part of pipeline and platform automation.
- Collaborate with product owners to understand, refine, and iterate on feature requests.
- Partner with the data engineering team to design, review, and develop new data pipelines.
- Follow standards for logging, monitoring, alerting, incident response, and data security.
- Understand Verisk data security policies and controls, and implement approaches that comply with those requirements.
- Contribute to design and code reviews, help define best practices, and solve technical problems.
- Create solutions that support internal and external customer needs.
Requirements
- BS or MS degree in Computer Science, Information Technology, or related field.
- 2+ years experience designing and developing cloud data pipelines (ETL/ELT).
- 2+ years data warehousing experience.
- Proficiency writing SQL for aggregating and transforming data within a pipeline.
- Experience using Python for automation, API work, and/or data transformation.
- Working knowledge of dimensional/data modeling methods for business intelligence tools.
- Experience building pipelines across multiple source types, including RDBMs, NoSQL, REST APIs, message queues, and files.
- Experience with a cloud data warehouse platform (e.g., Snowflake or equivalent).
- Experience with cloud serverless/container technologies (functions-as-a-service, managed batch compute, container orchestration) and workflow orchestration frameworks.
- Working knowledge of DevOps fundamentals and CI/CD practices, including build/release pipelines, infrastructure-as-code, and automated deployments.
- Experience with access management, security, and governance/audit operations on a data platform.
- Curious, inquisitive mindset with the ability to learn new technologies quickly and troubleshoot ambiguous issues.
- Working knowledge of development standards and best practices, with the ability to follow established design patterns.
- Proficiency with Git.
- Proficiency with database modeling tools (e.g., SqlDBM).
- Plus: Experience with REST APIs, API gateways, or other web integration technologies.
- Plus: Experience working with tokenized PII.
- Plus: Insurance industry experience.
Key Technologies
- Cloud serverless/container services: managed functions, batch compute, container orchestration, workflow/orchestration frameworks
- Cloud data warehousing platforms
- Dimensional/Kimball style data models; dimensional/data modeling methods
- CI/CD pipelines, REST APIs, web services/gateways
- SQL, Python
- Data sources: RDBMs, NoSQL, message queues, files
- Snowflake (or equivalent)
- Infrastructure-as-code, version control systems (Git)
- Database modeling tools (SqlDBM, etc.)