Remote Python Data Engineer

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.


Responsibilities:
- 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 View email address on click.appcast.io learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:


Required Skills & Experience

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


Nice to Have Skills & Experience

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)


Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.