Data Engineer

Join Hutech Solutions – Innovate, Lead, and Transform!We are a global AI-driven software services and product engineering powerhouse, founded and led byvisionary technology leaders from Walmart. We are redefining the future of technology by buildingnext-gen solutions that empower businesses across Banking, Finance, eCommerce, and Logisticsindustries.At Hutech, we don’t just build software—we create impact. Our culture fosters innovation, creativity,and continuous learning, enabling our team to push boundaries and solve real-world challenges usingcutting-edge AI tools and techniques.Position SummaryWe are looking for a skilled Data Engineer with strong expertise in Amazon Redshift, advanced SQL,and data modelling to design, build, and optimize scalable data platforms on AWS. The idealcandidate will play a key role in developing reliable data pipelines, enforcing data quality standards,and enabling analytics and reporting across the organization.Key Responsibilities● Design, build, and optimize data models (fact/dimension, star/snowflake schemas) with astrong focus on performance and scalability.● Develop and maintain complex SQL queries in Amazon Redshift for analytics, reporting, anddownstream consumption.● Optimize Redshift performance using distribution styles, sort keys, query tuning, and workloadmanagement (WLM).● Build and orchestrate scalable data pipelines using AWS Glue, Amazon EMR, Apache Spark,and Airflow.● Implement data quality checks, validation rules, and monitoring frameworks to ensureaccuracy and consistency.● Work closely with analytics, BI, and business teams to translate requirements into robust datasolutions.● Manage and optimize data storage and movement using Amazon S3.● Ensure best practices in data security, governance, and documentation.● Troubleshoot data issues and provide root-cause analysis and long-term fixes.Required Qualifications● Bachelor’s degree in Computer Science, Engineering, or a related field● 3–5 years of hands-on experience in data engineering● Strong advanced SQL skills (mandatory) with deep experience in Amazon Redshift● Proven expertise in data modeling for analytical workloads● Strong understanding of AWS data services, including: Amazon Redshift, AWS Glue, AmazonS3, Amazon EMR● Experience with data pipeline and workflow orchestration tools such as Apache Airflow● Hands-on experience with Apache Spark● Proficiency in at least one programming/scripting language such as Python, Java, or Scala● Solid understanding of data quality, validation, and best practicesNice to have● Experience designing large-scale analytics and reporting platforms● Familiarity with BI tools and downstream analytics use cases● Experience with cost optimization and performance tuning on AWS● Exposure to CI/CD for data pipelinesKey Skills● Amazon Redshift (SQL – Advanced)● Data Modeling (Analytics-focused)● AWS (S3, Glue, EMR)● Apache Airflow● Apache Spark● Python / Java / Scala● Data Quality & Optimization