Hybrid Data Engineer II — Automate & Elevate Data Workflows

American Medical Association; Chicago (IL); Hybrid; USD 85,000 - 113,000; Full time

Job summary

American Medical Association in Chicago, IL is hiring a Data Engineer II (Hybrid) to build data pipelines, automate file-based workflows, and support reporting needs for AMA Insurance.

The role focuses on data ingestion, transformation, and validation of structured and semi-structured data, using Snowflake, SQL Server, and scripting in PowerShell and Python. The position requires 3 days in the office weekly.

Qualifications

• Strong experience with SQL Server for complex queries and data updates.
• Hands-on experience loading, staging, and extracting data with Snowflake.
• Proficient in PowerShell scripting for automation and system integrations.
• Proficient in Python scripting for automation and data handling.
• Experience with FTP servers and external system integrations.
• Solid understanding of data quality, validation, and transformation.

Responsibilities

• Data Preparation and Management: process, clean, and transform Excel/CSV files for claims and administration data; identify duplicates and quality issues; load and transform data in Snowflake; run manual and scheduled Snowflake jobs; generate outbound CSV outputs.
• PowerShell Automation: develop and maintain PowerShell scripts; automate file transfers, FTP interactions, and notifications; build automation to improve efficiency.
• SQL Server Development and Python Scripting: write and optimize SQL queries; update backend tables; prepare datasets for analytics; develop Python scripts for file-based automation and end-to-end workflow automation.
• Other responsibilities as assigned.

Skills

SQL Server

Snowflake

PowerShell

Python

FTP

Data quality

Interpersonal skills

Project multitasking

Tools

Snowflake

Job description

American Medical Association in Chicago, IL is hiring a Data Engineer II (Hybrid) to build data pipelines, automate file-based workflows, and support reporting needs for AMA Insurance.

The role focuses on data ingestion, transformation, and validation of structured and semi-structured data, using Snowflake, SQL Server, and scripting in PowerShell and Python. The position requires 3 days in the office weekly.