Production Data Analyst - Randstad USA
Beaverton, OR 97005
About the Job
Summary
The Production Data Analyst (DA) develops database queries, scripts, tools, and methods to manage data according to client requirements, within defined technical standards, and within time constraints. Emphasis is on ETL procedures. The DA is proficient with relational database concepts and practices, is able to evaluate and write complex SQL queries, and can create and maintain common database objects such as views, stored procedures, and user-defined functions. The DA should be familiar with and able to utilize code management and/or revision control tools and follow standard software development practices. The majority of time is spent developing and refining ETL processes, writing update queries, and writing ad-hoc queries on behalf of clients and stakeholders.
Job 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.
Qualifications
- BS 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 to 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.
The work is almost exclusively data analysis using T-SQL. The position requires basic SQL competency. This is expected to be a short-term position (4 months) and may likely appeal to those early in their careers or between jobs.
They will be reviewing merchant data points within given tables.
location: BEAVERTON, Oregon
job type: Contract
salary: $32 - 36 per hour
work hours: 9am to 5pm
education: Bachelors
responsibilities:
Job 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.
qualifications:
- Experience level: Experienced
- Minimum 1 year of experience
- Education: Bachelors
skills:
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.
It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.