Data Scientist (SQL/Python)

Infotrend Inc; Washington (District of Columbia); Remoto; USD 90.000 - 140.000; Tempo pieno

Descrizione del lavoro

Infotrend Inc is seeking a Data Scientist (SQL/Python) to support our federal client through federal IT services, technology consulting, and data analytics delivery. This hands-on role combines SQL/Python development, data engineering, statistical analysis, and business intelligence to turn complex government datasets into reliable reporting and mission insights.

You will develop and maintain ETL/ELT workflows, validate and integrate data from federal enterprise systems, and build analytical

Competenze

• Experience with Python and SQL for data analysis and modeling.
• Experience building ETL/ELT workflows and data integration.
• Ability to build analytical datasets and BI visualizations.
• Experience with federal data environments and data security considerations.

Mansioni

• Work with large datasets and various types of data 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.

Conoscenze

Python

SQL

R

Databricks

Tableau

ETL/ELT

BI tools

Strumenti

Databricks

Tableau

Descrizione del lavoro

Infotrend Inc is seeking a Data Scientist (SQL/Python) to support our federal client through federal IT services, technology consulting, and data analytics delivery. This hands-on role combines SQL/Python development, data engineering, statistical analysis, and business intelligence to turn complex government datasets into reliable reporting and mission insights.

You will develop and maintain ETL/ELT workflows, validate and integrate data from federal enterprise systems, and build analytical datasets, visualizations, and models using SQL, Python and/or R, Databricks or comparable platforms, and Tableau or other BI tools. You will work directly with government stakeholders and technical teams to translate mission requirements into accurate, secure, and actionable solutions.

Relevant backgrounds include federal IT services and consulting, business consulting, and data analytics supporting civilian or defense government customers.

Location: Washington, DC metropolitan area (DC, Maryland, or Virginia). Primarily remote, with occasional onsite meetings.

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 determination.

Preferred Qualification

• Experience supporting federal websites, ideally a statistical or data-publishing agency.
• Active DHS suitability / Public Trust.

Compensation for this position will be determined based on the candidate's qualifications, relevant experience, and alignment with the responsibilities of the role. In addition to base salary, we offer a comprehensive total compensation package that includes health, dental, and vision insurance, a 401(k) plan with company match, paid time off, and opportunities for bonuses based on individual and company performance.