Sr Data Engineer

System One; Arlington (VA); On-site; USD 170,000 - 185,000; Full time

Job summary

System One in Arlington, VA seeks a Sr Data Engineer for 6-month contract-to-hire. Onsite 4 days a week with one remote day, 40 hours weekly, and an active DoD Secret clearance. The role focuses on building and optimizing ETL pipelines, data integration, and scalable warehousing in Azure.

The ideal candidate has 7+ years of related experience and a strong background with Azure Data Factory, Databricks, Data Lake Storage, SQL Database, and Synapse.

Qualifications

• Active DoD Secret clearance is required.
• BA/BS in Computer Science, IT, Data Analytics or related field.
• 7+ years of related experience.
• Strong experience with Azure ETL services and data warehousing.

Responsibilities

• Build, maintain, and optimize ETL data pipelines into the data warehouse.
• Integrate large, complex data sets to meet business requirements.
• Design scalable and reliable data warehousing solutions.
• Extract, transform, and load data into Azure storage (Azure Data Lake, Azure SQL, Synapse).
• Develop and maintain data pipelines using Azure Data Factory and related Azure tech.
• Manage and optimize databases ensuring data quality, integrity, and security.
• Automate processes, improve data delivery, and redesign infrastructure for scale.
• Collaborate with data scientists and analysts to deliver high-quality data solutions.

Skills

ETL processes

Azure services

SQL

Python

R

SAS

JavaScript

Education

Bachelor's degree in Computer Science, IT, Data Analytics or related field

Tools

Azure Data Factory

Azure Databricks

Azure Data Lake Storage

Azure SQL Database

Azure Synapse Analytics

Job description

Job Title: Sr Data Engineer
Location: Arlington, VA
Type: Contract to Hire
Compensation: 170-185K conversion salary
Work Model: Onsite 4 days a week- remote one day
Hours: 40.0 hours per week
Security Clearance: Active DoD Secret clearance required

System One is looking for a strong data engineer for a 6-month contract-to-hire opening in Arlington, VA. This position requires an active Secret Clearance and that the candidate can work onsite 4 days a week.

Responsibilities

• Build, maintain, and optimize data pipelines for extracting, transforming, and loading (ETL) data from various sources into our data warehouse.
• Integrate large, complex data sets that meet functional and non-functional business requirements.
• Design and implement scalable and reliable data warehousing solutions.
• Extract data from various sources, transform it into a usable format, and load it into Azure data storage solutions such as Azure Data Lake Storage, Azure SQL Database, or Azure Synapse Analytics.
• Develop and maintain data pipelines using Azure Data Factory and other relevant Azure technologies.
• Manage and optimize databases, ensuring data quality, integrity, and security.
• Automate manual processes, optimize data delivery, and re-design infrastructure for greater scalability.
• Collaborate with data scientists, analysts, and other stakeholders to understand data needs and deliver high-quality data solutions.
• Document data flows, processes, and system architecture to ensure clarity and knowledge sharing within the team.

Requirements

• An active DoD Secret clearance.
• BA/BS in Computer Science, Information Technology, Data Analytics, or related field.
• 7+ years of related experience.
• Strong experience in data extract transform load (ETL) processes using Azure services, such as Azure Data Factory, Azure Databricks, Azure Data Lake Storage, Azure SQL Database, or Azure Synapse Analytics.
• 6+ years’ experience and skill writing coding languages (such as SQL, Python, R, SAS, and Java Scripts).
• 4+ years’ experience working with projects involving machine learning, natural language processing, robotics process automation, artificial intelligence, text and/or data mining, as well as statistical and mathematical methods.
• Experience with using SQL to conduct complex database queries.
• Experience with AI/ML.

System One, and its subsidiaries including Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.