XLA is looking for a Data Analyst/DBA for a 12 week temporary assignment. The Data Analyst/DBA DA/DBA is responsible for architecting reporting solutions for a team of business analysts tasked with tracking immigration related inquiries. While the current environment is a Microsoft Access database, the DA/DBA will be responsible for migrating the Access Database to a SQL Server environment. The DA/DBA will also be responsible for developing and maintaining Tableau Dashboards used by ICE clients, including end user support.
Duties of the DA/DBA frequently include importing, cleaning, transforming, validating, or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes. The DA/DBA is responsible in running queries, reporting data and/or providing access to a limited number of database users. The DA/DBA may be required to write Data Definition Language or Data Manipulation Language SQL commands, be responsible for improving data quality and for designing or presenting conclusions gained from analyzing data using statistical tools like Microsoft Excel, SAS, SPSS, Tableau and others.
The DA/DBA will adequately and consistently review all incoming written and non-telephonic complaints submitted to U.S. Immigration and Customs Enforcement (ICE) Enforcement Removal Operations (ERO) Custody Programs Division (CPD), summarizing key points in each case, advising federal staff on the status, and tracking all cases. The DA/DBA shall monitor multiple internal IT systems and email accounts to identify new complaints and inquiries in real time. The DA/DBA will review and log all incoming cases into a case management system and conduct a preliminary review on the nature of the complaint/inquiry.
The DA/DBA will maintain several Tableau Interactive Dashboards of ICE Detention Facility activities. The DA/DBA will also recognize opportunities to develop new Dashboards from Spreadsheet data or directly from ICE source systems.
Additional Duties Include:
Clearance Requirements (in order of preference):
Active ICE 6c-DHS Public Trust