Sr Data Analyst

Description

The Senior Data Analyst is responsible for extracting, managing, validating, and analyzing large datasets from federal government enterprise systems within a highly secure government data environment. The position develops and maintains SQL queries, ETL/ELT workflows, and structured datasets to support reporting, research, statistical analysis, and AI/ML and non-AI/ML modeling initiatives. The Senior Data Analyst also applies advanced analytical and statistical techniques to identify trends, anomalies, and actionable insights, develops data visualizations and analytical models, and ensures the accuracy, completeness, timeliness, and security of data ingestion processes. The role requires strong expertise in Python and/or R, SQL, and Databricks or similar platforms. The Senior Data Analyst collaborates with government stakeholders and technical teams to translate mission and business requirements into accurate, reliable, and actionable data-driven solutions.

Responsibilities:

• Work with large datasets and various types of data (customer, operational, transactional) found in federal government enterprise systems to develop, maintain and enhance reports, analysis and models
• Extract data from various IT systems using SQL and other programming languages
• Manage, review, validate, and secure data ingestion processes to ensure the accurate, complete, timely, and controlled transfer of data into a highly secure government data environment.
• Create clean, structured data sets for use in reports, analyses, studies and both AI/ML and non-AI/ML models.
• Develop and maintain ETL/ELT workflows for structured and unstructured data.
• Conduct both qualitative and quantitative research using client data, formulate hypotheses, test them and present the results in a clear and concise manner.
• Use advanced statistical techniques to identify and measure trends, anomalies and determine other relevant insight.
• Create visualizations and other tools that allow users to interact with data.

Requirements

• Extensive experience working with immigration data, primarily Immigration and Customs Enforcement (ICE) data preferred Expertise in Python and/or R, SQL and Databricks or similar software.
• Ability to quickly understand complex data structures and formulate queries to extract information as needed
• Ability to build both simple and complex analytical, statistical, AI/ML or other model using client data that fulfill a quantitative purpose/problem asked by the client.
• Ability to quickly understand the operational underpinnings of data found in enterprise systems
• Ability to quickly understand client business requirements using a variety of methods such as interviews, document analysis, and self-directed research.
• Ability to think analytically, outside-the-box, and dive to the root cause of situations.
• Ability to successfully engage in multiple initiatives simultaneously and prioritize appropriately.
• Ability to gather and interpret large amounts of data and information and quickly recognize what is superfluous and what is relevant using analytical and statistical techniques.
• Excellent verbal and written communication skills and ability to interact professionally.
• Ability to obtain and maintain a Public Trust Security Clearance.
• U.S. Citizenship.