Python, SQL, AWS Developer

Systems Engineering Services is seeking a Python, SQL, AWS Developer based in the Reston, VA area.

Top 5 Technical Skills:

1. Python
2. SQL
3. AWS Data Services
4. Jira
5. 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