Remote Python Data Engineer

Job Description

We are hiring Python engineers to support a high-urgency data migration program as part of a recent acquisition. This role is focused on data transformation jobs—extracting flat data from Snowflake, transforming it into nested JSON, and persisting it into DB2 (often as CLOBs) for downstream Java ingestion. This is a Linux, bare-metal, backend-only environment. You will build transformation jobs largely from scratch and operate with minimal supervision under tight delivery milestones.

The contract will be short-term through the end of October or sooner. It can sit remotely working EST or CST.

• Develop and support Python (3.12.11) ETL/transformation jobs running on Linux
• Extract flat datasets from Snowflake and transform them into nested JSON objects
• Insert transformed payloads into DB2 (including writing to CLOB columns where required)
• Write and execute DB2 SQL (queries, inserts, validations)
• Implement file mapping/entity mapping logic (e.g., company, user, access-right structures)
• Validate transformations, handle data exceptions, and support batch-style processing
• Collaborate with backend Java teams consuming DB2 outputs into entitlement services/tables

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances.

If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to  To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

• 5+ years Python for ETL / strong data transformation (not app dev)
• Hands‑on experience transforming flat relational data into complex nested JSON structures
• DB2 & Oracle
• SQL
• Snowflake (querying, extracting datasets)
• Experience working in Linux environments
• Basic conceptual knowledge of LDAP and JWT (awareness only; not implementing auth)
• Identity / entitlements exposure
• Payments knowledge - ACH / wires / templates
• Application Performance Monitoring / Logging software (Dynatrace /Splunk)