Location: Reston VA or Washington DC (Hybrid- 3 days a week. Need Local Candidates only)
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. Ability to work collaboratively in a fast-paced team environment.
Required Skills:
Python
Python Developer II Location: Reston VA or Washington DC (Hybrid- 3 days a week. Need Local Candidates only) 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...
Python Developer II
Location: Reston VA or Washington DC (Hybrid- 3 days a week. Need Local Candidates only)
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. Ability to work collaboratively in a fast-paced team environment.