Software Engineer - SQL

Software Engineer - SQLJob TitleSoftware Engineer - SQLDurationOpen until filledLocationPortland,OR97204Other LocationDowntown Portland, OregonDescriptionLet’s do great things, togetherFounded in Oregon in 1955, Moda is proud to be a company of real people committed to quality. Today, like then, we’re focused on building a better future for healthcare. That starts by offering outstanding coverage to our members, compassionate support to our community and comprehensive benefits to our employees. It keeps going by connecting with neighbors to create healthy spaces and places, together.Moda values diversity and inclusion in our workplace. We aim to demonstrate our commitment to diversity through all our business practices and invite applications from candidates that share our commitment to this diversity. Our diverse experiences and perspectives help us become a stronger organization. Let’s be better together.We are seeking a SQL Software Engineer in our IT department. This position will be responsible for designing, coding, testing, maintaining, and implementing back-end Microsoft SQL Server T-SQL objects and SSIS packages used to process inbound and outbound transactions with our business partners with a strong focus on stored procedures; work with Business Analysts and other teammates to understand business requirements/processes to provide technical and system support; create technical design documents.Primary Functions:

Maintain existing stored procedures and systems.

Design and develop new stored procedures and systems as part of the implementation of new business requirements.

Work with clients to identify and understand requirements to satisfy business processesrequirements.

Develop detailed technical design specifications, which include file layouts, program functions and job flow.

Implementing and testing database design and functionality, and tuning for performance

Develop and maintain documentation of all objects associated with a project.

Ensure that new systems integrate into current batch cycles.

Participate in 24x7 on-call rotation.

Assist with training and technical support of others on staff.

Maintain a detailed working knowledge of the business unit(s) being supported.

Perform other duties as assigned.

Are you ready to be a betterist?If you’re ready to make a difference that matters, we want to hear from you. Because it’s time to discover what’s possible.Together, we can be more. We can be better.Moda Health seeks to allow equal employment opportunities for all qualified persons without regard to race, religion, color, age, sex, sexual orientation, national origin, marital status, disability, veteran status or any other status protected by law.Required Skills

Bachelor’s degree in a relevant field (Computer Science, Software Engineering, Information Services, or similar) with 3+ years’ experience; or 7+ years of relevant SQL programming experience.

Experience in relational database design, development, and support (MS SQL Server T-SQL preferred)

Experience in complex database objects in T-SQL and/or PLSQL

Experience in systems analysis

Knowledge of basic database security practices.

Experience in health insurance, Cognizant/Trizetto Facets a plus.

Experience with Microsoft SSIS and/or ETL tools a plus.

Experience with Red Gate SQL Tools and Microsoft VSTS/Azure Dev Ops a plus.

Experience with Agile methodologies a plus

Strong interpersonal communication skills needed.

Strong analytical thinking and adept at problem-solving.

Ability to work well under pressure, work with frequent interruptions, and shifting priorities.

Understanding of SDLC methodologies.

Maintain confidentiality and project a professional business image.

Ability to come into work on time and on a daily basis.