Software Engineer IV - (Contract Data Engineer)

Description: Software Engineer (data) bout the Role We are seeking a Contract Data Engineer to support a critical data migration initiative. The engineer will be responsible for analyzing large HDM (Hierarchical Data Models) tables, understanding their logic/code, and converting them into production-ready Data Warehouse (DW) tables. The primary objective is to decommission HDMs from our environment and ensure smooth integration into our enterprise DW platform. Scope of Work & Responsibilities Review and analyze existing HDM tables and associated transformation logic.Re-engineer HDM structures into optimized Data Warehouse tables.Design and build automated ETL/ELT data pipelines for production.Document transformation processes to ensure transparency and knowledge transfer.Collaborate with data architects and stakeholders to validate business requirements.Ensure high data quality, consistency, and performance in migrated datasets. Required Skills & Experience Proven experience as a Data Engineer (3-5+ years).Strong SQL expertise with experience in handling large, complex data sets.Hands-on experience with Data Warehousing platforms (Snowflake, Redshift, BigQuery, Teradata, or equivalent).Proficiency in ETL/ELT tools (Informatica, dbt, Airflow, Talend, etc.).Strong programming skills in Python/Scala/Java for data processing.Experience building or contributing to REST APIsStrong hands-on experience with SQL and relational databases; familiarity with NoSQL databases is a plusPractical experience building, maintaining, or supporting data pipelines, ETL workflows, batch processing, or event-driven systemsExperience working with backend data flows, data transformation, and integration between services and data platformsFamiliarity with distributed systems or asynchronous/event-driven architectures is a plusSolid understanding of data modeling concepts (star schema, dimensional modeling, normalization). Nice to Have: Prior experience with HDM systems and migration to modern DW.Cloud platform knowledge (AWS/GCP/Azure).Experience in documenting and handing off data migration projects.