> Markdown version of [/jobs/ext/1565565-etl-modernization-lead-data-architecture-aws-lead-with-python-pyspark](https://www.wearedevelopers.com/jobs/ext/1565565-etl-modernization-lead-data-architecture-aws-lead-with-python-pyspark). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL Modernization Lead Data Architecture / AWS Lead with Python Pyspark

- **Company:** H&V Solutions LLC
- **Location:** Atlanta, GA, United States
- **Experience:** Expert
- **Salary:** $114,400.0
- **Contract:** Temporary contract
- **Skills:** Agile Methodology, Airflow, Amazon Web Services, JIRA, Microsoft Azure, Cisco PIX, Cloud Computing Security, CompTIA Security+, Cyber Security, Data Architecture, Data Centers, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Transformation, Data Sharing, Data Systems, Data Warehousing, DDoS Mitigation, Identity and Access Management, Intrusion Detection Systems, Virtual Private Networks (VPN), Information Systems Security Architecture Professional, Python (Programming Language), Network Security, Meta-Data Management, Microsoft Project, Network Segmentation, PCI Data Security Standards, Public Key Infrastructure, Scrum Methodology, Systems Development Life Cycle, Zero Trust Network Access, Security Information and Event Management, Wide Area Networks, Smartsheet, Google Cloud, Network Access Control, Informatica Powercenter, Snowflake, Cyber Threat Analysis, Firewalls (Computer Science), Pyspark, Information Technology, Collibra, AWS Glue, Palo Alto Networks, Cortex XSOAR Platform, Fortinet, Data Lakehouse, Firepower, Splunk, Artificial Intelligence Markup Language (AIML), Data Pipelines, Cisco, Blue Team (Cyber Security), Security Orchestration, Automation & Response, Servicenow, Databricks
- **Published:** July 8, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=4003adcbe9f544a5

## About the Role

Mandatory Skills : Apache Airflow, AWS Glue, Databricks, PySpark-Data Science, Python & Data Lakehouse.

Strong hands on with below :

Python Py Spark

SQL Data Modelling

Experience with cloud platforms

AWS S3 Glue Redshift or equivalent

Databricks Snowflake preferred

Strong understanding of:

Data pipelines

Batch streaming architectures

Strong experience in ETL tools Informatica PowerCenter or similar

Data warehousing concepts

Architecture Design

Proven experience in data architecture and solution design

Experience in data modernization migration programs

Knowledge of metadata management and data governance tools eg Collibra

Leadership Delivery

Experience managing onsite offshore delivery models

Strong experience in client facing roles

Ability to lead largescale programs across multiple workstreams

Preferred Experience:

Experience in Capital Markets Financial Services domain

Exposure to:

Data quality frameworks

AIML based data solutions

Agile Scaled Agile delivery models

Experience in building modern data platforms BI COE initiatives, 10+ years of IT project management experience, with at least 8 years

10+ focused on cybersecurity or network security projects

Demonstrated experience managing firewall migration, network security infrastructure, or security operations projects in large enterprise environments Track record of delivering projects on time, within budget, and at expected quality in a Fortune 500 or equivalent-complexity organization Experience managing project budgets of $500K+ and cross-functional teams of 10+ members

Technical Knowledge:

Strong understanding of firewall technologies (Palo Alto, Cisco ASA/Firepower, Fortinet, Check Point) Working knowledge of network security architectures: DMZ, segmentation, zero trust, SD-WAN Familiarity with incident response frameworks (NIST CSF, SANS Incident Response, MITRE Telecommunication&CK) Understanding of threat intelligence lifecycle, indicators of compromise (IOCs), and threat platforms Knowledge of SIEM/SOAR platforms (Splunk, Sentinel, Phantom, XSOAR) Understanding of regulatory and compliance frameworks (PCI-DSS, SOX, NIST 800-53, FAA/TSA cybersecurity directives)

Project Management Skills:

Proficiency in Agile, Waterfall, and hybrid project management methodologies Expert-level use of project management tools (ServiceNow, Jira, MS Project, Smartsheet, or equivalent) Strong risk management, issue resolution, and escalation skills Experience with SDLC and change management processes

Education:

Bachelor's degree in Computer Science, Information Technology, Cybersecurity, or related field Master's degree preferred but not required Certifications (one or more preferred) PMP (Project Management Professional) CISSP (Certified Information Systems Security Professional) CISM (Certified Information Security Manager) CompTIA Security+ GIAC (GSEC, GCIH, or GCTI) CCNP Security or equivalent network security certification

Preferred Qualifications:

Experience in aviation, transportation, or critical infrastructure industries Familiarity with airline-specific regulatory requirements (TSA cybersecurity directives, FAA systems) Experience with cloud security projects (AWS, Azure, GCP) Knowledge of PKI, certificate lifecycle management, and identity security Experience leading security tool evaluations, RFPs, and vendor selection processes ITIL Foundation or higher certification SAFe Agilist or Scrum Master certification

Core Competencies:

Technical Depth - Ability to engage at a technical level with engineers while translating for executive audiences Execution Focus - Drives projects to completion with urgency and accountability Communication - Clear, concise communicator who can distill complex technical topics for diverse stakeholders Adaptability - Comfortable operating in a fast-paced environment with shifting priorities and emerging threats Collaboration - Builds strong relationships across security, IT, and business teams Problem Solving - Proactively identifies risks and removes blockers before they impact delivery

Travel Requirements: Up to 10% travel (primarily domestic, occasional data center or vendor site visits)

## Description

We are looking for an experienced ETL Modernization Lead to drive largescale data transformation initiatives involving migration from legacy ETL platforms Informatica PowerCenter to modern cloud native data engineering frameworks Python PySpark AWS Databricks

This role will be responsible for solution architecture onsite client engagement delivery leadership and modernization strategy execution working closely with business stakeholders and offshore engineering teams, Project Planning & Execution:

Lead end-to-end project delivery for firewall deployments, network security enhancements, incident response improvements, and threat intelligence platform initiatives Develop and maintain detailed project plans, schedules, budgets, resource allocations, and risk registers Manage multiple concurrent projects with competing priorities and interdependencies Drive projects through full lifecycle: initiation, planning, execution, monitoring, and closure Establish and track KPIs, milestones, and deliverables; provide regular executive-level status reporting

Firewall & Network Security:

Coordinate firewall rule change management, migration, and modernization projects (Palo Alto, Cisco, Fortinet, or equivalent) Manage network segmentation, zero trust architecture, and micro-segmentation initiatives Oversee projects involving IDS/IPS, WAF, DDoS mitigation, VPN, and SD-WAN security Drive network access control (NAC) and perimeter security upgrade programs

Cyber Incident Response:

Manage projects that enhance incident response capabilities, playbooks, and processes Coordinate tabletop exercises, red/blue team engagements, and incident simulation programs Drive implementation of SOAR (Security Orchestration, Automation, and Response) platforms Partner with SOC leadership to prioritize and deliver detection and response tool improvements

Threat Intelligence:

Lead projects to operationalize threat intelligence feeds, platforms (MISP, ThreatConnect, or equivalent), and integration with SIEM Coordinate threat hunting program development and automation initiatives Manage vendor relationships for threat intelligence services and data sharing partnerships Drive projects that translate threat intelligence into actionable defensive measures

Stakeholder Management & Communication:

Serve as the primary point of contact between technical security teams, IT infrastructure, business units, and leadership Facilitate governance meetings, steering committees, and change advisory boards Manage third-party vendors, contractors, and service providers Produce clear, concise executive dashboards, risk assessments, and decision-support materials Atlanta - GA - Hybrid ( onsite 10 days in a month)


## Related Videos

- [Our journey with Spring Boot in a microservice architecture](https://www.wearedevelopers.com/videos/511-our-journey-with-spring-boot-in-a-microservice-architecture)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Computer Vision from the Edge to the Cloud done easy](https://www.wearedevelopers.com/videos/263-computer-vision-from-the-edge-to-the-cloud-done-easy)
- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)

## Related Articles

- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence)
- [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers)
- [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated)
- [Events like RSAC Get You CISOs. Developers Decide What Actually Gets Deployed.](https://www.wearedevelopers.com/magazine/693-events-like-rsac-get-you-cisos-developers-decide-what-actually-gets-deployed)