Data Engineer II
Job Description
Ignite Insurance Systems (Verisk Claims Solutions division) is hiring a Data/DataOps Engineer II in Jersey City, NJ (hybrid) to build and operate cloud data pipelines and data platform capabilities.
Responsibilities
- Design and develop data pipelines using cloud serverless or container-based services (managed functions, batch compute, container orchestration, workflow/orchestration frameworks) alongside cloud data warehousing platforms.
- Design, review, and build dimensional and Kimball-style data models for data products and BI reporting systems.
- Build and maintain CI/CD pipelines and deployment automation for data pipelines and infrastructure using version-controlled, repeatable release practices.
- Support access provisioning and lifecycle management, including role-based permissions and audit/compliance controls aligned to security and governance standards.
- Build and consume REST APIs and integrate with web services or gateways to enable pipeline and platform automation.
- Collaborate with product owners to understand and refine new feature requests.
- Partner with the data engineering team to design, review, and develop new data pipelines.
- Ensure standard practices for logging, monitoring, alerting, incident response, and data security across the platform.
- Understand Verisk data security policies and controls, and implement approaches to comply.
- Contribute to design and code reviews, address technical problems, and help define best practices.
- Create solutions to meet the evolving needs of internal and external customers.
Requirements
- BS or MS degree in Computer Science, Information Technology, or a related field.
- 2+ years designing and developing cloud data pipelines (ETL/ELT solutions).
- 2+ years of Data Warehousing experience.
- Proficiency writing SQL for aggregating and transforming data in a pipeline.
- Experience using Python for automation, API work, and/or data transformation.
- Working knowledge of dimensional/data modeling methods that support BI tools.
- Experience building pipelines with a variety of sources including RDBMs, NoSQL, REST APIs, message queues, and files.
- Experience working 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 plus security and governance/audit operations on a data platform.
- Curious, inquisitive mindset with the ability to learn quickly and troubleshoot ambiguous issues.
- Working knowledge of development standards and best practices using established design patterns.
- Proficiency with Git (version control systems).
- 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.
Technologies
- Cloud serverless/container services, managed functions, batch compute, container orchestration, workflow/orchestration frameworks
- Cloud data warehousing platforms
- Dimensional/Kimball style data models
- CI/CD pipelines
- REST APIs, web services/gateways
- SQL, Python
- RDBMs, NoSQL, message queues
- Snowflake
- Infrastructure-as-code
- GIT
- Database modeling tools (e.g., SqlDBM)