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.