Lead Data Engineer II
Job Description
As a Lead Data Engineer II on Deloitte’s GPS AI & Data team, you will operate and improve multiple ArcGIS Enterprise environments and lead ArcGIS-integrated data pipelines from requirements through delivery, including client-facing communication around status, risks, and priorities. This role is based onsite in Los Angeles, CA.
Responsibilities
- Lead the operation, maintenance, and continuous improvement of five ArcGIS Enterprise environments, with ownership of health, availability, security, and performance.
- Plan and lead platform upgrades, migrations, patching, and incident resolution, coordinating with GIS developers and technical team members.
- Translate client and business needs into data engineering requirements, including user stories, acceptance criteria, work plans, and work assignments.
- Guide the design and delivery of ArcGIS-integrated data pipelines, PostgreSQL data models, and data quality controls.
- Lead client discussions and communicate delivery status and risks; prioritize work and oversee deliverables against requirements, quality standards, and timelines.
Requirements
- 10+ years of professional experience.
- 5+ years administering and supporting ArcGIS Enterprise environments and implementing ArcGIS development and architecture, including upgrades, migrations, patching, security administration, performance monitoring, and incident troubleshooting.
- 5+ years developing and maintaining ETL or ELT data pipelines using Python and SQL.
- 5+ years designing data models and integrating spatial and tabular data in PostgreSQL, including developing, optimizing, and troubleshooting SQL queries and database objects.
- 5+ years implementing data quality checks, data lineage documentation, pipeline monitoring, version-control workflows, and deployment workflows; plus experience leading technical teams and managing client requirements, user stories, acceptance criteria, work plans, and delivery risks.
- Ability to travel 25%, on average, based on work activities and client needs.
- Must be legally authorized to work in the United States without employer sponsorship, now or at any time in the future.
Technologies
- ArcGIS Enterprise
- Python
- SQL
- PostgreSQL
- ETL
- ELT
Preferred Qualifications
- Experience using ArcGIS application programming interfaces (APIs) or geospatial web services to integrate mapping capabilities with data applications.
- Experience creating automated test suites for data pipelines and database changes.
Compensation
USD 151,500 - 252,500 per year (reasonable estimate range for Los Angeles, CA).
Location
Los Angeles, CA (onsite)