Senior Data Engineer (AWS Redshift)

• Design, develop, and maintain scalable data pipelines using AWS Redshift, SQL, Python, and AWS data services.
• Build and optimize ETL/ELT processes to ingest, transform, and publish data for downstream applications.
• Develop efficient SQL queries, stored procedures, views, and data models within Redshift.
• Optimize Redshift performance, including query tuning, workload management, and data storage efficiency.
• Work with the SEED platform team to understand existing data architecture, standards, and governance requirements.
• Support pricing, customer, product, sales, and transaction data requirements for the PGS application.
• Enable reliable data integration between Redshift, APIs, Salesforce, and other consuming applications.
• Troubleshoot data quality issues, pipeline failures, data latency, and performance bottlenecks.
• Collaborate with business, application development, analytics, and AI teams to deliver new data requirements.
• Support data preparation for Next Best Actions, customer insights, pricing recommendations, and AI-driven use cases.
• Follow Sysco’s security, access management, data governance, and deployment standards.

• 10 years of experience in data engineering, with strong hands-on experience in AWS Redshift.
• Advanced SQL skills, including complex queries, joins, window functions, CTEs, and query optimization.
• Strong Python programming experience for data processing and automation.
• Experience developing ETL/ELT pipelines using AWS Glue, AWS Lambda, or equivalent tools.
• Working knowledge of AWS S3, IAM, CloudWatch, and data integration services.
• Experience with data warehousing, dimensional modeling, and large-scale data processing.
• Experience troubleshooting data pipelines, performance issues, and production data failures.
• Familiarity with Git, CI/CD, and enterprise data engineering practices.
• Strong communication skills and ability to coordinate with multiple application and platform teams.
• B.S degree in Computer Engineering or Computer Science or a related field.

Preferred Skills

• Experience integrating AWS Redshift data with Salesforce applications.
• Understanding of pricing, sales analytics, customer insights, or retail/distribution business processes.
• Experience building datasets for AI/ML applications and recommendation engines.
• Familiarity with AWS Step Functions, Airflow, dbt, or other orchestration and transformation frameworks.
• Experience working within enterprise data platforms with centralized governance and shared services.