Ssis Developer Jobs in Portland, OR (NOW HIRING)

Senior Software Developer (Hybrid)
Our client, a leading Pacific Northwest utility provider committed to public service and environmental preservation, is looking for a Senior Software Developer for their Vancouver, Washington location. This position is within the Information Technology Operational Technology Organization, Application Services, Critical Business Systems Application Support and Development. Duties include developing and interpreting policies, procedures, and strategies governing agency-wide IT service delivery, while providing expert technical advice to management on critical IT issues. Shepherding the integration of IT programs and services, resolving complex interoperability issues, and designing systems that optimize the existing architecture. Developing clean software code, automating business processes, and managing project documentation. Working within an Agile development team, adhering to strict testing and deployment procedures to meet current and future business requirements. The ideal candidate has a willingness to learn new technologies and stay updated with industry trends and has a strong attention to detail, excellent time management skills and the ability to handle multiple projects and deadlines at the same time.
This hybrid position is a one-year renewable contract that includes employee benefits! If this opportunity is well-aligned with your experience and goals, we would love to hear from you!
Key Responsibilities for Senior Software Developer:

• System Architecture, Development: Design, implement, and maintain new features for the power scheduling application, adhering to established Clean Architecture and Domain-Driven Design (DDD) principles. Build and maintain data models and mapping relationships between several systems to support power flow studies and other automation efforts, aligning models where practical.
• Back-End Development: Build and maintain CQRS (Command Query Responsibility Segregation) command and query handlers in the application layer. Implement and manage domain event propagation and integrate scheduled jobs.
• Front-End Development: Develop and extend Angular components and services for sophisticated, operator-facing and customer-facing web portals used for data entry and operational monitoring.
• Databases: Write and optimize complex SQL Server queries, stored procedures, and schema migrations within a multi-schema database environment.
• Code Quality and Testing: Contribute to rigorous peer code reviews with a focus on correctness, performance, and adherence to architectural patterns. Design, develop, test and deploy n-tier C# .Net applications utilizing the .Net 10 framework.
• System Integration and Support: Debug production and pre-production issues across the full stack (API, application layer, data layer, SQL Server). Collaborate with integration teams on REST and WCF service contracts for data exchange. Identify or resolve problems in applications at all system tiers (Application, Server, Database, and Network).

Requirements/Qualifications for Senior Software Developer:

• A degree in Computer Science, Information Technology, Engineering or a directly related field is preferred.
  • 8 years of experience is required with an applicable bachelor’s or associate degree.
  • 10 years of experience is required without an applicable bachelor’s or associate degree or no degree.
  • Applicable Certifications may count for 1 year of experience.
• Experience must include direct work experience in information Technology performing System Administration.

• 7 years of the following experience:
  • Developing in C# leveraging the latest features of .NET 10 to build high-performance, secure, and maintainable enterprise applications.
  • Designing and implementing RESTful API’s using modern standards, including expertise in middleware, authentication/authorization protocols, and end-to-end API lifecycle management.
  • Use TypeScript to maintain or build scalable applications capable of using at least one major frontend framework (e.g., React, Angular, or Vue.js).
  • Strong adherence to Object-Oriented Design (OOD) and SOLID principles to create clean, scalable, and maintainable code.
  • Expertise in designing and maintaining Microsoft SQL Server databases. This includes writing and optimizing complex T-SQL queries, stored procedures, and strategically implementing indexes for performance.
  • Experience with data access frameworks such as Entity Framework, NHibernate, or ADO.NET for database communication.
  • Proficient in Extract, Transform, Load (ETL) processes and experience with tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) for data migration and integration from various sources (e.g., flat files, Excel, other systems).
  • Proficient with Git and common branching strategies for collaborative development.
  • Experience with implementing and maintaining Continuous Integration/Continuous Deployment (CI/CD) pipelines using tools like Azure DevOps and Jenkins
  • Expertise in using Microsoft Visual Studio IDE for development, debugging, and testing.
  • Familiarity with using SQL Server Data Tools (SSDT) in Visual Studio to manage database schemas as code.
  • Experience using Microsoft Office’s large suite of applications, including specifically PowerPoint, Visio, and Project.
  • Experience using SharePoint for enhanced document sharing and collaboration.
  • Work in conjunction with other IT development professionals and support teams.
  • Strong verbal and written communication skills, with the ability to clearly articulate technical concepts to both peers and external customers.

**We are unable to accommodate corp. to corp. candidates**
About Motus Recruiting and Staffing, Inc:
Founded in 2006, Motus is an award-winning recruiting and staffing firm in the Pacific Northwest, specializing in professional services and technology solutions. We are a group of people who not only recognize the importance of representation, but actively fight for diversity, equity, and inclusion in the recruitment process. Our goal is to educate organizations on the importance of DEI when hiring, promoting, and supporting diverse employees. We are calling organizations to demonstrate their commitment to DEI by being intentional about who they hire.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, disability or protected veteran status.
ED/BH 14222
Job ID: 14222