SQL Programmer Analyst

Title: SQL Programmer Analyst

Duration: 12 Months

Location: Richmond VA

Note: Remote work but needs to be able to come onsite

Job Description:

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

Required skills:

• 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 trendbased 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 always
  
• Assist in responding to data requests data analysis using SQL and automation/generation of adhoc 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
  

If you are: bright motivated skilled a differencemaker able to get things done work with minimum direction enthusiastic a thinker able to juggle and multitask communicate effectively and lead then we would like to hear from you. We need exceptionally capable people for this role for our client so get back to us and tell us why you think you are a fit.

About Us:

TriForce is one of the fastest growing companies in Philadelphia region by receiving the award 5 times and 3 times(Ranked #) on Inc. 5000 fastest growing companies in the USA. TriForce Consulting Services Inc. is an established consulting services firm offering innovative solutions to Government and Commercial sectors. We specialise in building customized software applications solutions such as knowledge management systems business intelligence data analysis database support and maintenance data warehouse implementation and support systems architecture and systems integration for our clients. Our technical competencies are in Java .NET SharePoint PHP Business Intelligence (Cognos Data Warehouse) mobile applications platforms (iPhone iPad Android Blackberry) and various other technologies. We also specialise in providing resources to manage infrastructure projects. TriForce is one of the fastest growing companies in the Philadelphia region by receiving the award 6 times and 4 times on Inc. 5000 fastest growing companies in the USA.

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