Sr ETL Developer - Python/Pyspark, AWS

Overview

On Site
$65 - $72 per hour
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6-12 month(s)

Skills

Python | PySpark | Glue | AWS | large data sets

Job Details




Job Summary:


Dexian is seeking a Sr ETL Developer - Python/Pyspark, AWS for an opportunity with a client located in Chicago, IL.






Responsibilities:



  • Leads, Designs, implements, deploys and optimizes back end ETL services

  • Support a massive scale enterprise data solution using AWS data and analytics services

  • Analyze and interpret complex data and related systems and provides the efficient technical solutions

  • Provide support to ETL schedule and maintain compliance to same

  • Develop and maintain standards to ETL codes and maintain an effective project life cycle on all ETL processes

  • Coordinate with cross functional teams like architects, platform engineers, other developers and product owners to build data processing procedures

  • Perform root cause analysis on production issues and perform routine monitoring on databases and provide support to ETL environments

  • Help create functional specifications, technical designs and working with business process area owners

  • Implement industry best practices code and configuration for production and non-production environments in an highly automated environment

  • Provides technical advice, effort estimate, impact analysis

  • Provides timely project status and issue reporting to management



Requirements:



  • 6+ years experience using ETL tools to perform data cleansing, data profiling, transforming, and scheduling various workflows

  • Expert level proficiency with writing, debugging and optimizing SQL

  • 3-4 years programming experience using Python or PySpark/Glue required

  • Knowledge of common design patterns, models and architecture used in Big Data processing

  • 3-4 years' experience with AWS services such as Glue, S3, Redshift, Lambda, Step Functions, RDS Aurora/MySQL, Apache Iceberg, CloudWatch, SNS, SQS, EventBridge

  • Capable of troubleshooting common database issues, familiarity with observability tools

  • Self-starter, responsible, professional and accountable

  • A 'finisher', seeing a project or task through to completion despite challenges




Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.


Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit to learn more.


Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.



Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Dexian Signature Consultants