Job Details:
Job Title: T-SQL Programmer Analyst
Job Location: Richmond, VA 23219
Contract Duration: 11 Months (Possibility of extension)
Interview Type: Web Cam Interview Only
Complete Description:
candidates strongly preferred, Remote work is available now but needs to be able to come onsite when requested, NO exceptions.
Responsibilities:
- 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 always managing and maintaining the confidentiality and security of the data
- 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
- Collaborates with client's peers to ensure formatted data received meets reporting and system requirements within the Office of Epidemiology (OEPI).
- May write reports or facilitate data access by other means as needed, to include SSIS, SSRS, Tableau, etc.
- Participates in internal and external meetings.
Required Skills:
- Strong experience in using T- SQL query language in data management, analysis and reporting in MS SQL server environment
- Knowledge in development, change management and testing.
- Strong SQL development experience: this includes advanced SQL query development and SSIS development within SQL server environment
- Considerable knowledge and experience in database structure and design in the MS SQL server environment.
- Considerable knowledge of data quality management and procedures. Ability to explore and understand the data structure and contents
- Effective oral and written communication and interpersonal skills.
Desired Skills:
- Experience with XML
- Knowledge of public health disease surveillance and data; experience with reportable disease/health-related information systems & management
- Maintain documentation of processes, procedures and manuals.
- Experience using R or SAS
- Experience with Health Level 7 (HL7) messaging standards for electronic lab and electronic case reporting
- Experience with reportable disease/health-related information systems & management
- Bachelor's degree in IT, Computer Science, and/or equivalent experience and training
- Ability to analyze and develop efficient solutions to data problems in a logical and systematic manner.
#CB, #DICE
What We Do
vTech solution Inc. is a Managed IT Services firm based out of Washington DC with a primary focus on Cloud Computing and Professional Services.
vTech was incorporated in January 2006 under the Commonwealth of Virginia as an IT Professional firm. vTech has experienced constant growth over the years and has developed various IT service capabilities by diversifying its service portfolio to IT Consulting, Enterprise Software Solutions, and Cloud Computing Services to provide complete IT Managed Service offerings.
Currently, we are one of the nation’s fastest-growing private companies and have been consecutively named in INC. 5000 list for the past five years.
Our focus is to enhance the level of success for our clients by efficiently offering the highest quality services. We use the most advanced IT technologies and practices to add value to our client services.
We specialized in core competencies which include Cloud solutions, Network Services, Security Solutions, Customized Application Services, System Integration, AI Tools, and Professional IT Services such as Project Management, Staff Augmentation, and IT Infrastructure Services.
vTech Solution's unwavering dedication to results defines our brand. Our time-tested management processes, quality control methods, and state-of-the-art work environment ensure that our clients' most complex projects are delivered on time, on budget, and message.
"vTech encourages and supports a healthy work-life balance for its employees. It offers a workplace where you can work with dignity and independence. vTech offers a competitive salary and comprehensive benefits package. We offer tuition and training expense reimbursement and a flexible work schedule."