Senior Data Automation Specialist

Guidehouse Inc.

McLean (VA)

On-site

USD 98,000 - 163,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical Insurance
401(k) Plan
Paid Holidays
Tuition Reimbursement
Career Development

Job summary

Guidehouse is seeking a seasoned data analytics consultant to support federal finance and operations projects in the United States. You will manage multiple projects, perform data research, and develop reports for stakeholders.

The role requires 5+ years of analytics experience, proficiency with Tableau/Power BI/SQL, and the ability to obtain a Public Trust. A Bachelor's degree is required.

Qualifications

  • Bachelor's degree required.
  • 5+ years of data analytics experience.
  • Experience with Tableau, Power BI, SQL/VBA and data visualization.
  • Strong Excel and PowerPoint proficiency.
  • Experience leading client meetings and cross-functional teams.

Responsibilities

  • Lead data research and analysis across multiple projects.
  • Prepare data formats and reports highlighting trends.
  • Create reports and presentations communicating insights.
  • Perform data analysis for database planning, systems design, and implementation.
  • Use VBA, SQL, and other tools to analyze data sets.
  • Support modernization projects for DHS business processes.
  • Collaborate with cross-functional teams to reach goals.
  • Develop and implement policies and processes to improve efficiency.

Skills

Data analytics
Leading client meetings
Cross-functional collaboration
Independent analysis

Education

Bachelor's degree

Tools

Tableau
Power BI
SQL
VBA
Python
R
SharePoint

Job description

Job Family: Finance & Accounting Consulting

Travel Required: Up to 10%

Clearance Required: Ability to Obtain Public Trust

What You Will Do:

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

Guidehouse is an Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Financial Management Data Engineer
Senior Financial Management Data Engineer

Guidehouse Inc. • McLean (VA)

On-site
USD 113,000 - 188,000
Medical insurance
401(k) Retirement Plan
Paid holidays
+4
Data Analyst (Senior Consultant)
Data Analyst (Senior Consultant)

Guidehouse • Arlington (VA)

On-site
USD 85,000 - 120,000
Medical Insurance
401(k) Retirement Plan
Parental Leave
+5
Data Visualization Specialist
Data Visualization Specialist

US101 Guidehouse Inc. • Arlington (VA)

On-site
USD 98,000 - 163,000
Medical, Rx, Dental & Vision Insurance
401(k) Retirement Plan
Parental Leave and Adoption Assistance
+4
Data Strategy Specialist
Data Strategy Specialist

Guidehouse Inc. • United States

On-site
USD 130,000 - 216,000
Medical,Rx, Dental & Vision Insurance
Personal and Family Sick Time &Company
Parental Leave
+4
Team Lead - Law Enforcement Analytics
Team Lead - Law Enforcement Analytics

Guidehouse Inc. • Arlington (VA)

Hybrid
USD 130,000 - 216,000
Medical, Rx, Dental & Vision Insurance
Personal and Family Sick Time &Company
Discretionary incentive bonus
+10
Senior Data Automation Specialist
Senior Data Automation Specialist

US101 Guidehouse Inc. • Tysons (VA)

On-site
USD 98,000 - 163,000
Medical Insurance
401(k)
Paid Holidays
+1
Senior Consultant, Data Analyst / Visualization
Senior Consultant, Data Analyst / Visualization

US101 Guidehouse Inc. • Arlington (VA)

On-site
USD 113,000 - 188,000
Insurance
Holidays
Bonuses
+11
Sr. Data Analytics Developer
Sr. Data Analytics Developer

Guidehouse • Huntsville (AL)

On-site
USD 75,000 - 113,000
Medical, Rx, Dental & Vision Insurance
401(k) Retirement Plan
Parental Leave
+2
Financial Transformation Manager
Financial Transformation Manager

Guidehouse • Arlington (VA)

On-site
USD 140,000 - 200,000
Medical Insurance
401(k) Retirement Plan
Tuition Reimbursement
+2
Data Strategy Specialist
Data Strategy Specialist

Guidehouse • United States

Remote
USD 130,000 - 216,000
Medical Insurance
Dental Insurance
Vision Insurance
+6