Data Warehouse Administrator job vacancy

Vacancy expired!

CRI Advantage is looking for a Data Warehouse Administrator IV to work onsite in Carson City, NV. The Department of Motor Vehicles (DMV) has a thick client application developed using Power Builder, COBOL, DB2, CICS, VB.NET, ASP.NET and MS SQL Server. The DMV application is used by over 1200 internal users and thousands of external users. Nevada law makers approved funding to hire contractor to cleanse the DMV data in preparation of the modernization/transformation effort. In an effort to cleanse data, DMV will be staging the data in an isolated MS SQL Server environment to ascertain if the data is valid, complete, and is conversion ready.

Document changes and follow protocols established by Nevada DMV.
Follow guidelines established by Nevada DMV.
Participate in JAD sessions for data cleansing project. Work with different user/user groups to gather and document business rules.
Translate and transform business rules into workflows
Log time using DMV Time tracking software (Remedy) on a daily basis
Provide status reports as required by DMV personnel

Requirements

Must have a Bachelor’s degree in computer science, or any other equivalent degree with a minimum of seven (7) years of
programming experience. Ideal candidate will have many years’ experience in Informatica Data Quality V10 with strong SQL background
Experience administering Informatica Data Quality V10.x and /Power Center
Demonstrated ability to monitor, manage, and tune Data Quality environment
Demonstrated ability to debug and troubleshoot issues with Data Quality installation and services
Strong knowledge of best practices related to development, deployment, and scheduling of data quality workflows, mapplets, and applications.
Demonstrated ability to translate and transform business requirements/rules into workflows
Must have experience working in Medium to Large scale data quality environments.
Expertise in performance tuning to improve execution times
Expertise in designing conceptual, logical and physical designs for various database objects
Experience in writing complex SQL queries in a SQL Server environment.
Must possess strong knowledge of relational database concepts
Must have experience and skills to provide adequate information for users to understand and address exceptions
Must have experience working in a team based development environment.
Excellent at creating stored procedures, functions, packages, database triggers and other database objects using SQL
Expertise in troubleshooting and debugging skills
Excellent analytical and communication skills required to effectively work in the field of applications development and maintenance.
Excellent at Understanding Integration Technologies and Domains and work flows.
Must have good communication, documentation and user requirement gathering skills.

Employee Job Functions Employee Job Functions are physical actions and/or working conditions associated with the position. These functions may also constitute essential functions for the job position which the employee must be able to fulfill, with or without reasonable accommodation. The information provided below is to help describe the job so that the applicant has a reasonable understanding of the job duties/expectations. An applicant's ability to perform these actions will be discussed and workplace accommodations may be made on a case-by-case basis following an individualized assessment of the applicant and other considerations, including but not limited to any governing safety standards.

Stooping, kneeling, crouching, turning and twisting - Never

Ability to reach, feel and handle items – Occasionally

Moving about to accomplish tasks or moving from one worksite to another - Never

Moderate noise (i.e. business office with computers, phone, and printers, light traffic) - Constantly

Repeating motions that may include the wrists, hands and/or fingers - Occasionally

Operating motor vehicles - Never

Physical Demands – Sedentary work that primarily involve sitting/standing

Moving self in different positions to accomplish tasks in various environments including tight and confined spaces - Never

Ability to sit at a computer terminal for an extended period of time - Constantly

Adjusting or moving objects up to 25 pounds in all directions - Never

Communicating with others to exchange information - Constantly

Operating machinery and/or power tools - Never

Regular, predictable attendance is required - Constantly

Benefits

Great things happen when you have the CRI Advantage!CRI has a family-oriented company culture and is family-owned. Our management team believes employee growth is as equally import to company growth and offers many types of learning opportunities. We work on unique projects including supporting missions involving national security, energy research, law enforcement, transportation, and health and welfare. We are headquartered in Boise, ID with offices in Idaho Falls and DC. Our corporate mission from the very beginning has been to make a positive difference in people’s lives.

CRI Advantage provides flexible benefit packages to fit employee and family needs. Benefits are effective from the first day of employment.

Medical (PPO and HDHP plans), Dental, Vision, STD, LTD, Life and AD&D
Access to Flexible Spending Accounts (FSA) and Health Savings Accounts (HSA)
Paid Time Off (PTO) accruals, Paid Holidays, and for some roles – sick leave
401(k) with employer match
Employee Assistance Program (EAP)
Discount Rewards Program
Free technical and professional training with access to over 8,000 classes
Credit Union Membership
Employee Wellness Program

CRI Advantage is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. CRI Advantage is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. To request reasonable accommodation, contact Human Resources at or

Vacancy expired!

ID	#6158214
State	Nevada
City	Carsoncity
Job type	Not Specified
Salary	USD TBD TBD
Source	CRI Advantage, Inc.
Showed	2020-11-27
Date	2020-11-25
Deadline	2021-01-24
Category	Et cetera
Create resume

Job Details

Data Warehouse Administrator

Related jobs

»Data-Analytics Sales Specialist - Energy

»Senior Microsoft M365 Administrator

»2024 GDIA Data Scientist / Supplemental

»Technical Architect Data Center - Product Development & Integration

»Data Scientist, Product

»Senior Contracts Administrator

»Lead Systems Quality Assurance Analyst - Data Office - Remote