Python-Based Data Engineer

Job Title: Python Developer with Cloud and Database Expertise
Start Date: ASAP
Contract Type: Full-time, 6 Months
Languages: English (Fluent)

Role Overview
We are seeking a highly skilled Python Developer with strong expertise in database management, cloud infrastructure, email automation, and DevOps/system integration. The consultant will be responsible for automation, data processing, migration projects, and performance optimization in a fully remote environment.

Technical Skills and Experience
Python Development

• Proficiency in writing, debugging, and refactoring Python scripts

• Experience in automation for data scraping, processing, and Excel file generation

• Familiarity with libraries such as requests, BeautifulSoup/Selenium, pandas, and openpyxl/xlsxwriter

• Ability to modularize standalone scripts into generalized, reusable bots

Database Expertise

• Strong SQL skills for reading, inserting, and transforming data

• Hands-on experience with PostgreSQL, including schema design and query optimization

• Familiarity with Microsoft SQL Server and experience with data extraction and migration

Cloud Infrastructure (AWS)

• Experience migrating workloads to AWS-managed Postgres services (Amazon RDS, Aurora)

• Familiarity with AWS cost optimization strategies and services (Lambda, Step Functions, CloudWatch, EC2, S3, SES/SNS)

• Understanding of ETL workflows and automation in AWS

Email Automation

• Configuring and automating email distribution workflows using Python and AWS tools (e.g., SES)

• Experience with secure delivery and monitoring of automated reports

DevOps / System Integration

• Familiarity with private server setup and integration with cloud environments

• Experience with CI/CD pipelines, Git version control, and automated deployment processes

• Knowledge of cron jobs, Airflow, Prefect, or native Linux task schedulers

Project and Process Skills
Systematic Refactoring

• Ability to refactor redundant code into robust, maintainable components

• Experience creating parameterized scripts for diverse user bases

Migration and Change Management

• Proven experience in planning and executing database/script migrations with minimal downtime

• Strong focus on maintaining data integrity and validating migration outcomes

Performance and Cost Optimization

• Skills in benchmarking and optimizing script performance

• Ability to design cost-efficient cloud infrastructure without compromising service quality

Security and Compliance Awareness

• Understanding of data privacy standards and best practices for secure access to servers, databases, and report delivery

Soft Skills and Collaboration
Communication

• Ability to communicate complex technical topics to both technical and non-technical audiences

• Skilled in documenting solutions, writing handover materials, and delivering knowledge transfer sessions

Project Management

• Capable of estimating timelines, managing project milestones, and providing regular progress updates

• Experience working independently and collaboratively in cross-functional teams