Senior AWS Data Engineer

eBusiness Technologies Corp.; Town of Texas (WI); On-site; USD 120,000 - 180,000; Full time

Job summary

eBusiness Technologies Corp. is seeking an AWS Data Engineer with 5+ years of ETL development experience to modernize legacy data ecosystems and design large-scale data pipelines on AWS.

You will leverage AWS Glue, PySpark, Lambda, and event-driven ingestion to build scalable, cost-efficient cloud data platforms. The role emphasizes strong SQL and Redshift internals, including WLM, distribution keys, and federated queries, along with IAM security and data governance across multi-account

Qualifications

• 5+ years of data engineering experience with ETL development.
• Experience modernizing legacy data ecosystems (Mainframe, SQL Server, flat files, XML/CSV).
• Ability to design and orchestrate large-scale data pipelines on AWS.
• Strong SQL skills and expertise in query optimization for high-volume data.
• Hands-on Redshift internals knowledge including WLM, distribution keys and federated queries.
• Security-minded with AWS IAM and data governance in multi-account environments.
• Proficiency in Python-based ETL frameworks and CI/CD automation for data pipelines.
• Familiarity with AI/ML services (Bedrock) for embedded analytics is a plus.

Responsibilities

• Design and orchestrate large-scale data pipelines on AWS.
• Migrate and modernize legacy data ecosystems to Redshift data warehouse.
• Implement secure, cost-optimized cloud-native data platforms.
• Develop modular ETL pipelines with CI/CD for automated deployments.
• Leverage AI/ML services to add predictive analytics capabilities.

Skills

AWS Glue

PySpark/Python

Lambda

Event-driven ingestion

SQL (window functions, CTEs)

Redshift internals

WLM & distribution/sort keys

Spectrum integration

Federated queries

AWS IAM security

Data governance

Python-based pipeline frameworks

CI/CD for data pipelines

AWS Bedrock / AI/ML services

Cloud-native data platforms

Tools

AWS Glue

Redshift

Lambda

Spectrum

Job description

• Seeking an AWS Data Engineer (5+ years) with strong ETL development expertise and experience in modernizing legacy data ecosystems (Mainframe, SQL Server, flat files, XML/CSV).
• Proven ability to design and orchestrate large-scale data pipelines leveraging AWS Glue (PySpark/Python), Lambda, and event-driven ingestion patterns.
• Expert-level SQL with proficiency in window functions, recursive CTEs, query plan analysis, and cost-based query optimization for high-volume data transformations.
• Hands-on experience with Amazon Redshift internals – schema design, workload management (WLM), distribution/sort keys, Spectrum integration, and federated queries.
• Skilled in AWS IAM security engineering, fine-grained access control, and enterprise-grade data governance in multi-account environments.
• Proficiency in Python-based pipeline frameworks for modular, reusable ETL and automation of CI/CD for data pipelines.
• Exposure to AWS Bedrock and AI/ML services to embed predictive/Generative AI capabilities into data engineering workflows.
• Ability to architect resilient, scalable, and cost-optimized cloud-native data platforms, ensuring seamless migration of legacy workloads to Redshift Data Warehouse.