Senior Consultant, Data Analyst / Visualization
Senior
Analytical Skills
Analytics
Automation Developer
Business Analytics
Business Intelligence
Business Intelligence Tools
Consulting
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Dashboarding
Data Integration
Data Processing
Data Visualization
Data Visualization Tools
Data Viz
Database
Databases
Dataviz
Microsoft Excel
Microsoft Power Platform
Power BI
Power Platform
Power Query
Reporting and Analytics
Spreadsheets
SQL
Tableau
Job Description
This Senior Consultant role focuses on turning complex operational and infrastructure data into actionable insights to support high-visibility initiatives. The work includes data collection and analysis, dashboard and visualization development, workflow automation using Microsoft tools, and clear communication of results to both technical and non-technical audiences.
Responsibilities
- Collect, clean, validate, and analyze data from multiple sources.
- Develop and maintain dashboards, reports, and data visualizations using tools such as Power BI and Tableau.
- Design and develop workflow applications and automated processes using Microsoft Power Platform, including Power Apps and Power Automate.
- Identify opportunities to streamline manual processes through automation.
- Translate business needs into analytical, reporting, and workflow requirements.
- Test, troubleshoot, document, and maintain dashboards, applications, and automated workflows.
- Identify trends, patterns, anomalies, and data-quality issues.
- Communicate findings to technical and non-technical audiences.
- Collaborate with stakeholders and multidisciplinary project teams.
Required Qualifications
- Ability to obtain and maintain a Federal or DHS PUBLIC TRUST; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse.
- Preferred: candidates with an ACTIVE PUBLIC TRUST or SUITABILITY.
- US Citizenship is contractually required.
- Bachelor’s degree from an accredited university.
- Minimum 3+ years of work experience.
- Experience in data analysis, reporting, business intelligence, data visualization, automation, or application development.
- Experience developing dashboards or visualizations using Power BI, Tableau, or similar tools.
- Experience developing workflow applications and automations using Microsoft Power Platform, including Power Apps and Power Automate.
- Ability to work collaboratively in a client-facing consulting environment.
Technologies
- Power BI
- Tableau
- Microsoft Power Platform
- Power Apps
- Power Automate
- Power Query
- SQL
- Excel
Nice to Have
- Experience with SQL, Excel, Power Query, or other data preparation tools.
- Working knowledge of data preparation, validation, analysis, visualization, and workflow design.
- Ability to translate business requirements into dashboards, applications, or automated workflows.
- Strong analytical, problem-solving, organizational, and communication skills.
- Experience developing interactive dashboards and performance reports.
- Familiarity with financial, operational, infrastructure, or performance data.
- Experience supporting public-sector organizations.
- Familiarity with data-quality checks and repeatable reporting processes.
- Experience working in an Agile or iterative delivery environment.
Travel and Clearance
- Travel required: up to 25%.
- Clearance required: ability to obtain Public Trust.
Compensation and Location
- Location: Arlington, VA (onsite).
- Annual salary range: USD 113,000 - 188,000.
- Job family: Data Science Consulting.
Benefits
- 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