SQL Data Analyst

$66,560 - $74,880/Yr

Vanderhouwen - Beaverton, OR

Full-time - Entry Level

Remote - Beaverton, OR

Administrative and Support Services

About the position

The SQL Data Analyst (DA) is responsible for developing database queries, scripts, tools, and methods to manage data according to client requirements while adhering to defined technical standards and time constraints. The role emphasizes ETL procedures and requires proficiency in relational database concepts, complex SQL queries, and the creation and maintenance of common database objects. The DA will spend the majority of their time refining ETL processes and writing queries for clients and stakeholders in a remote work environment.

Responsibilities

• Develop and maintain ETL procedures according to client specifications and within defined technical standards.
• Develop and maintain database stored procedures, user-defined functions, views, triggers, and other common database objects.
• Write custom and ad-hoc SQL queries and update queries.
• Follow prescribed software development standards, processes, procedures, methodologies, etc., according to departmental policies and conventions.
• Interact and correspond professionally with team members, project management, clients, and other stakeholders.
• Account for and accurately log time against project work.

Requirements

• BS in Computer Science or related discipline, or equivalent industry experience.
• 2+ years hands-on experience with MS SQL Server, 2008 R2 or higher, as a developer or DBA.
• Strong SQL skills, able to create and evaluate complex SQL statements involving numerous tables and complex relationships.
• Ability to work in an environment with deadlines and shifting priorities.
• Basic understanding of and experience with query performance tuning.
• Experience developing and maintaining ETL procedures.
• Experience with SSIS preferred.
• Ability to communicate effectively, both verbally and in writing; able to adjust for intended audience.
• Fluency in English.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• Short-term disability
• Long-term disability
• 401(k) matching