Location: Richland, Washington/Remote Title: Software Engineer III Schedule (FT/PT): Regular Full Time Travel Required: No Clearance: Ability to Obtain North Wind Solutions (NWSOL) is a government contracting small business with operations at military and civilian installations across the United States. The Richland site project's primary focus is providing mission critical support for the Hanford site in the areas of Cyber Security, IT Infrastructure deployment and management to include network operations, End User Support services, Application Engineering with emphasis on software development and support, Records Management, and Project Management for the execution across the spectrum of provided services. POSITION PURPOSE: The Software Engineer III is part of a strong team providing software engineering support to design, develop, operate, and maintain software programs. Software engineering support also includes the assessment, maintenance, documentation, modernization, testing, and implementation functions. ESSENTIAL DUTIES AND RESPONSIBILITIES: The Software Engineer III will provide software support and development at the Hanford site. In this position the Software Engineer will be using their knowledge of data warehousing and architecture to develop ADF, Azure Synapse Analytics, and ETL solutions and automate data extraction, transformation, and loading processes. This includes the development of a mapping that outlines the conversion of data from the source system to the target system. The Software Engineer will also have the knowledge and experience in designing and maintaining SQL Server databases. The Software Engineer III will be responsible for the following tasks: Data Integration and ETL Processes: + Design, develop, and manage data integration workflows using Azure Data Factory (ADF) and Azure Synapse Analytics. + Implement ETL (Extract, Transform, Load) processes to move and transform data between various sources and destinations. + Ensure data quality and integrity throughout the data pipeline. Database Management: + Design and maintain databases, primarily using SQL Server and Azure SQL Database. + Optimize database performance, including indexing, query optimization, and partitioning. + Implement data storage solutions that are scalable, secure, and efficient. Data Modeling and Architecture: + Develop and maintain data models and schemas to support business requirements. + Design and implement data warehouses and data lakes using Azure Synapse Analytics. + Ensure data architecture aligns with best practices and organizational standards. Application Logic and Workflows: + Implement complex business logic and workflows using Power Automate and custom code. + Develop server-side scripts and functions to support application requirements. + Optimize and maintain existing workflows and automation processes. Security and Compliance: + Implement security best practices, including role-based access control (RBAC) and data encryption. + Ensure compliance with organizational policies and industry standards. + Conduct regular security audits and vulnerability assessments. Performance Optimization: + Monitor and optimize the performance of data pipelines, databases, and back-end services. + Troubleshoot and resolve performance bottlenecks and issues. + Implement caching strategies and other performance-enhancing techniques. Testing and Quality Assurance: + Develop and execute unit tests, integration tests, and performance tests for back-end components. + Ensure the reliability and stability of back-end services through rigorous testing. + Collaborate with front-end developers and QA teams to resolve issues. Documentation: + Create and maintain technical documentation, including API documentation, data models, and integration guides. + Document changes and updates to back-end services and workflows. Continuous Improvement: + Stay updated with the latest features and updates in the Power Platform and Azure ecosystems. + Implement best practices for back-end development and deployment. + Participate in code reviews and contribute to the improvement of development processes. Collaboration: + Work closely with front-end developers, business analysts, and other stakeholders to ensure seamless integration and functionality. + Participate in team meetings, contribute to project planning, and progress tracking. + Provide technical guidance and support to other team members. MINIMUM QUALIFICATIONS: Education and Experience: + BA/BS degree in Computer Science, Information Technology, or related field + Minimum of 5 years of related experience in computer application design and/or development + Proficiency in Azure Data Factory, Azure Synapse Analytics, and SQL Server. + Experience with Power Automate, Azure Logic Apps, and custom API development. + Strong programming skills in languages such as C#, JavaScript, and PowerShell. + Knowledge of RESTful APIs, OAuth, and other integration technologies. + Familiarity with data warehousing concepts and best practices. Desired Experience: + Microsoft Certified: Azure Data Engineer Associate + Microsoft Certified: Azure Solutions Architect Expert + Microsoft Certified: Power Platform Developer Associate Skills & Abilities: + Strong problem-solving skills and the ability to analyze complex data integration requirements. + Attention to detail and a methodical approach to testing and debugging. + Excellent verbal and written communication skills. + Ability to explain technical concepts to non-technical stakeholders. + Ability to manage multiple projects and tasks simultaneously. + Strong organizational and time-management skills. Special Requirements: + 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. PHYSICAL DEMANDS: While performing the duties of this job, the employee will be sitting for long periods of time in an office environment, but will also be required to stand, walk, and talk or hear. WORKING ENVIRONMENT: This is a remote work position and/or indoors office environment. North Wind offers a competitive pay and benefits package to include health, life, and disability insurance benefits, 401(k) with company match, generous paid leave and tuition reimbursement for eligible employees. As a company, we are committed to employee wellness, professional development, and work-life balance. We value safety, reliability, and commitment to our people! For more information about our benefits or hiring philosophy, visit the North Wind Career Opportunities Page. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions. The nature of those accommodations will be determined on a case-by-case basis. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact our Helpline +1.208.528.8718 or use the Request for Reasonable Accommodation (https://northwindgrp.com/careers/request-for-reasonable-accommodation-confidential/) form to get assistance. North Wind is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, sex, color, religion, national origin, age, disability, veteran status, genetic data, religion, or other legally protected status. All qualified applicants will receive consideration for employment without regard to their protected veteran status and will not be discriminated against on the basis of disability. Proof of citizenship will be required as a condition of employment. Candidates may be required to obtain and hold a Secret or Higher US Government Clearance.