Paradigm Information Services, Inc.
Paradigm Information Services, Inc. is hiring: Data Analyst in Portland
Paradigm Information Services, Inc., Portland, OR, United States
Job Description
Job Description
Requirements
Benefits
This is a remote position.
Paradigm is searching for a Data Analyst to support our client, a global leader in the legal industry. The Data Analyst develops database queries, scripts, tools, and methods to manage data according to client requirements, within defined technical standards, and within time constraints. The Data Analyst is proficient with relational database concepts and practices, can evaluate and write complex SQL queries, and can create and maintain common database objects such as views, stored procedures, and user-defined functions. The Data Analyst 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.
Type: 4 month contract
Location: Remote, USA
Benefits: Paradigm offers medical, dental, vision, life, 401K, PTO, and sick days.
As a Data Analyst you will:
- 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
Our skills and experience wish list includes:
- BS Computer Science or related discipline, or equivalent industry experience.
- Must have TSQL 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.
Benefits
Paradigm offers medical, dental, vision, life, 401K, PTO, and sick days.
About Us, Paradigm
Want to love Mondays? It's possible when you love what you do. Paradigm is a staffing solutions firm dedicated to finding the perfect job for candidates. We're connected with some of the most innovative tech companies around, giving our employees that competitive edge needed in today's job market.
Paradigm Information Services does not discriminate based on race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits.