drjobs VRS - Database Architect 4

VRS - Database Architect 4

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Richmond - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

The Investment Decision Support team is seeking anexperienced Senior ETL Developer with strong database programmingand analytical skills.
VA210625CAI
Max Vendor Rate 98.19
Candidates will be onsite Tue Wed & Thurs Hybrid schedule

The Virginia Retirement System (VRS) InvestmentDecision Support (IDS) team are the primary data stewards for the InvestmentsDepartment. IDS connects data toinvestment analysis by overseeing all aspects of the data management life cycle. They work closely with investment programs tounderstand their business data and decision support requirements develop toolsto extract valuable and timely information and continuously improve processesand systems to ensure high levels of data integrity and availability. The IDSteam is seeking seasoned SQL development expertise to successfully assist with ongoingbusiness initiatives.

Scope:

The InvestmentDecision Support team is seeking an experienced Senior ETL Developerwith strong database programming and analytical skills to activelyparticipate in the following scope of work:

Assist withoverall ETL Support (development production support documentation) and otherdevelopment efforts as needed. Activities may include:

ETLProduction Support Monitor and maintain existing ETL processes.

CodeData Movement Provide support in the design development and implementationof ETL packages with SSIS.

Development SQL Development support to include creation of stored procedures views etc.

PerformanceTuning Review existing SQL Queries Execution Plans Partitions and Index(s)to determine performance enhancements for long running queries.

DataManipulation Provide alternative options to existing data manipulationtechniques. Examples would be converting Excel manipulation activities intoSSIS packages that reduce process/cycle time of data preparation.

RequiredSkills

7 years of experience in ETL SQL development

Experience with SQL Server Integration Services

Experience writing technical documentation (requirements process mapsetc.)

Excellent communicator and be able to produceclear and concise documentation

Demonstrated experience working in a teamenvironment

Demonstrated experience working independentlywith only high level guidance

Additional Preferred Skills

Experience with data governance best practices/procedures

Investment/financial market industry experience

This position will be on a contract basis for a period ofapproximately 12 months with the potential for an extension.


Required/Desired Skills
SkillRequired /DesiredAmountof Experience7 years of experience in ETL SQL developmentRequired7YearsExperience with SQL Server Integration ServicesRequired7YearsExperience writing technical documentation (requirements process maps etc.)Required7YearsExcellent communicator and be able to produce clear and concise documentationRequired7YearsDemonstrated experience working in a team environmentRequired7YearsDemonstrated experience working independently with only high level guidanceRequired7YearsExperience with data governance best practices/proceduresHighly desired5YearsInvestment/financial market industry experienceHighly desired5Years
Questions
No.QuestionQuestion1Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignmentQuestion2Please list candidates email address.Question3Candidates will be required to work onsite Tue Wed & Thurs Hybrid schedule Does your candidate agree to this schedule Question4In what city and state does your candidate currently resideQuestion5If your candidate is local to the Richmond area please upload supporting documents with proof of address. Question6If your candidate is selected for this role will they be able to pick up there equipment in person and provide proof of identity

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.