Senior Data Automation Specialist

Guidehouse•Tysons Corner, VA

About The Position

Guidehouse is seeking a Data Automation Specialist for its Defense and Security Segment. The role supports a position management program within the Department of Homeland Security (DHS) by collecting, transforming, integrating, and analyzing data to identify trends, assess performance, and support decision-making. The specialist contributes to DHS business process improvement and modernization projects, providing analytical, administrative, and operational support across functional areas such as logistics, finance, programs, and business operations. The position involves data research and analysis, report and presentation preparation, support for database and systems planning and implementation, and the use of tools such as VBA and SQL. The specialist also advises on data quality, data protection, big data management, and analytics approaches, while working with cross-functional teams and clients to improve efficiency and effectiveness. The role requires the ability to obtain and maintain a Federal or DoD Public Trust; approved adjudication is required before onboarding.

Requirements

Bachelor's degree.
Five or more years of experience using data visualization programs such as Tableau and Power BI, and tools such as SQL and VBA.
Experience performing data analytics to address management and operational challenges.
Experience independently conducting analysis and recommending actions based on analysis.
Experience leading client meetings.
Proficiency in Microsoft Office, especially Excel and PowerPoint.
Ability to obtain and maintain a Federal or DoD Public Trust; approved Public Trust adjudication is required before onboarding.

Nice To Haves

Active Public Trust or suitability.
Intermediate Excel skills, including formulas and pivot tables; advanced skills such as macros and VBA are preferred.
Proficiency in data analytics tools such as SQL, Python, or R.
Proficiency in Tableau, Power BI, or Qlik.
Ability to collaborate and work in a team environment as well as independently.
Ability to identify and address client needs, build client relationships, prioritize and complete tasks flexibly, and communicate potential conflicts to a supervisor.
Ability to communicate professionally and effectively with varied audiences, including management at different levels and external clients.
Experience in commercial or public sector consulting firms.
Prior experience supporting federal finance organizations.
Experience with SharePoint.

Responsibilities

Lead data research and analysis tasks.
Prepare data formats and compile data to produce reports.
Prepare reports and presentations that convey trends and analysis.
Perform data research and analysis related to database planning and design, systems analysis, integration, programming, conversion, and implementation support.
Use VBA, SQL, and other tools to analyze and work with data sets, systems, and software.
Support DHS business process improvement and modernization projects.
Analyze and evaluate data to provide administrative and operational support and identify and resolve problems in functional areas such as logistics, finance, programs, and business operations.
Identify, define, interpret, and clarify scope; provide guidance on existing technical difficulties and potential enhancement solutions.
Work with cross-functional teams to achieve goals.
Develop and implement policies, procedures, and solutions to improve efficiency and effectiveness.
Provide expert analysis and recommendations on current and emerging approaches and technology for big data management and analytics.
Conduct detailed research and analysis of technical information.
Apply data quality and data protection management practices.
Apply consulting skills and change management concepts and strategies, including communication, culture change, and performance measurement system design.
Work on multiple projects simultaneously in or similar to a contact center environment.
Independently analyze information and recommend actions based on analysis.
Lead client meetings.