Merastar Insurance CompanyHiring

Senior Data Engineer

  • Chicago, IL
  • Senior
  • Posted 3 weeks ago
In one line

Senior data engineering role guiding an enterprise data platform built on Snowflake and AWS, with mentoring and architecture work; hybrid across several US sites.

About the role

Suits an engineer who can set standards and still get into the pipelines, balancing delivery across several initiatives with production reliability. Data models, governance and cost control all sit with this role.

At a glance

Pay
Not stated in the posting
Location
Chicago, IL
Seniority
Senior
Skills
Snowflake, AWS, Data Vault 2.0, Python, Spark, Informatica, AWS Glue, CloudWatch
Posted
26 Oct 2026
Last checked
16 Nov 2026

What you will do

  • Set technical direction for data engineers, covering solution design, coding standards, data governance and quality
  • Define the enterprise data architecture around Snowflake, Data Vault 2.0 and event-driven ELT frameworks
  • Architect and oversee pipelines and transformations using Snowflake, Python, Spark, Informatica, AWS Glue and cloud tools
  • Lead root-cause analysis for production issues and put long-term fixes in place

What they look for

  • Deep experience with Snowflake, including Snowpipe, Streams, Tasks, Dynamic Tables and warehouse tuning
  • Strong knowledge of core AWS services and cloud-based architecture
  • Experience with Data Vault 2.0 modelling and dimensional models
  • Python, Spark and Informatica skills for ingestion and transformation work
  • A record of mentoring engineers and running architecture and code reviews

How Keywordise applies for you

  1. 1Upload your CVAdd your CV once. It takes about a minute.
  2. 2Tailored to this jobKeywordise writes a CV and a cover letter for this job from your real experience.
  3. 3The form fills itselfName, email, experience and screening questions, field by field.
  4. 4Application sentYou get a receipt and follow it in your dashboard.

Apply with Keywordise AI7-day free trial, no card.

Apply from your AI assistant

Connect Keywordise to your assistant once, then send it the prompt. It applies for you.

Claude

  1. In Claude, open Settings, then Connectors, and choose Add custom connector.
  2. Name it Keywordise and paste the connector URL.
  3. Click Connect, log in to Keywordise and approve. Then send the prompt in a new chat.
Connector URL
https://keywordise.com/mcp

Disconnect any time in your Keywordise settings.

ChatGPT

  1. In ChatGPT, open Settings, then Connectors. On plans that need it, turn on developer mode first.
  2. Add a new connector with the connector URL and choose OAuth. Leave the client ID and secret empty.
  3. Log in to Keywordise and approve. Then send the prompt in a new chat.
Connector URL
https://keywordise.com/mcp

Disconnect any time in your Keywordise settings.

Muse

  1. Open Muse (muse.ai or the app) and send it the message below.
  2. If Muse asks how to sign in, answer OAuth. Open the sign-in link it sends, log in to Keywordise and approve.
  3. Send the prompt. Muse asks before it sends anything.
Message for Muse
Add a custom connector called Keywordise. It is a remote MCP server at https://keywordise.com/mcp and uses OAuth. Give me the sign-in link.

Muse is available in the US only for now.

Prompt
Apply to Keywordise job geyl3jh5d7
How to connect

Questions about this job

Where is this job based?

The posting lists Senior Data Engineer as a role based in Chicago, IL, United States.

What does this job pay?

The posting does not state a salary, so there is no figure to quote.

What experience is needed?

It is a senior role. The posting asks for: deep experience with Snowflake, including Snowpipe, Streams, Tasks, Dynamic Tables and warehouse tuning; strong knowledge of core AWS services and cloud-based architecture; experience with Data Vault 2.0 modelling and dimensional models. Skills it names include Snowflake, AWS, Data Vault 2.0, Python.

How do I apply with Keywordise AI?

Select Apply with Keywordise AI, sign up and upload your CV. Keywordise writes a CV and a cover letter for this job from your real experience and applies for you. The 7-day free trial needs no card.

More IT and software jobs in Chicago, IL

All IT and software jobs in Chicago, IL
Merastar Insurance CompanyChicago, IL
Apply with Keywordise AI