# Data Engineer **Company**: Leidos **Location**: 6314 Remote/Teleworker US **Work arrangement**: remote **Experience**: senior **Job type**: full-time **Salary**: $131,300.00 - $237,350.00 **Category**: Data Science **Industry**: Technology **Apply**: https://leidos.wd5.myworkdayjobs.com/en-US/External/job/6314-RemoteTeleworker-US/Data-Engineer_R-00193829-1?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply **Canonical**: https://yubhub.co/job/data-engineer-f159527c-0ee/ ## Description The Homeland Sector at Leidos currently has an opening for a Data Engineer with a strong background in data analytics to support an exciting DHS software development program. The Data Engineer is responsible for designing, developing, implementing, and maintaining the data architecture, pipelines, integrations, and data structures required to transform raw operational data into reliable, accessible, and analysis-ready information. **Data Architecture and Engineering** - Design logical and physical data models appropriate for analytical workloads. - Develop data structures that integrate information from multiple applications, databases, files, APIs, logs, and external data sources. - Evaluate existing data architectures and recommend improvements to reliability, scalability, performance, maintainability, and accessibility. - Support the design and implementation of data warehouses, data marts, data lakes, lakehouses, and other analytical data repositories as appropriate. **Data Integration and Pipelines** - Design, develop, test, deploy, and maintain ETL/ELT processes and automated data pipelines. - Extract and integrate data from relational databases, applications, APIs, flat files, logs, and other structured and semi-structured sources. - Develop repeatable processes for transforming raw transactional data into standardized, analysis-ready datasets. - Implement scheduling, orchestration, monitoring, error handling, and recovery capabilities for data pipelines. - Develop interfaces and data feeds supporting downstream reporting, dashboards, analytics platforms, and external systems. **Data Transformation and Quality** - Clean, normalize, deduplicate, validate, and transform data. - Investigate data discrepancies and work with application developers, database administrators, analysts, and business users to determine root causes. - Implement controls that prevent data-quality problems from propagating into downstream reports and analytical products. **Business Intelligence and Analytics Support** - Develop curated datasets and data models optimized for BI, reporting, visualization, and analytical workloads. - Work with BI analysts and business stakeholders to translate business questions into data requirements. - Support development of common definitions and calculation methodologies for enterprise metrics and key performance indicators (KPIs). - Support ad hoc analytical requests when new data sources or transformations are required. - Assist analysts in understanding data lineage, relationships, limitations, and appropriate use. **Data Governance and Documentation** - Document data sources, transformations, interfaces, business rules, dependencies, lineage, and data definitions. - Maintain technical documentation for data pipelines, models, interfaces, and analytical repositories. - Support development and maintenance of data dictionaries and metadata repositories. **Database and Performance Engineering** - Develop and optimize complex SQL queries, stored procedures, views, and data transformations. - Analyze and improve performance of analytical queries and data-processing workloads. - Work with Database Administrators (DBAs) to optimize database structures supporting analytical requirements. - Recommend indexing, partitioning, aggregation, caching, or other techniques where appropriate. - Ensure analytical workloads do not adversely affect production transactional systems. **Security and Compliance** - Implement data-engineering solutions consistent with organizational cybersecurity and privacy requirements. - Apply appropriate access controls to sensitive data. - Support data classification, encryption, auditing, logging, retention, and protection requirements. - Work with cybersecurity personnel to ensure data movement and storage comply with applicable security requirements. - Support protection of sensitive information, including PII and other controlled or restricted data. **Software Engineering and DevSecOps** - Develop maintainable data-engineering code using established software development practices. - Maintain data pipeline code and configuration under version control. - Participate in peer reviews, testing, configuration management, and change-control processes. - Develop automated tests for data transformations and pipelines. - Support CI/CD and automated deployment practices for data-engineering components. - Troubleshoot production data-processing failures and perform root-cause analysis. **Basic Qualifications** - Must be a U.S. Citizen - Must be capable of receiving a Public Trust clearance level. - Must have verifiable accredited education. **Education Requirements** - Bachelor's degree in Computer Science, Data Science, Information Systems, Software Engineering, Computer Engineering, Mathematics, Statistics, or a related technical discipline. **Experience Requirements** - 3–5+ years of professional experience in data engineering, database development, software engineering, BI engineering, or a related technical discipline. - Demonstrated experience designing and developing ETL/ELT processes and data pipelines. - Strong experience with relational databases and SQL. - Experience integrating data from multiple heterogeneous sources. - Experience developing analytical data models, data warehouses, or similar repositories. - Experience troubleshooting data-quality and data-integration issues. **Preferred Qualifications** - Experience with technologies such as Azure, AWS, Snowflake, Databricks, Spark, Airflow, dbt, Kafka, Power BI, Tableau, or similar platforms. **Required Technical Skills** - Advanced SQL and relational database concepts - Oracle, SQL Server, PostgreSQL, or comparable RDBMS technologies - Python or another data-processing/programming language - ETL/ELT development - Data modeling and dimensional modeling - Data warehouse architecture - REST APIs and system integration - Data validation and quality management - Git or comparable version-control systems - Automated testing and CI/CD concepts - Structured and semi-structured data processing For more fresh new jobs, check out [yubhub.co](https://yubhub.co/). ## Skills ### Required - SQL - relational databases - data engineering - ETL/ELT - data modeling - data warehouse architecture - Python - data validation - quality management - Git - automated testing - CI/CD ### Nice to have - Azure - AWS - Snowflake - Databricks - Spark - Airflow - dbt - Kafka - Power BI - Tableau --- Source: [Apply at leidos.wd5.myworkdayjobs.com](https://leidos.wd5.myworkdayjobs.com/en-US/External/job/6314-RemoteTeleworker-US/Data-Engineer_R-00193829-1?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)