Systems Analyst

vTech Solution; Washington (District of Columbia); On-site; USD 85,000 - 110,000; Full time

Job summary

vTech Solution is seeking an IT System Analyst II to drive data modernization, automation, and reporting initiatives. The role focuses on building and maintaining SQL queries, dashboards, and data validation while collaborating with stakeholders to improve data accessibility.

Responsibilities include governance and security controls implementation, metadata management, and participation in testing activities to ensure reliable data delivery across environments.

Qualifications

• Bachelor's degree in IT, Computer Science, Data Analytics, or related field with strong data-focused coursework.
• 5+ years of systems analysis experience.
• Experience with Python, SQL, Java, Tableau, and front-end website technologies.
• Experience supporting reporting or data warehouse environments.

Responsibilities

• Support data modernization and automation projects.
• Develop and maintain SQL queries and reporting solutions.
• Support dashboard and visualization development.
• Maintain metadata, data dictionaries, and documentation.
• Perform data quality assessments and validation activities.
• Participate in system integration and testing activities.
• Support user acceptance testing.
• Assist with governance and security controls implementations.
• Support report generation and data-accessibility initiatives.

Skills

Python

SQL

Java

Tableau

Front-end technologies

Education

Bachelor's degree in IT/CS/Data Analytics

Job description

Job Summary:

The IT System Analyst II plays a crucial role in supporting data modernization, automation, and reporting initiatives. This position involves developing and maintaining SQL queries and reporting solutions, performing data quality assessments, managing databases, and collaborating with stakeholders to implement technical solutions that enhance workflow and data accessibility.

Responsibilities:

• Support data modernization and automation projects.
• Develop and maintain SQL queries and reporting solutions.
• Support dashboard and visualization development.
• Maintain metadata, data dictionaries, and documentation.
• Perform data quality assessments and validation activities.
• Participate in system integration and testing activities.
• Support user acceptance testing.
• Assist with implementation of governance and security controls.
• Support report generation and data-accessibility initiatives.

Required Skills & Certifications:

• Bachelor's degree in IT, Computer Science, Data Analytics, or related field.
• 5+ years of systems analysis experience.
• Experience with Python, SQL, Java, Tableau, and front-end website technologies.
• Experience supporting reporting or data warehouse environments.

Preferred Skills & Certifications:

• Statistical reporting experience.
• Data governance experience.
• Federal agency experience.

Special Considerations:

• Implementation of governance and security controls is required.

Scheduling:

• Work schedule and shift pattern are not specified.