Sr Data Analyst

Infotrend; Washington (District of Columbia); On-site; USD 90,000 - 130,000; Full time

Job summary

Infotrend in Washington, DC is seeking a Sr Data Analyst to extract, validate, and analyze large federal datasets in a highly secure environment. This onsite role requires strong data processing and visualization capabilities.

You will work with SQL, Python or R, Databricks, and Tableau to build reliable reports, ETL/ELT workflows, and AI/ML-enabled models for client-driven insights.

Candidates must hold U.S. Citizenship and be able to obtain a Public Trust clearance.

Qualifications

• Expertise in Python and/or R, SQL, and Databricks or similar software.
• Ability to write queries to extract information from complex data structures.
• Experience with BI platforms such as Tableau and ETL/ELT workflows.
• U.S. Citizenship and ability to obtain Public Trust; willingness to work onsite in Washington, DC.

Responsibilities

• Work with large federal datasets to develop reports, analyses, and models.
• Extract data from IT systems using SQL and other languages.
• Manage, review, validate, and secure data ingestion for a secure environment.
• Create clean datasets for reporting and AI/ML modeling.
• Develop and maintain ETL/ELT workflows.
• Build visualizations and tools to enable data interaction.

Skills

Python

R

SQL

AI/ML modeling

ETL/ELT

Data visualization

Tools

Databricks

Tableau

Job description

Infotrend is hiring a Sr Data Analyst for an onsite role in Washington, DC to extract, validate, and analyze large federal datasets in a highly secure environment.

Responsibilities

• Work with large datasets and multiple data types (customer, operational, transactional) in federal government enterprise systems to develop, maintain, and improve reports, analyses, and models
• Extract data from IT systems using SQL and other programming languages
• Manage, review, validate, and secure data ingestion processes to support accurate, complete, timely, and controlled transfer of data into a highly secure government data environment
• Create clean, structured datasets for reporting, analyses, studies, and both AI/ML and non-AI/ML modeling initiatives
• Develop and maintain ETL/ELT workflows for structured and unstructured data
• Conduct qualitative and quantitative research using client data, including hypothesis formulation, testing, and clear results presentation
• Apply advanced statistical techniques to identify and measure trends, anomalies, and other meaningful insights
• Build visualizations and tools that enable users to interact with data

Requirements

• Expertise in Python and/or R, SQL, and Databricks or similar software
• Ability to understand complex data structures quickly and write queries to extract required information
• Ability to build simple and complex analytical, statistical, AI/ML, or other models from client data to meet quantitative objectives
• Experience integrating large datasets and ETL workflows with Business Intelligence (BI) platforms such as Tableau, including preparing, optimizing, and exposing data for visualization, analytics, and reporting
• Experience developing and managing data connections between Databricks, SQL-based data sources, Python workflows, and Tableau, ensuring reliable, performant, and scalable delivery for dashboards and automated reporting
• Ability to understand operational details underlying data in enterprise systems
• Ability to quickly understand client business requirements using methods such as interviews, document analysis, and self-directed research
• Analytical mindset with the ability to investigate root causes
• Ability to engage in multiple initiatives and prioritize appropriately
• Ability to gather and interpret large volumes of data, identify what is relevant versus superfluous using analytical and statistical techniques
• Excellent verbal and written communication skills and the ability to interact professionally
• Ability to obtain and maintain a Public Trust Security Clearance
• U.S. Citizenship

Technologies

• Python
• R
• SQL
• Databricks
• Tableau