Software Engineer II – Data

This is a fully remote position, open to applicants in United States.

📋 Description

• Design and uphold data models, mappings, and relationship diagrams.

• Construct, execute, and sustain data pipelines and integration processes.

• Assess and validate source data for completeness, accuracy, and relevance.

• Collect, document, and clarify data requirements in collaboration with business stakeholders and team members.

• Conduct data quality checks, testing, and validation procedures.

• Set up and manage cloud-based data services and environments under the guidance of senior engineers.

• Implement data security, governance, and data handling protocols.

• Draft and maintain technical documentation and status reports regarding processes.

• Diagnose data-related issues and facilitate continuous improvement efforts.

• Execute tasks safely and in compliance with ISMS/EMS standards.

• Undertake other assigned responsibilities.

⛳️ Requirements

• Bachelor’s Degree and a minimum of 2 years of relevant experience, or an equivalent mix of education, training, and experience.

• Proficient understanding of relational databases, data models, ETL/ELT processes, data quality, and lifecycle management.

• Practical knowledge of SQL and scripting/programming languages utilized in data engineering tasks.

• Familiarity with cloud-based data platforms and services.

• Comprehension of data security, governance, and compliance prerequisites.

• Acquainted with data quality validation, testing methodologies, and troubleshooting approaches.

• Knowledge of flowcharts, data flow diagrams, and system integration principles.

• Capability to pass a background check and drug screening.

• Must possess identification compliant with the Real ID Act at the time of hiring.

• Must be able to acquire a Department of Energy PIV badge.

• Proficient in Microsoft Office and standard business software applications.

• Ability to travel by vehicle or aircraft and safely operate a motor vehicle.

• Preferred knowledge of Nuclear Quality Assurance (NQA-1) standards or similar regulated environments.

• Preferred experience with Databricks, Delta Lake, notebooks, workflows, and data transformation methods.

• Preferred familiarity with programming in Python for data engineering, automation, data quality validation, and integration.

• Preferred experience with Azure Data Lake Storage, Azure Data Factory, Microsoft Fabric, or similar technologies.

• Preferred understanding of AI-ready data curation, profiling, cleansing, normalization, metadata management, data quality monitoring, and preparation of structured and unstructured data.

• Preferred experience in data governance, cataloging, lineage, and stewardship.

• Preferred familiarity with analytics, reporting, business intelligence, and AI/ML data-set design.

• Preferred experience with large-scale structured, semi-structured, and unstructured data sources.

• Preferred experience with SSRS, Power BI, Tableau, or Crystal Reports.

• Preferred experience with SQL Server, Oracle, or other enterprise relational database management systems.

• Preferred familiarity with data warehousing, dimensional modeling, and master data management.

• Preferred experience in regulated, security-conscious, or highly governed environments.

• Preferred knowledge of Agile methodologies, DevOps practices, and Git or Azure DevOps.

🏝️ Benefits

• Paid holidays.

• Paid time off.

• 401k with employer match.

• Dental insurance.

• Vision insurance.

• Health insurance plans through the Federal Employee Health Benefits (FEHB) program.

• Life benefits.

• Disability benefits.