Software Engineer II- Data

Position Overview

This position supports the identification, documentation, and integration of data assets within the Enterprise Data Management (EDM) environment. The Data Engineer II assists with developing and maintaining data pipelines, preparing and validating data for business use, and implementing data management practices using established tools, standards, and procedures. Working under the guidance of senior team members, this position contributes to data migration, data quality, and cloud data platform initiatives while gaining experience with enterprise data engineering practices and technologies.

Major Activities (Typical Duties/Responsibilities)

Assist in creating and maintaining data models, data mappings, and data relationship diagrams based on established standards.

Support the development, implementation, and maintenance of data pipelines and data integration processes.

Analyze and validate source data for completeness, accuracy, and relevance, escalating issues as appropriate.

Collaborate with business stakeholders and team members to gather, document, and clarify data requirements.

Perform routine data quality checks, testing activities, and validation procedures using established methods and tools.

Assist with configuring and administering cloud-based data services and environments under direction from senior engineers.

Apply data security, governance, and data handling practices in accordance with organizational standards and regulatory requirements.

Prepare and maintain technical documentation, process documentation, and status reports.

Participate in troubleshooting data-related issues and support continuous improvement activities.

Perform work safely and in compliance with environmental obligations using the core functions and core elements of the Integrated Safety Management System/Environmental Management System (ISMS/EMS).

Perform other duties as appropriate and assigned.

Knowledge/Skills/Abilities

Working knowledge of data engineering concepts including relational databases, data models, ETL/ELT processes, data quality, and data lifecycle management.

Working knowledge of SQL and scripting/programming languages used for data engineering tasks.

Familiarity with cloud-based data platforms and services.

Understanding of data security, governance, and compliance requirements and the ability to apply established controls in daily work.

Familiarity with data quality validation, testing methodologies, and troubleshooting techniques.

Understanding of flowcharts, data flow diagrams, and system integration concepts.

Working knowledge of Nuclear Quality Assurance (NQA-1) requirements or similar regulated environments is preferred.

Communicates technical information clearly to team members and stakeholders.

Takes responsibility for assigned work and appropriately escalates issues, risks, or blockers.

Demonstrates attention to detail and ability to follow established standards, processes, and procedures.

Ability to research, organize, and analyze information with guidance from senior team members when needed.

Works effectively both independently on assigned tasks and collaboratively as part of a team.

Demonstrates strong organizational, documentation, and follow-up skills.

Effectively manages multiple priorities in a fast-paced environment.

Displays professionalism and collaborates effectively with employees, customers, and business partners.

Demonstrates willingness to learn new technologies, tools, and data engineering practices.

Proficient in Microsoft Office products and standard business software applications.

Handles confidential and sensitive information appropriately.

Physical Abilities

Sufficient fine motor skills for the use of computers, calculators with an ability to withstand repetitive keyboarding for extended periods of time.

Visual and communications ability adequate to perform the essential functions of the job.

Ability to kneel, bend and twist at the waist on an occasional basis.

Ability to reach below shoulder height with regular frequency (desk position) and at or above shoulder height on occasion.

Ability to push, pull, carry, and lift objects weighing up to 10 pounds on a regular basis, and greater weights on an occasional basis.

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

Minimum Requirements

Bachelor's Degree and 2 or more years of experience, or an equivalent combination of education, training and experience.

Ability to pass a background and drug screening.

Must have identification compliant with the Real ID Act at time of hire.

Must be able to obtain Department of Energy PIV badge.

Preferred Qualifications

Experience developing and maintaining data pipelines using Databricks, including Delta Lake, notebooks, workflows, and data transformation processes.

Experience programming in Python for data engineering, automation, data quality validation, and data integration activities.

Experience supporting modern cloud-based analytics and data engineering platforms, such as Azure Data Lake Storage, Azure Data Factory, Microsoft Fabric, or similar technologies.

Knowledge of AI-ready data curation practices, including data profiling, cleansing, normalization, metadata management, data quality monitoring, and preparation of structured and unstructured data for machine learning and generative AI use cases.

Experience supporting implementation of data governance, data cataloging, lineage, and data stewardship practices.

Familiarity with designing and optimizing data sets for consumption by analytics, reporting, business intelligence, and AI/ML solutions.

Experience working with large-scale structured, semi-structured, and unstructured data sources.

Experience developing or supporting enterprise reporting solutions using legacy and modern reporting technologies, including platforms such as SSRS, Power BI, Tableau, or Crystal Reports.

Experience with SQL Server, Oracle, or other enterprise relational database management systems.

Familiarity with data warehousing, dimensional modeling, and master data management concepts.

Experience working in regulated, security-conscious, or highly governed environments.

Knowledge of Agile methodologies, DevOps practices, and version control tools such as Git or Azure DevOps.

Pay Range : $94,714.00-149,575.00

Benefits: OSC Technical Solutions offers excellent benefits for eligible employees. Benefits include paid holidays, paid time off, 401k with employer match, dental, vision, health insurance plans through the Federal Employee Health Benefits (FEHB) program, as well as life and disability benefits.

OSC Technical Solutions does not discriminate, and the company provides equal employment opportunity for all employees and applicants without regard to race, religion, color, sex, gender, sexual orientation, national origin, citizenship status, age, marital status, pregnancy or parenthood, handicap or disability, genetics, veteran status or any other legally protected characteristic. OSC Technical Solutions adheres to all federal, state and local laws regarding equal employment opportunity and will not discriminate against you in violation of these laws. OSC Technical Solutions reserves the right to apply CIRI Shareholder preference to qualified Shareholders in employment and advancement opportunities.

OSC Technical Solutions participates in E-Verify. We will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization.

Reasonable Accommodation:

OSC Technical Solutions will provide reasonable accommodations, according to applicable state and federal laws, to all qualified individuals with physical or mental disabilities. In compliance with the ADA Amendments