Data Engineer

Stellar Consulting Solutions is a boutique business & technology consulting company headquartered in Atlanta, GA. We deliver high quality, agile, and experienced workforce for niche technology projects of any scale. We help forward thinking clients to solve specific problems by understanding their needs and align talent that can move fluidly to match skill supply and demand on a real-time basis. Stellar Consulting has a unique combination of technical and digital skills to recruit, engage, and retain qualified talent. We have a stellar reputation for striving to achieve high ethical standards. Our use of Innovative techniques and industry best practices has made us one of the fastest growing boutique firms delivering to enterprise business.

Job Title:

Data Engineer Location:

Austin, TX (Hybrid) About 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 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 asynchronoevent-driven architectures is a plus Solid 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/Google Cloud Platform/Azure). Experience in documenting and handing off data migration projects.