Technical Systems Analyst

D. Kent Consulting Group, LLC•Springfield, VA

2d•Hybrid

About The Position

D. Kent Consulting Group, LLC is seeking a Technical Analyst with federal government experience to join its team in Springfield, Virginia. The role provides technical support for business operations and modernization efforts in an IT environment. The analyst advises mission program offices and supports technical configuration documentation, testing and evaluation, change management, and knowledge-article development to improve operational effectiveness. Flexible work-from-home options are available.

Requirements

Bachelor's degree in Information Technology, Computer Science, Engineering, or a related field.
Proven experience as a Technical Analyst or in a similar role in a consulting or government environment.
Strong proficiency in data analysis tools, SQL, and/or business intelligence platforms.
At least 3 years of experience designing, developing, testing, and maintaining VBA solutions in Microsoft Visio and Excel within a production environment.
Advanced experience with Microsoft Visio, including custom templates, stencils, shapes, and diagramming solutions.
At least 3 years of experience providing technical support and troubleshooting for end users in an enterprise IT environment.
Experience developing VBA solutions that integrate Microsoft Office applications, including Visio, Excel, and Word.
Experience supporting infrastructure, system administration, or network engineering activities within a Microsoft environment.
Experience developing automation solutions involving data validation, business rules, reporting, and workflow efficiencies.
Strong troubleshooting, analytical, and diagnostic skills, including the ability to resolve complex technical issues.
Strong written and verbal communication skills, including technical documentation and communication with technical and non-technical stakeholders.
Experience creating and maintaining technical documentation, user guides, knowledge articles, and training materials.
Experience leading tasks, coordinating stakeholders, and working independently in a fast-paced development environment.
Familiarity with Windows administration concepts, command-line tools, and environment variables.
Ability to obtain and maintain a Public Trust clearance.

Responsibilities

Analyze technical systems, processes, and data to identify trends, issues, and opportunities for improvement.
Develop and maintain technical documentation, reports, and dashboards for stakeholders.
Collaborate with cross-functional teams to gather requirements and translate them into technical solutions.
Support system integration, testing, and quality assurance activities.
Monitor system performance and recommend optimization opportunities.
Assist in developing and implementing technical strategies and project plans.
Present findings and technical insights to technical and non-technical audiences.
Design, develop, test, and maintain VBA-based solutions in Microsoft Visio and Excel supporting Technical Configuration Diagram (TCD) processes.
Develop and enhance custom Visio templates, stencils, shapes, and user interfaces for infrastructure and architecture change approvals.
Maintain automated enterprise-wide updates to keep TCD templates, code, metadata, and stencils standardized.
Develop Excel- and Visio-based tools that automate data validation, reporting, bulk updates, and business-rule enforcement.
Provide technical support and troubleshooting for end users and administrators, including custom solutions for operational needs.
Design, maintain, and support production and development environments, including access controls, permissions management, and system reliability.
Create and maintain technical and user documentation, knowledge articles, and training materials.
Lead and coordinate development activities, project planning, task tracking, and status reporting throughout the project lifecycle.
Collaborate with stakeholders to gather requirements, evaluate change requests, and implement technical solutions.
Communicate technical concepts, project status, and system issues to technical and non-technical audiences.