What are the responsibilities and job description for the Python AWS Data Developer position at Secretaria de Serviços Prefeitura de São Paulo?
Must be Local to Reston, NO RELO - OnSite 3 days a week.
Key Responsibilities
SES hires W2 benefitted and non-benefitted consultants. Our contract employee benefits include group medical dental vision life LT and ST disability insurance, 21 days of accrued paid time off, 401k, tuition reimbursement, performance bonuses, paid overtime, and more. Due to corporate regulations, we cannot work with outside companies on this opening; only direct, individual candidates representing themselves to SES, please.
About SES Systems Engineering Services Corporation
SESC was founded in 1989, is a leading provider of technology solutions to Fortune 1000 companies and government organizations. Specializing in Accelerated Development (agile application development, mobile, systems integration, project and program management), Architecture (SOA, microservices, cloud), Data (analytics, DW, BI, big data), Testing (test architecture, manual, automation, data), Cyber Security (SSO, mobile, IAM) and DevOps (roadmap creation, assessments, CICD, tool evaluation, implementation), Employer is guided by a corporate mission to provide valuable solutions to our client s technology needs through responsive quality services.
Jim Murphy
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.
- 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.
SES hires W2 benefitted and non-benefitted consultants. Our contract employee benefits include group medical dental vision life LT and ST disability insurance, 21 days of accrued paid time off, 401k, tuition reimbursement, performance bonuses, paid overtime, and more. Due to corporate regulations, we cannot work with outside companies on this opening; only direct, individual candidates representing themselves to SES, please.
About SES Systems Engineering Services Corporation
SESC was founded in 1989, is a leading provider of technology solutions to Fortune 1000 companies and government organizations. Specializing in Accelerated Development (agile application development, mobile, systems integration, project and program management), Architecture (SOA, microservices, cloud), Data (analytics, DW, BI, big data), Testing (test architecture, manual, automation, data), Cyber Security (SSO, mobile, IAM) and DevOps (roadmap creation, assessments, CICD, tool evaluation, implementation), Employer is guided by a corporate mission to provide valuable solutions to our client s technology needs through responsive quality services.
Jim Murphy