Senior Data Engineer

Job Title: Senior Data Engineer Location: USA (Remote) Pay Rate: $70-$80 an hour.. 6 Month Contract We are seeking experienced Data Engineers to join a fast-paced, data modernization initiative at a growing technology company. The team is migrating legacy pipelines from Informatica Cloud (IICS) to a modern ELT stack using dbt and Airflow on Amazon Redshift, with source data in S3. This is a hands-on role requiring both technical expertise and the ability to work independently after an initial ramp-up period. What You’ll Do: • Migrate Informatica Cloud TaskFlows to dbt (SQL/Jinja) models and Airflow DAGs targeting Redshift. • Reverse engineer Informatica logic by exporting JSON/XML TaskFlow metadata and translating transformations to dbt; leverage AI/LLM-assisted techniques to accelerate reverse engineering and documentation where appropriate. • Deliver to an expected weekly cadence, ramping from paired programming onboarding to mostly independent migration of multiple TaskFlows per week. • Harden pipelines with data quality checks, idempotent re-runs, logging, and clear rollback/repair procedures aligned to Data Ops best practices. • Document lineage, business rules, and model semantics to support downstream analytics and maintain long-term maintainability. Required Qualifications: • 5+ years hands-on experience with Informatica Cloud (IICS), including exporting/interpreting JSON/XML artifacts. • Advanced SQL (preferably Redshift dialect) and Python for ELT utilities and Airflow operators. • 3+ years building and operating Airflow and dbt in production. • Experience with AWS services such as S3, Redshift, IAM, and Lambda. • Strong grasp of dimensional modeling and ability to translate complex business rules into warehouse models. • Practical experience using AI/LLMs to accelerate reverse engineering and documentation (prompt crafting and validation). Preferred Attributes: • Ability to work full-time hours aligned with Central Time (U.S.). • Comfortable operating independently in a high-velocity environment. • Strong problem-solving skills and attention to detail in ETL and data pipeline design. This is a remote U.S.-based opportunity with immediate start. Successful contractors who demonstrate high delivery velocity may have opportunities for longer-term engagement or conversion to full-time roles.