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. About Solomon Page Founded in 1990, Solomon Page is a specialty niche provider of staffing and executive search solutions across a wide array of functions and industries. The success of Solomon Page reflects an organic growth strategy supported by a highly entrepreneurial culture. Acting as a strategic partner to our clients and candidates, we focus on providing customized solutions and building long-term relationships based on trust, respect, and the consistent delivery of excellent results. For more information and additional opportunities, visit: solomonpage.com and connect with us on Facebook, and LinkedIn. Opportunity Awaits.