Data Scientist

Wyetech is seeking an experienced Data Scientist to strengthen development, enhancement, and ongoing maintenance of enterprise data processing capabilities within a mission-critical Intelligence Community cloud environment. This role supports large-scale big data processing, ETL development, database and log analytics, and collaborative Agile delivery with Government stakeholders and integration partners.

What you will do

• Design, develop, maintain, and enhance large-scale data processing capabilities using Python, Apache Spark, and PySpark.
• Develop and optimize bulk data pipelines within enterprise cloud computing environments.
• Process, analyze, and transform complex datasets to support mission-critical applications and analytical requirements.
• Build scalable solutions for both structured and unstructured information.
• Conduct extensive data reviews, including data quality analysis, to identify inconsistencies, anomalies, and processing issues.
• Apply data modeling and transformation methods to improve accessibility, consistency, and usability of data.
• Support enhancements and new system capabilities for cloud-based applications.
• Collaborate with engineering teams to troubleshoot data processing problems and improve pipeline reliability.
• Design, implement, and maintain Extract, Transform, Load (ETL) processes to support enterprise data integration.
• Perform data mapping, extraction, transformation, and loading across multiple data sources, integrating disparate structured and unstructured formats into enriched, query-friendly structured datasets.
• Create indexed data files that enable efficient querying, reporting, and analytical processing.
• Process and transform supported data formats including XML and JSON (and others as supported).
• Develop and maintain source-to-target mappings, data dictionaries, and ETL design documentation.
• Identify and resolve data integration challenges, transformation errors, and data quality issues.
• Develop and execute SQL queries for retrieval, manipulation, validation, and analysis.
• Use relational database technologies including MySQL and PostgreSQL.
• Perform analytical development using notebooks and integrated development environments, supported with Visual Studio.
• Carry out data validation, reconciliation, and quality assurance activities.
• Improve database queries, data structures, and processing efficiency by identifying opportunities for optimization.
• Integrate relational database information into enterprise data pipelines.
• Convert operating system logs and application data logs into actionable reports, metrics, and dashboards.
• Develop analytical reports and monitoring capabilities using Amazon CloudWatch and Kibana, and analyze log data for patterns, trends, anomalies, and performance issues.
• Use Regular Expressions (RegEx) to extract, filter, and transform relevant information.
• Troubleshoot log ingestion, data transformation, and reporting accuracy; maintain and enhance reporting as customer requirements evolve.
• Support cloud-based data ingestion, transformation, storage, and analytical reporting, including troubleshooting data pipeline failures and application integration issues.
• Interface directly with Government customers and integration partners to identify, clarify, and document technical objectives, translating requirements into actionable data processing and analytical development tasks.
• Participate in Agile development activities, including task definition, scope refinement, planning, and reviews, and contribute technical input across cross-functional teams.
• Document analytical methodologies, data processing workflows, and technical solutions, and support testing, validation, troubleshooting, and continuous improvement.
• Communicate technical findings, development progress, and potential risks to stakeholders.

Required skills

• Active TS/SCI security clearance with current Full Scope Polygraph (FSP).
• Demonstrated experience using Apache Spark, PySpark, and Python for large-scale data processing and analytical development.
• Demonstrated experience with data mapping, extraction, transformation, and loading (ETL).
• Experience developing analytical reports using Amazon CloudWatch and Kibana.
• Experience processing and converting operating system and application logs into analytical reports, metrics, and dashboards.
• Experience using Regular Expressions (RegEx) for data extraction, filtering, and transformation.
• Experience using SQL, MySQL, and PostgreSQL.
• Experience processing and transforming data file formats, including XML and JSON.
• Experience using integrated development environments and data modeling tools, including notebooks and Visual Studio.
• Experience transforming disparate structured and unstructured datasets into enriched, query-friendly structured data stored in indexed files.
• Experience performing extensive data reviews, data validation, and data quality analysis.
• Experience developing ETL design documentation, including source-to-target mappings and data dictionaries.
• Experience communicating with customers and integration partners to gather, clarify, and document technical objectives.
• Experience supporting Agile development activities, including task definition, scope development, and technical reviews.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent written and verbal communication skills.
• Ability to work effectively with cross-functional engineering teams and Government stakeholders.

Tools and technologies

• Python, Spark, PySpark, ETL, SQL, MySQL, PostgreSQL
• Amazon CloudWatch, Kibana, RegEx, XML, JSON
• Visual Studio, notebooks
• Amazon Elastic MapReduce (EMR), Databricks Unified Analytics Platform, AWS Lambda
• Amazon Simple Notification Service (SNS), Amazon Simple Queue Service (SQS), Amazon Elastic Compute Cloud (EC2)
• Amazon DynamoDB, Amazon Relational Database Service (RDS)
• Elastic Stack (ELK), Elasticsearch, Logstash
• Pandas

Benefits

• Automatic 20% of each employee’s gross compensation contributed to a SEP IRA (no requirement for employee matching).
• Generous PTO plan of up to 200 hours annually.
• Choice of Medical Plan Options, some with Health Savings Account (HSA).
• Vision and Dental.
• Life and AD&D Benefits; Short and Long-Term Disability.
• Hospital Indemnity, Accident, and Critical Illness Insurances.
• Optional Identity Theft and Legal Protection Services.
• Employee Referral Bonus eligibility up to $10,000.
• Mobility among Wyetech-supported contracts.
• Team-building events throughout the year, including monthly lunches, summer company picnic, and an annual holiday party.
• Two complimentary branded clothing orders annually.

Compensation and location

Location: Chantilly, VA (onsite). Salary range: USD 99 to 134 per hour (hourly pay rates listed are a general guideline and not a guarantee of compensation). Compensation may vary based on Government contract rates, education, relevant prior work experience, knowledge, skills, competencies, certifications, and geographic location. Hourly pay rates reflect pre-benefit gross wage amounts.

Citizenship and clearance requirements

• Due to federal contract requirements, United States citizenship and position-appropriate security clearance are required.
• Active TS/SCI security clearance with current Full Scope Polygraph (FSP) is required.