{"schemaVersion":"jobsearcher.job.v1","id":"a12bad09e922e7eedb602a6e","url":"https://jobsearcher.com/jobs/a12bad09e922e7eedb602a6e","canonicalUrl":"https://jobsearcher.com/jobs/a12bad09e922e7eedb602a6e","title":"AWS Data Engineer","description":"Description:\nsg360° partners with Fortune 1000 brands to pursue unmatched direct marketing performance. We leave no stone unturned in our efforts to drive smarter targeting, stronger messaging and improved ROI. Everything we do - audience analytics, strategic planning, creative development, production and distribution - we do in the pursuit of performance.\nWhen you join us, you gain access to a comprehensive benefits package, including paid time off, holiday pay, health, dental, and vision insurance, life insurance, an education assistance program, short- and long-term disability, wellness resources, identity theft protection, and a 401k with employer match. Be part of a legacy of excellence and growth with sg360°!\nWe are a technology-driven company leveraging AWS cloud infrastructure to build and host high-performance online applications. Our platforms are developed using modern frameworks such as Java/J2EE, Python, Spring Boot, Angular, and SQL. We are looking for an experienced AWS Data Engineer with deep hands-on expertise in Python (PySpark) and SQL. The ideal candidate will design, build, and optimize scalable data pipelines and lakehouse architectures on AWS. This role will involve exploratory data analysis, transforming and modeling large datasets, implementing CDC (Change Data Capture) patterns, and enabling analytics and reporting through Redshift, Athena, and QuickSight.\nSG360° does not offer employment-based visa sponsorship now or in the future. Candidates must be legally authorized to work in the United States without the need for current or future visa sponsorship. This policy applies to all applicants, including those whose employment authorization may expire in the future and would require sponsorship to remain employed.\nPRIMARY RESPONSIBILITIES\nIngesting & Storing Data\nBuild and manage data lakes on Amazon S3.\nConfigure and maintain AWS Glue Crawlers and the Glue Data Catalog.\nImplement streaming and CDC ingestion using AWS DMS / Kinesis.\nApply proper IAM configurations to ensure secure data access.\nTransforming & Querying Data\nDevelop robust ETL pipelines using AWS Glue (PySpark and Python Shell jobs).\nLeverage AWS Lambda for lightweight, event-driven transformations.\nQuery and analyze datasets using Amazon Athena over S3.\nDesign and optimize data warehouses using Amazon Redshift (including stored procedures and complex SQL).\nSupport business insights through Amazon QuickSight dashboards and visualizations.\nBuilding Scalable Data Platforms\nDesign and implement Lakehouse architectures (e.g., Iceberg on S3 with time travel).\nApply fine-grained security controls via AWS Lake Formation.\nOrchestrate data workflows using Step Functions.\nIntegrate DynamoDB and SQS for event-driven and metadata-driven processing.\nTune performance using compaction, distribution keys, sort keys, and parallelism strategies.\nManage costs via intelligent use of S3 storage tiers, Redshift RA3 nodes, and Glue job optimization.\nImplement and monitor data quality and observability mechanisms.\nRequirements:\nMINIMUM REQUIRED EDUCATION & EXPERIENCE\nBachelor’s degree in computer science, Information Systems, or equivalent experience.\n5+ years of Python development experience (must include data-focused work).\n3+ years of PySpark experience developing large-scale ETL jobs.\nAdvanced SQL skills, including query optimization, and analytics functions.\nStrong experience with AWS data ecosystem: Glue, Redshift, Athena, DMS, S3, IAM, Lambda, and QuickSight.\nWorking knowledge of Change Data Capture (CDC) techniques and tools (e.g., DMS, Debezium).\nAt least 1 year of data visualization experience (QuickSight, Power BI, or Tableau).\nSolid understanding of data modeling, data partitioning, schema design, and metadata management.\nFamiliarity with data quality frameworks and observability tools.\nADDITIONAL ELIGIBILITY QUALIFICATIONS\nExperience managing EMR clusters for high-volume Spark workloads.\nExposure to data governance, lineage, and cataloging at scale.\nExperience with DevOps for data (CI/CD pipelines, IaC with Terraform/CloudFormation).\nON-SITE ROLE\nThis is an on-site role. Candidates must be in a commutable distance or willing to relocate independently.\nSG360° is an Equal Opportunity Employer. We make employment decisions based on merit, qualifications, and business needs. SG360° does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, veteran status, or any other status protected by applicable law. SG360° will provide reasonable accommodations to individuals with disabilities in the hiring process, in accordance with applicable laws. If you require an accommodation to complete your application, please contact the location to which you are applying and ask to speak with the Human Resources representative.","company":"Sg360","rawCompany":"sg360","city":"Wheeling","state":"IL","isRemote":false,"isActive":false,"createdAt":"2026-07-16T17:59:38.156Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-2051.00","title":"Data Scientists","slug":"data-scientists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"AWS Data Engineer","description":"Description:\nsg360° partners with Fortune 1000 brands to pursue unmatched direct marketing performance. We leave no stone unturned in our efforts to drive smarter targeting, stronger messaging and improved ROI. Everything we do - audience analytics, strategic planning, creative development, production and distribution - we do in the pursuit of performance.\nWhen you join us, you gain access to a comprehensive benefits package, including paid time off, holiday pay, health, dental, and vision insurance, life insurance, an education assistance program, short- and long-term disability, wellness resources, identity theft protection, and a 401k with employer match. Be part of a legacy of excellence and growth with sg360°!\nWe are a technology-driven company leveraging AWS cloud infrastructure to build and host high-performance online applications. Our platforms are developed using modern frameworks such as Java/J2EE, Python, Spring Boot, Angular, and SQL. We are looking for an experienced AWS Data Engineer with deep hands-on expertise in Python (PySpark) and SQL. The ideal candidate will design, build, and optimize scalable data pipelines and lakehouse architectures on AWS. This role will involve exploratory data analysis, transforming and modeling large datasets, implementing CDC (Change Data Capture) patterns, and enabling analytics and reporting through Redshift, Athena, and QuickSight.\nSG360° does not offer employment-based visa sponsorship now or in the future. Candidates must be legally authorized to work in the United States without the need for current or future visa sponsorship. This policy applies to all applicants, including those whose employment authorization may expire in the future and would require sponsorship to remain employed.\nPRIMARY RESPONSIBILITIES\nIngesting & Storing Data\nBuild and manage data lakes on Amazon S3.\nConfigure and maintain AWS Glue Crawlers and the Glue Data Catalog.\nImplement streaming and CDC ingestion using AWS DMS / Kinesis.\nApply proper IAM configurations to ensure secure data access.\nTransforming & Querying Data\nDevelop robust ETL pipelines using AWS Glue (PySpark and Python Shell jobs).\nLeverage AWS Lambda for lightweight, event-driven transformations.\nQuery and analyze datasets using Amazon Athena over S3.\nDesign and optimize data warehouses using Amazon Redshift (including stored procedures and complex SQL).\nSupport business insights through Amazon QuickSight dashboards and visualizations.\nBuilding Scalable Data Platforms\nDesign and implement Lakehouse architectures (e.g., Iceberg on S3 with time travel).\nApply fine-grained security controls via AWS Lake Formation.\nOrchestrate data workflows using Step Functions.\nIntegrate DynamoDB and SQS for event-driven and metadata-driven processing.\nTune performance using compaction, distribution keys, sort keys, and parallelism strategies.\nManage costs via intelligent use of S3 storage tiers, Redshift RA3 nodes, and Glue job optimization.\nImplement and monitor data quality and observability mechanisms.\nRequirements:\nMINIMUM REQUIRED EDUCATION & EXPERIENCE\nBachelor’s degree in computer science, Information Systems, or equivalent experience.\n5+ years of Python development experience (must include data-focused work).\n3+ years of PySpark experience developing large-scale ETL jobs.\nAdvanced SQL skills, including query optimization, and analytics functions.\nStrong experience with AWS data ecosystem: Glue, Redshift, Athena, DMS, S3, IAM, Lambda, and QuickSight.\nWorking knowledge of Change Data Capture (CDC) techniques and tools (e.g., DMS, Debezium).\nAt least 1 year of data visualization experience (QuickSight, Power BI, or Tableau).\nSolid understanding of data modeling, data partitioning, schema design, and metadata management.\nFamiliarity with data quality frameworks and observability tools.\nADDITIONAL ELIGIBILITY QUALIFICATIONS\nExperience managing EMR clusters for high-volume Spark workloads.\nExposure to data governance, lineage, and cataloging at scale.\nExperience with DevOps for data (CI/CD pipelines, IaC with Terraform/CloudFormation).\nON-SITE ROLE\nThis is an on-site role. Candidates must be in a commutable distance or willing to relocate independently.\nSG360° is an Equal Opportunity Employer. We make employment decisions based on merit, qualifications, and business needs. SG360° does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, veteran status, or any other status protected by applicable law. SG360° will provide reasonable accommodations to individuals with disabilities in the hiring process, in accordance with applicable laws. If you require an accommodation to complete your application, please contact the location to which you are applying and ask to speak with the Human Resources representative.","datePosted":"2026-07-16T17:59:38.156Z","dateModified":"2026-07-16T17:59:38.156Z","hiringOrganization":{"@type":"Organization","name":"Sg360","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Wheeling","addressRegion":"IL","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"a12bad09e922e7eedb602a6e"},"url":"https://jobsearcher.com/jobs/a12bad09e922e7eedb602a6e"}}