About the Role
Seeking a Data Engineer to support a critical data migration initiative. The engineer will analyze large HDM (Hierarchical Data Models) tables, understand their logic/code, and convert them into production-ready Data Warehouse (DW) tables with the primary objective of decommissioning HDMs and ensuring smooth integration into the enterprise DW platform.
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.
Requirements
- 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 APIs
- Strong hands-on experience with SQL and relational databases; familiarity with NoSQL databases is a plus
- Practical experience building, maintaining, or supporting data pipelines, ETL workflows, batch processing, or event-driven systems
- Experience working with backend data flows, data transformation, and integration between services and data platforms
- Familiarity with distributed systems or asynchronous/event-driven architectures is a plus
- Solid understanding of data modeling concepts (star schema, dimensional modeling, normalization).
Skills
- SQL
- HDM (Hierarchical Data Models)
- Python
- ETL/ELT tools
- Informatica
- dbt
- Airflow
- Talend
- Scala
- Java
- REST APIs
- NoSQL databases
- Data Warehousing platforms
- Snowflake
- Redshift
- BigQuery
- Teradata
- distributed systems
- asynchronous/event-driven architectures
- data modeling concepts
- star schema
- dimensional modeling
- normalization
Location
- Austin, TX
Work Type
- Contract
- Hybrid
Experience Level
- 3-5+ years
Salary/Compensations
- $70.00 - $72.00/hr
Benefits
- Medical, dental & vision
- Critical Illness, Accident, and Hospital
- 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
- Life Insurance (Voluntary Life & AD&D for the employee and dependents)
- Short and long-term disability
- Health Spending Account (HSA)
- Transportation benefits
- Employee Assistance Program
- Time Off/Leave (PTO, Vacation or Sick Leave)
About the Company
- We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
- We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
Equal Opportunity
- The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
- The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
