Datawarehouse Engineer with Redshift

Job Title: Datawarehouse engineer with Redshift Location: Alpharetta OR Cincinnati (Hybrid) Job Type: 12 months+ Job Summary: • We are looking for a skilled Data Warehouse Engineer with deep expertise in Amazon Redshift to design, build, and manage scalable data warehousing solutions. This role is critical for ensuring efficient data availability and performance for reporting, analytics, and business decision-making. Key Responsibilities: • Design, develop, and maintain scalable and high-performance data warehouse solutions on Amazon Redshift. • Create and optimize complex SQL queries and stored procedures for ETL/ELT processes. • Collaborate with data engineers, analysts, and stakeholders to understand data requirements and implement efficient data models. • Implement data partitioning, distribution styles, and performance tuning techniques in Redshift. • Integrate data from various sources including S3, RDS, APIs, and third-party applications. • Ensure data quality, consistency, and integrity across data sources and pipelines. • Monitor and troubleshoot data loads, query performance, and system health. • Maintain and document data architecture, data flows, and technical standards. Required Qualifications: • 3+ years of experience in data engineering or data warehousing roles. • Strong hands-on experience with Amazon Redshift, including query optimization and performance tuning. • Proficient in SQL, with the ability to write complex queries and debug performance issues. • Experience with ETL/ELT tools (e.g., AWS Glue, Apache Airflow, dbt, Matillion). • Familiarity with data modeling concepts (star/snowflake schemas, normalization/denormalization). • Knowledge of data integration from diverse sources (flat files, APIs, databases). • Experience with AWS ecosystem – especially S3, Lambda, IAM, CloudWatch, and Athena. • Understanding of security and compliance best practices for data handling. Preferred Qualifications: • Experience with Python or Scala for data transformation and orchestration. • Experience with dbt (data build tool) for modeling in Redshift. • AWS Certification (e.g., Data Analytics – Specialty or Solutions Architect – Associate). • Familiarity with CI/CD practices for data pipelines. • Exposure to BI tools such as Tableau, Power BI, or QuickSight.