Job Family:
Finance & Accounting Consulting
Travel Required:
Up to 10%
Clearance Required:
Ability to Obtain Public Trust
What You Will Do:
Guidehouse is seeking a Data Automation Specialist to join our Defense and Security Segment, where the individual will collect, transform, integrate, and analyze data to identify trends, assess performance, and support decision-making for a position management program within the Department of Homeland Security (DHS). Responsibilities include, but are not limited to:
- Knowledge and experience working on multiple projects simultaneously in or like a Contact Center environment
- Leads data research and analysis tasks.
- Prepares data formats and compiles data to produce reports.
- Prepares reports and presentations that convey trends and analysis.
- Performs data research and analysis tasks related to database planning and design, systems analysis, integration, programming, conversion, and implementation support.
- May use VBA, SQL and other tools to provide analysis and use of data sets, systems, and software.
- Supports DHS business process improvements and modernization projects.
- Analyzes and evaluates data to provide administrative and operational support, and to identify and resolve problems, in a variety of non-technical functional areas such as logistics, finance, programs, and business operations.
- Identifies, defines, interprets, clarifies scope, and provides guidance regarding existing technical difficulties and potential enhancement solutions.
- Works with cross-functional teams to achieve goals.
- Develops and implements policies, procedures, and solutions to improve efficiency and effectiveness.
- Provides expert analysis and recommendations on current and emerging approaches and technology for big data management and analytics.
- Ability to conduct detailed research and analysis of technical information.
- Knowledge of industry leading data quality and data protection management practices.
- Possesses consulting skills, with change management concepts and strategies, including communication, culture change and performance measurement system design.
What You Will Need:
- Must be able to OBTAIN and MAINTAIN a Federal or DoD "PUBLIC TRUST"; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse. Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred.
- Bachelor's degree
- FIVE (5) or more years of experience using various data visualization programs such as Tableau, Power BI, SQL/VBA, etc. Experience should include:
- Performing data analytics to address management and operational challenges
- Independently conducting analysis and recommending actions to take based on analysis.
- Leading client meetings.
- Proficiency in Microsoft Suite, especially MS Excel and MS PowerPoint
What Would Be Nice To Have:
- Intermediate Excel skills (formulas, pivot tables) required, advanced skills (macros, VBA) preferred.
- Proficiency in data analytic tools such as SQL, Python, R
- Proficiency in Tableau, PowerBI, or Qlik
- Collaborating and working in a team environment, as well as the ability to work independently
- Identifying and addressing client needs, building relationships with clients, demonstrating flexibility in prioritizing and completing tasks, communicating potential conflicts to a supervisor
- Communicating effectively to various audiences, including various levels of management and external clients, in a professional environment
- Experience in commercial or public sector consulting firms
- Prior experience supporting federal finance organizations
- Experience with SharePoint
The annual salary range for this position is $98,000.00-$163,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.
What We Offer:
Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
Benefits include:
Medical, Rx, Dental & Vision Insurance
Personal and Family Sick Time & Company Paid Holidays
Position may be eligible for a discretionary variable incentive bonus
Parental Leave and Adoption Assistance
401(k) Retirement Plan
Basic Life & Supplemental Life
Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
Short-Term & Long-Term Disability
Student Loan PayDown
Tuition Reimbursement, Personal Development & Learning Opportunities
Skills Development & Certifications
Employee Referral Program
Corporate Sponsored Events & Community Outreach
Emergency Back-Up Childcare Program
Mobility Stipend
