T-SQL Programmer Analyst

2 weeks ago


Richmond, United States Logix Shapers Full time
Job DescriptionJob Description

T-SQL Programmer Analyst (740599)

Location: Richmond, VA Remote

Visa: No H1B

Complete Description:

*local candidates strongly preferred

*remote work is available now but needs to be able to come onsite when requested, NO exceptions

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 VDH 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.

Skill 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

Strong experience with XML Required 3 Years

Knowledge of public health disease surveillance and data; experience with reportable disease/health-related information systems & management Desired 2 Years

Maintain documentation of processes, procedures and manuals. Desired 5 Years

Experience using R or SAS Desired 3 Years

Experience with Health Level 7 (HL7) messaging standards for electronic lab and electronic case reporting Desired 2 Years

Experience with reportable disease/health-related information systems & management Desired 2 Years

Bachelor's degree in IT, Computer Science, and/or equivalent experience and training Desired

Ability to analyze and develop efficient solutions to data problems in a logical and systematic manner Desired

Please reach me out at: moumita@logixshaper.com


  • SQL Programmer Analyst

    2 months ago


    Richmond, United States Crescens Full time

    Job Title: SQL Programmer Analyst Location: Richmond, VA Duration: 9+ Months Note: Local Richmond, VA candidates strongly preferred Must come onsite to Richmond, VA to pick up laptop Job Responsibilities: Create new T-SQL reports, update existing reports, migrate/convert legacy data/pages to a more dated format. Update Business Rules and Validation as...


  • Richmond, United States Crescens Full time

    Job Title: SQL Programmer Analyst Location: Richmond, VA Duration: 9+ Months Note: Local Richmond, VA candidates strongly preferred Must come onsite to Richmond, VA to pick up laptop Job Responsibilities: Create new T-SQL reports, update existing reports, migrate/convert legacy data/pages to a more dated format. Update Business Rules and Validation as...


  • Richmond, United States Crescens Full time

    Job Title: SQL Programmer Analyst Location: Richmond, VA Duration: 9+ Months Note: Local Richmond, VA candidates strongly preferred Must come onsite to Richmond, VA to pick up laptop Job Responsibilities: Create new T-SQL reports, update existing reports, migrate/convert legacy data/pages to a more dated format. Update Business Rules and Validation as...


  • Richmond, United States ZIRLEN TECHNOLOGIES INCORPORATED Full time

    REQUIREMENT C# Developer/Programmer Analyst Location: Richmond, Virginia 23219 Long term contract Please submit Local to Virgina or nearby candidates. Interview Type: Web Cam Interview Only Work Arrangement: Hybrid Seeking an experienced C# Developer/Programmer Strong knowledge of C#, prototyping, reusability, object-oriented design and development, code...


  • Richmond, United States Trillium Staffing Full time

    Trillium Professional is now seeking a .Net/SQL Server Programmer Analyst in Richmond! Works to develop and maintain multiple messaging team .net applications. Specific Task(s): • Develop, Maintain And Enhance ASP.NET/MVC and .NETCore applications • Assist in development of a new ASP.NET MVC and .NET Core application with Entity Framework Codefirst, C#,...


  • Richmond, United States Trillium Staffing Full time

    Trillium Professional is now seeking a .Net/SQL Server Programmer Analyst in Richmond! Works to develop and maintain multiple messaging team .net applications. Specific Task(s): • Develop, Maintain And Enhance ASP.NET/MVC and .NETCore applications • Assist in development of a new ASP.NET MVC and .NET Core application with Entity Framework Codefirst, C#,...


  • Richmond, United States Datawize Technologies LLC Full time

    **Job Title: C# Developer/Programmer Analyst** **Job Location: Richmond, Virginia 23219** **Job Type: Contract** **Job Duration: 12 Month** - Broad foundation of knowledge and experience in information technology; - Strong knowledge of C#, prototyping, reusability, object oriented design and development, code generation, construction, testing,...


  • Richmond, Virginia, United States ZIRLEN TECHNOLOGIES INCORPORATED Full time

    REQUIREMENTC# Developer/Programmer AnalystLocation: Richmond, Virginia 23219 Long term contractPlease submit Local to Virgina or nearby candidates.Interview Type: Web Cam Interview OnlyWork Arrangement: HybridSeeking an experienced C# Developer/ProgrammerStrong knowledge of C#, prototyping, reusability, object-oriented design and development, code...


  • Richmond, Virginia, United States ZIRLEN TECHNOLOGIES INCORPORATED Full time

    REQUIREMENTC# Developer/Programmer AnalystLocation: Richmond, Virginia 23219 Long term contractPlease submit Local to Virgina or nearby candidates.Interview Type: Web Cam Interview OnlyWork Arrangement: HybridSeeking an experienced C# Developer/ProgrammerStrong knowledge of C#, prototyping, reusability, object-oriented design and development, code...


  • Richmond, United States TalentBridge Full time

    Job Title: C# Developer/Programmer Analyst Job Summary: An experienced C# Developer/Programmer Analyst is sought to develop and maintain business applications using emerging technologies. The role involves leading the maintenance, development, and deployment of IT initiatives, enhancing existing services, and creating new virtual services. The position...


  • Richmond, United States TalentBridge Full time

    Job Title: C# Developer/Programmer Analyst Job Summary: An experienced C# Developer/Programmer Analyst is sought to develop and maintain business applications using emerging technologies. The role involves leading the maintenance, development, and deployment of IT initiatives, enhancing existing services, and creating new virtual services. The position...


  • Richmond, United States Precision Solutions Full time

    Overview: **Server Programmer Analyst IV -.NET/SQL** Hybrid | Richmond, VA | 2-3 Days a Week Onsite US Citizenship Required - Must have a valid Drivers License - (_**_1099 Contract Only: _**_5/20/2024 - 6/30/2024 // Expected Contract Extension: 6-12+ Months)_ **Summary** **Responsibilities** - Consume and/or create Web Services **Requirements**: -...


  • Richmond, Virginia, United States V-Soft Consulting Group Full time

    C# Developer/Programmer Analyst Primary Location: Richmond, Virginia V-Soft Consulting is currently hiring for a C# Developer/Programmer Analyst for our premier client in Richmond, Virginia. Education and Experience " Bachelor's degree in computer programming, computer science, information technology, or equivalent/related field Thorough knowledge...


  • Richmond, United States nLeague Full time

    C# Developer/ Programmer Analyst Location: 102 Governor StreetSuite 120 Room 117, Richmond, Virginia 23219 Client: SCB Job Id: 738014 Duration: 12 Months Job Description: This position requires: Broad foundation of knowledge and experience in information technology; Strong knowledge of C#, prototyping, reusability, object oriented design and development,...


  • Richmond, United States nLeague Full time

    C# Developer/ Programmer Analyst Location: 102 Governor Street Suite 120 Room 117, Richmond, Virginia 23219 Client: SCB Job Id: 738014 Duration: 12 Months Job Description: This position requires: Broad foundation of knowledge and experience in information technology; Strong knowledge of C#, prototyping, reusability, object oriented design and development,...


  • Richmond, United States nLeague Full time

    C# Developer/ Programmer Analyst Location: 102 Governor StreetSuite 120 Room 117, Richmond, Virginia 23219 Client: SCB Job Id: 738014 Duration: 12 Months Job Description: This position requires: Broad foundation of knowledge and experience in information technology; Strong knowledge of C#, prototyping, reusability, object oriented design and development,...


  • Richmond, United States nLeague Full time

    C# Developer/ Programmer Analyst Location: 102 Governor Street Suite 120 Room 117, Richmond, Virginia 23219 Client: SCB Job Id: 738014 Duration: 12 Months Job Description: This position requires: Broad foundation of knowledge and experience in information technology; Strong knowledge of C#, prototyping, reusability, object oriented design and development,...


  • Richmond, United States nLeague Full time

    C# Developer/ Programmer Analyst Location: 102 Governor StreetSuite 120 Room 117, Richmond, Virginia 23219 Client: SCB Job Id: 738014 Duration: 12 Months Job Description: This position requires: Broad foundation of knowledge and experience in information technology; Strong knowledge of C#, prototyping, reusability, object oriented design and development,...


  • Richmond, United States Sparkle Genius Full time

    - .Net/SQL Server Prog/Analyst **.Net/SQL Server Prog/Analyst** August 11, 2021 Written by * Posted 6 days ago **Duration.** 10+months Interview. **Both Phone and In Person** **.Net/SQL SERVER Programmer/Analyst** *local candidates strongly preferred *interviews will be conducted via Skype or Google Hangout and potentially a follow-up ONSITE interview ...


  • Richmond, United States InterSources Full time

    Job Title : C# Developer/Programmer Analyst Location: Richmond, VA,Hybrid Rate : Best competitive rate The Compensation Board is seeking an experienced C# Developer/Programmer to be responsible for: developing and maintaining business applications for the Compensation Board using emerging technology; leading the agency maintenance, development, and...