Data Engineer

We are seeking a skilled Data Engineer to support a critical enterprise data migration initiative. This role will focus on analyzing existing Hierarchical Data Models (HDM), understanding complex transformation logic, and converting them into scalable, production-ready Data Warehouse (DW) solutions. The ideal candidate will have strong expertise in data engineering, ETL/ELT development, data warehousing, and backend data processing, with the ability to work closely with architects and business stakeholders to ensure successful migration and modernization of enterprise data assets.

• Job Title: Data Engineer
• Location: Austin, TX (Hybrid)
• Contract Duration: Through End of Year (Possible Extension)
• Rate Range: $55-$70/hr on W2
• Only W2 Candidates, NO C2C

Responsibilities:

• Analyze existing HDM tables and associated transformation logic.

• Re-engineer HDM structures into optimized and scalable Data Warehouse tables.

• Design, develop, and maintain automated ETL/ELT pipelines for production environments.

• Build and support backend data processing workflows, integrations, and transformation pipelines.

• Develop and contribute to REST APIs supporting data services and integrations.

• Collaborate with Data Architects, Product Teams, and Business Stakeholders to validate requirements and ensure successful implementation.

• Ensure high data quality, consistency, scalability, and performance across migrated datasets.

• Create detailed technical documentation and support knowledge transfer activities.

• Support data migration efforts from legacy systems to modern enterprise data platforms.

Required Qualifications:

• 3–5+ years of experience as a Data Engineer.

• Strong expertise in SQL with experience working on large-scale and complex datasets.

• Hands-on experience with modern Data Warehouse platforms such as Snowflake, Redshift, BigQuery, Teradata, or equivalent.

• Experience with ETL/ELT tools including DBT, Airflow, Informatica, Talend, or similar technologies.

• Strong programming skills in Python, Scala, or Java for data processing and automation.

• Experience building or contributing to REST APIs.

• Strong understanding of relational databases and SQL optimization techniques.

• Experience with backend data flows, ETL workflows, batch processing, and event-driven architectures.

• Knowledge of data modeling concepts including Star Schema, Dimensional Modeling, and Normalization.

• Strong analytical, troubleshooting, and problem-solving skills.

• Excellent communication and stakeholder collaboration abilities.

Required Skills:

• Data Engineering

• SQL

• Data Warehousing

• ETL / ELT Development

• Python / Scala / Java

• REST APIs

• Data Modeling

• Data Migration

• Data Integration

• Batch Processing

• Event-Driven Architectures

Technical Skills:

• Snowflake

• Redshift

• BigQuery

• Teradata

• DBT

• Apache Airflow

• Informatica

• Talend

• Python

• Scala

• Java

• SQL

• Relational Databases

• NoSQL Databases

• REST APIs

Preferred Qualifications:

• Experience working with HDM systems and migrations to modern Data Warehouse platforms.

• Knowledge of cloud platforms including AWS, Azure, or GCP.

• Experience documenting and handing off large-scale data migration projects.

• Familiarity with distributed systems and asynchronous/event-driven architectures.

If you meet the required qualifications and are interested in this role, please apply today. The Solomon Page Distinction Solomon Page offers a comprehensive benefit program for hourly employees. We pride ourselves on offering medical, dental, 401(k), direct deposit and commuter benefits to our employees, including freelancers - which sets us apart in the industries we serve.