Job Title: Software Engineer
Pay rate: $57 per hour
Duration: 12 months
W2 contract only (No C2C)
Location- Urbandale, IA OR REMOTE
Primary Roles
- Create and update API interfaces to MySQL backend databases. The API is hosted on AWS ECS and written using Python.
- Ingest data into the Enterprise Data Lake from various database/file sources
- Transform data and create common tables using Pyspark and SQL
- Load data into MySQL from the Enterprise Data Lake
- Analyze data using SQL and Pyspark
- Create and maintain updates to AWS resources
Supporting Roles
- Work closely with the front end developer on the API specification
- Build test scripts in Python to test data replication processes
- Work closely with the product manager and end users to understand requirements
Required Skills
- Experience requirements - at least 3 - 5 years of experience with SQL, Python and cloud computing (AWS preferred)
- Languages and Frameworks: Python, SQL, Pyspark
- Core understanding of AWS services including IAM, Lambda, S3, RDS, ECS and EC2
- Experience developing Databricks jobs and pipelines
- Other: Docker, containerization concepts, REST API concepts (calling REST APIs using Python)
Additional Skills
Terraform, Github Actions, Datadog, AWS Database Migration Service, Apache Airflow, REST API development in Python
*** If this position may be interested to you, please email me back at somp767@kellyservices.com with your most up to date resume in word format) and advise the best time and number at which you can be reached****
