• 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.

Due to our status as a federal contractor operating within the State of Washington, all applicants and employees must adhere to federal law, which classifies cannabis as a Schedule I controlled substance.

While Washington State’s RCW 49.44.240 (which generally prohibits employers from discriminating against an applicant based on their lawful use of cannabis off-site and during working hours) is state law, it does not supersede federal requirements.

Zero-Tolerance Policy and Disqualification

• Prohibition: The use, possession, or distribution of cannabis is strictly prohibited for all employees, regardless of state law.
• Testing: Applicants will be subject to pre-employment drug screening that includes testing for cannabis.
• Disqualification: A positive test result for cannabis will result in immediate disqualification from consideration for employment, as mandated by our federal contract obligations.

All applicants must be able to comply with all federal regulations, including those concerning controlled substances, as a condition of employment.

In compliance with Homeland Security Presidential Directive 12 (HSPD-12) and Department of Energy (DOE) Hanford Field Office (HFO) direction, employees issued initial badges on or after September 1st, 2025, are required to obtain and maintain a HSPD-12 Personal Identity Verification (PIV) Credential. To obtain this credential, new employees must successfully complete and pass a federal background check investigation. This investigation encompasses multiple areas of eligibility and includes a declaration of illegal drug activities, including use, supply, possession, or manufacture within the last year. This includes marijuana and cannabis derivatives, which are still considered illegal under federal law, regardless of state laws.