VDH T-SQL Programmer Analyst
Posted on :
13-10-2022
Employer Active
1 Vacancy
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Req ID : 1706419
We are looking for a T-SQL Programmer Analyst HYBRID (Min 5 yrs exp) (Webcam or in-Person interviews)
POSITION DESCRIPTION
DIRECT CLIENT Position
Number of positions: 1
Length: 3 Months +
Work Address: Mostly REMOTE / Richmond, VA 23219
Immediate interviews Webcam or In-Person interviews
Please note that this position is mostly REMOTE and may need to go onsite as requested by manager. However, candidate must go to Richmond, VA to pickup equipment on 1st day. Client will NOT ship the equipment.
T-SQL Programmer Analyst
*local candidates strongly preferred
*mostly remote work is available now but needs to be able to come onsite when requested, NO exceptions.
**on selection the candidate must pick up the device in-person and allow about 2-4 hours to complete their work profile set-up at the time of pick up
*extension likely, probably for an additional 6 months or more
Explore and understand the data structure and contents in the data repositories
Assist in the review of data quality, troubleshooting, and data cleanup process
Manage and maintain large volumes of data using manual and automated techniques for investigation and resolution of data quality issues. Assist in gathering and documenting data needs and migration requirements for use in the migration tool design, as well as other reporting measures.
Develop, automate, and maintain data management and data improvement processes using MS SQL SSMS, MS SQL Server Jobs, SSIS, and Tableau.
Utilize SQL server environment for all SQL development activities including data extraction, data quality, transformation and formatting, testing, modification and validation.
Participate in the development of effective solutions and enhancements to increase efficiency of system operations, availability and reporting of high quality data. Routinely review SQL scripts and processes to optimize performance.
Develop QA and performance dashboards measuring data quality dimensions including integrity, validity, accuracy, consistency, and completeness using Tableau or similar software.
Extensive experience implementing relevant, trend-based data quality measurements and assessing scope, frequency and severity of data anomalies using advanced SQL scripts within MS SQL Server Management Studio
Maintain documentation of processes, procedures and manuals
Assist in managing and maintaining the confidentiality and security of the data at all times
Assist in responding to data requests, data analysis using SQL and automation/generation of ad-hoc reports
Provide assistance in various data management activities as assigned
May write reports or facilitate data access by other means as needed, to include SSIS, SSRS, Tableau, etc.
Participates in internal and external meetings.
Candidates must have ALL the "Required" skills in order to be considered for the position. "Desired" or "Highly Desired" skills are a PLUS but may NOT be required.
Skill Matrix
Experience with Business workflow processes
Required / Desired
Amount
of Experience
Strong experience in using T- SQL query language in data management, analysis and reporting in MS SQL server environment
Required
5
Years
Knowledge in development, change management and testing.
Required
3
Years
Strong SQL development experience; this includes advanced SQL query development and SSIS development within SQL server environment
Required
5
Years
Considerable knowledge and experience in database structure and design in the MS SQL server environment.
Required
5
Years
Considerable knowledge of data quality management and procedures. Ability to explore and understand the data structure and contents
Required
5
Years
Effective oral and written communication and interpersonal skills
Required
3
Years
Knowledge of public health disease surveillance and data; experience with reportable disease/health-related information systems & management
Desired
2
Years
Experience using R or SAS
Desired
3
Years
Maintain documentation of processes, procedures and manuals.
Desired
5
Years
Bachelor's degree in IT, Computer Science, and/or equivalent experience and training
Desired
0
Employment Type
Full Time
Key Skills
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.
