Sr Data Analyst

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