Software Engineer II- Data

OSC Technical Solutions is seeking a Software Engineer II to work with Data Stewards in defining and documenting data, building data pipelines, and migrating data into the Enterprise Data Management environment. The role involves analyzing existing data sources, collaborating with stakeholders, and ensuring compliance with safety and environmental obligations.

Responsibilities:

• Analysis and verification of existing data sources
• Create detailed and well-structured data and data relationship diagrams
• Business process analysis and understanding of flow charts, data flow diagrams, and system integration diagrams
• Collaborate with business stakeholders and end-users to elicit and document data requirements
• Assist in the implementation of IT solutions
• Collaborate with quality assurance teams to design test cases, scenarios, and test plans based on documented requirements
• Support of required status reports and documents including weekly reports
• Perform all 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)
• Work directly with all levels of software engineers, project managers, managers, customers, and software quality engineers
• Solve problems that are difficult but typically not complex
• Perform other duties as appropriate and as assigned

Requirements:

• Bachelor's Degree (Computer Science, Mathematics, Management Information Systems, Business or similar) and 2 or more years of IT experience, or an equivalent combination of education, training and experience
• Must pass pre-employment background check
• Must pass pre-employment drug screening
• Applicants are required to have REAL ID ACT compliant documentation at time of hire and nothing on record that would prohibit you from gaining access to Department of Energy sites
• Ability to obtain and maintain a U.S. Government Clearance
• You are analytical and solution oriented
• You have the vision and mindset to identify, handle, and resolve problems quickly before they become recurring issues
• You have the ability to manage multiple projects from beginning to completion; this is important for all assignments
• You possess excellent written and verbal communication skills; these are crucial for working with all collaborators
• You must have the ability to understand the team's challenges and develop solutions
• You have proven technical writing experience
• You have proven strong organizational skills and can work under tight deadlines
• You are a lifelong learner who displays adaptability in the face of changing circumstances
• You have a honed sense of professionalism and analytical skill around office procedures, business processes, and record-keeping
• You have the ability to navigate problems and work independently, with some general supervision
• You have a proven ability to learn new computer programs quickly
• 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
• Experience with legacy data and reporting environments such as Microsoft SQL Server, Oracle, Crystal Reports, SSIS
• Experience with general data and database design concepts such as master data, tables vs views, normalization, data quality and security, etc
• Experience with medallion architecture
• Experience with cloud environments, preferably Microsoft Azure
• Experience with Microsoft cloud data tools such as Synapse, Purview, Notebooks
• Familiarity working in a Nuclear Quality Assurance (NQA-1) or similar regulatory environment