What are the responsibilities and job description for the Python, SQL, AWS Developer position at SES?
Systems Engineering Services is seeking a Python, SQL, AWS Developer based in the Reston, VA area.
Top 5 Technical Skills:
- Python
- SQL
- AWS Data Services
- Jira
- BI concepts
Job Description:
Key Responsibilities
- Design, develop, and maintain data pipelines and ETL/ELT processes using Python and SQL.
- Develop and optimize complex SQL queries, stored procedures, and database objects for reporting and analytics.
- Perform source-to-target data mapping and execute comprehensive data quality validation to ensure data integrity and consistency.
- Work with AWS data services, including AWS Lambda, Amazon Redshift, Apache Iceberg, and Amazon Glacier, to build and support scalable data solutions.
- Collaborate with business stakeholders, data analysts, and developers to understand business requirements and translate them into technical solutions.
- Develop, execute, and maintain test cases for data validation, ETL processes, and reporting solutions.
- Create and maintain technical documentation, including design documents, mapping documents, data dictionaries, and operational procedures.
- Participate in Agile ceremonies, including sprint planning, daily stand-ups, backlog grooming, and retrospectives.
- Track work items, defects, and enhancements using JIRA and contribute to continuous process improvements.
- Troubleshoot production issues, perform root cause analysis, and implement corrective actions.
Required Qualifications
- Strong programming experience in Python.
- Advanced proficiency in SQL, including complex query development and performance optimization.
- Solid understanding of Business Intelligence (BI) concepts, reporting, and analytics.
- Strong knowledge of relational databases and database design principles.
- Hands-on experience with AWS services
- Strong documentation and technical writing skills.
Jake Lutman
Technical Recruiter
Systems Engineering Services