Data Analyst

Guidehouse is hiring a Data Analyst to support data-focused initiatives in an Arlington, VA hybrid environment. In this role, you will connect internal and external data sources across multiple data warehouse tools, keep data in sync, and deliver dashboards that surface key KPIs for decision-makers.

From mapping large datasets to maintaining data management plans, the position emphasizes quality, clear documentation, and collaboration in an ad-hoc setting. You will also evaluate and implement database and architecture updates while preserving the integrity of the project data model.

What You’ll Do

• Coordinate with external database admins and the data warehouse support team to sync databases.
• Maintain and monitor data sync quality.
• Use mapping techniques to structure large datasets and identify usable information.
• Design, develop, and modify data infrastructure to improve data analysis and reporting workflows.
• Maintain data management plans and instructions for operating complex business systems.
• Evaluate database change designs, selection, and implementation by comparing them to business requirements and design documents.
• Map and join siloed, disparate datasets using Palantir Foundry (pipelines), Advana, and Power BI DAX.
• Update the data architecture and model as needed.
• Construct Power Automate flows.
• Create approaches for joining multiple disparate datasets to generate meaningful insights.
• Collaborate with team members to collect and analyze data.
• Establish KPIs to measure the effectiveness of business decisions.
• Develop Power BI dashboards to present analysis.
• Apply soft skills to work with analysts in an ad-hoc environment to process information.

Qualifications

• Ability to obtain and maintain a Federal or DoD SECRET security clearance; candidates must obtain approved adjudication before onboarding.
• US citizenship is required.
• A Bachelor’s degree is required.
• Minimum five (5) years of experience working with large amounts of data.
• Experience building AI agents and using AI to produce outcomes.
• Knowledge of data management and reporting/data visualization technologies, including Power BI, Databricks, and Palantir products.
• Willingness and ability to work onsite at least 2–3 days per week at the designated office location, with additional onsite attendance as needed.
• Ability to perform in high-pressure situations.
• Excellent problem-solving and analytical skills.
• Excellent attention to detail.

Technologies

• Power BI
• Databricks
• Palantir Products
• Palantir Foundry
• Advana
• Power BI DAX
• Power Apps
• Power Automate
• Power Automate Flow Construction
• APIs
• Bots

Benefits

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Discretionary variable incentive bonus eligibility
• 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

Additional Details

• Job Family: Data Engineering & Architecture Consulting
• Travel Required: Up to 10%
• Clearance Required: Active Secret
• Location: Arlington, VA (hybrid)

What Would Be Nice to Have

• Experience working in the Federal/DoD IT environment
• Active “SECRET” or higher-level clearance
• Experience in IT and Financial data management or USAF Financials
• Coding skills in Python, R, SQL, or other languages
• Experience with statistical software
• Experience with automated connections to multiple systems
• Experience finding inefficiencies and deploying automated solutions to streamline outputs
• Financial systems knowledge
• Technical writing skills
• Knowledge of modern database and information technologies
• SharePoint design and administration