Sr Data Scientist / Analyst

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

Job summary

Infotrend is seeking a Senior Data Scientist/Analyst to extract, manage, validate, and analyze large datasets from federal government systems in a highly secure environment. You will develop and maintain SQL queries, ETL/ELT workflows, and create structured data sets for reporting, research, and AI/ML modeling.

You will collaborate with government stakeholders to translate requirements into reliable, data-driven solutions, using Python/R, SQL, and Databricks with BI integrations like Tableau.

Qualifications

• Proven expertise in Python and/or R, SQL, and Databricks or equivalent platforms.
• Ability to design and implement ETL/ELT workflows.
• Experience with reporting, AI/ML modeling, and data visualization.
• U.S. Citizenship and ability to obtain Public Trust clearance.

Responsibilities

• Work with large federal government datasets to develop, enhance reports, analyses and models.
• Extract data from IT systems using SQL and other programming languages.
• Manage, review, validate, and secure data ingestion into a highly secure government 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 qualitative and quantitative research, formulate hypotheses, test them and present results clearly.
• Use advanced statistical techniques to identify trends, anomalies and insights.
• Create visualizations and tools for interactive data exploration.

Skills

Python

R

SQL

ETL/ELT

Data modeling

Tools

Databricks

Tableau

Job description

Description

The Senior Data Scientist/ 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 Scientist 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

• 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 integrate 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 BI tools such as Tableau, ensuring reliable, performant, and scalable data delivery for dashboards and automated reporting.
• 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.