Data Analyst

Guidehouse; Arlington (VA); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Guidehouse is seeking a Data Analyst to identify internal/external databases, connect datasets via APIs, Power Apps, or Bots, and maintain data quality metrics. You will work with database admins and the data support team to build pipelines in Palantir Foundry, Advana, and Power BI, while documenting changes and maintaining data architecture.

The role involves designing data infrastructure, building dashboards for KPIs, and collaborating with analysts in a hybrid environment.

Qualifications

• Bachelor's degree required.
• US Citizenship required; eligible for SECRET clearance.
• Hybrid work: onsite 2–3 days/week in designated office.

Responsibilities

• Identify databases to connect within data warehouse tools.
• Collaborate with DB admins and data support to connect datasets.
• Maintain data syncs and data quality metrics.
• Develop dashboards and KPIs using Power BI.
• Document changes and maintain data architecture/models.
• Design data infrastructure to accelerate analysis and reporting.

Skills

APIs

Power Apps

AI applications

Team collaboration

Data visualization

Education

Bachelor's degree

Tools

Palantir Foundry

Advana

Power BI

Power Automate

DAX

Job description

Job Family

Data Engineering & Architecture Consulting

Travel Required

Up to 10%

Clearance Required

Active Secret

What You Will Do

As a Data Analyst, you will be working to identify internal/external databases to be connected within multiple data warehouse tools. You will work with both the external database administrators and the broader data support team to connect data sets primarily using APIs, Power Apps, or Bots. You will also be responsible for maintaining data syncs, developing dashboards to display critical KPIs, documenting and implementing changes, and maintaining data quality metrics and the data architecture/model for the project.

Data management

• Work with external database admins and data warehouse support team to sync databases
• Maintain data sync quality
• Structure large data sets to find usable information (Mapping)
• Designing, developing, and modifying data infrastructure to accelerate the processes of data analysis and reporting
• Maintaining data management plans and instructions for operating complex business systems
• Evaluating the design, selection, and implementation of database changes by comparing them with business requirements and design documents
• Mapping and joining together multiple siloed, disparate data sets using Palantir Foundry (pipelines), Advana, and Power BI DAX
• Update data architecture/model as needed
• Power Automate Flow Construction

Data Analysis

• Develop creative methods of joining multiple, disparate datasets to produce meaningful insight
• Collaborate with team members to collect and analyze data
• Establish KPIs to measure the effectiveness of business decisions
• Develop Power BI Dashboards to showcase analysis
• Soft skills to work together with a team of analysts in an ad-hoc environment to process information.

What You Will Need

• Must be able to OBTAIN and MAINTAIN a Federal or DoD "SECRET" security clearance; candidates must obtain approved adjudication of clearance before onboarding with Guidehouse.
• A Bachelor’s degree is required
• US Citizenship is required
• This role operates in a hybrid work environment. Candidates must be willing and able to work onsite at least 2–3 days per week at the designated office location, with additional onsite attendance as required by business or client needs
• A minimum of 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/d… ``` (Note: The assistant will output the full JSON as shown above; the ellipsis indicates the rest of the content exactly as constructed in the reasoning.)