Data Scientist

VTG • Chantilly, VA

7d

About The Position

Seeking an experienced Data Engineer to design, develop, and maintain scalable data processing solutions that support complex data integration, transformation, and analytics requirements. The role involves turning large volumes of structured and unstructured data into actionable information, building data pipelines, and performing data quality analysis. It requires collaboration with customers, developers, and integration partners in an Agile development environment.

The position develops ETL pipelines and data integration workflows, processes operating system and application logs into reports, metrics, and dashboards, and produces enriched, indexed, query-ready datasets. It also includes data validation and quality assurance, troubleshooting processing and performance issues, and maintaining technical documentation for data workflows and integration requirements.

Requirements

• Active TS/SCI with Polygraph.
• Bachelor’s degree in Computer Science, Information Technology, or a related technical field.
• Demonstrated experience developing data processing solutions using Python, PySpark, and Apache Spark.
• Hands-on experience designing, developing, and maintaining ETL pipelines and data transformation workflows.
• Strong experience with data extraction, mapping, transformation, integration, and loading processes.
• Proficiency in SQL and experience working with relational databases such as MySQL and PostgreSQL.
• Experience processing structured, semi-structured, and unstructured datasets.
• Experience working with XML, JSON, and other common data formats.
• Strong knowledge of regular expressions for data parsing, extraction, and manipulation.
• Experience analyzing operating system and application logs and converting them into actionable reports and dashboards.
• Experience performing data profiling, data quality analysis, validation, and troubleshooting.
• Ability to develop detailed ETL documentation, including source-to-target mappings and data dictionaries.
• Experience using Jupyter Notebooks, Visual Studio, or similar development environments.
• Strong analytical, troubleshooting, and problem-solving skills.
• Experience collaborating with customers and integration partners to define and clarify technical requirements.
• Familiarity with Agile software development methodologies and practices.

Nice To Haves

• Experience developing reports and visualizations using AWS CloudWatch, Kibana, or comparable tools.

Responsibilities

• Design, develop, and maintain scalable data processing and ETL pipelines using Python, PySpark, and Apache Spark.
• Extract, transform, and load data from structured and unstructured sources into optimized, query-ready datasets.
• Develop and maintain data mapping, transformation, and integration processes to support business and technical requirements.
• Process and convert operating system logs, application logs, and other data sources into structured reports, metrics, and analytical dashboards.
• Transform disparate data formats into enriched, indexed, and query-friendly datasets.
• Develop and optimize data processing workflows to improve performance, efficiency, and reliability.
• Develop and maintain data integration solutions using SQL, MySQL, and PostgreSQL.
• Work with structured and semi-structured data formats, including XML and JSON.
• Perform data extraction, cleansing, transformation, and validation to ensure accuracy and consistency.
• Develop and maintain data models, database queries, and data mapping specifications.
• Use regular expressions to parse, extract, validate, and transform complex data.
• Support integration of data from multiple systems, applications, and external sources.
• Develop and maintain ETL design documentation, including source-to-target mappings, transformation rules, and data dictionaries.
• Use development environments and tools such as Jupyter Notebooks and Visual Studio to support data modeling, analysis, and development.
• Implement data validation and quality assurance processes to ensure data integrity, accuracy, and completeness.
• Troubleshoot and resolve data processing, integration, and performance issues.
• Maintain technical documentation covering data workflows, processing logic, and integration requirements.

What This Job Offers

• Job Type: Full-time