Note: The job is a remote job and is open to candidates in USA. OSC Technical Solutions is hiring a Software Engineer II - Data to support data asset identification, documentation, and integration in an Enterprise Data Management environment. The role assists with data pipelines, data validation, data quality, data migration, and cloud data platform initiatives under the guidance of senior team members.
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
Skills
- 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
- 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
- Bachelor's Degree and 2 or more years of experience, or an equivalent combination of education, training and experience
- Must have identification compliant with the Real ID Act at time of hire
- Must be able to obtain Department of Energy PIV badge
- Working knowledge of Nuclear Quality Assurance (NQA-1) requirements or similar regulated environments is preferred
- 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
Benefits
- Paid holidays
- Paid time off
- 401k with employer match
- Dental benefits
- Vision benefits
- Health insurance plans through the Federal Employee Health Benefits (FEHB) program
- Life benefits
- Disability benefits
- Remote work arrangement
Company Overview