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 22SECRET22 security clearance; candidates must obtain approved adjudication of clearance before onboarding with Guidehouse.

• A Bachelors 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 63 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/data visualization technologies (Power BI, Databricks, Palantir Products)

• Ability to work in high-pressure situations

• Excellent problem-solving and analytical skills

• Excellent attention to detail

What Would Be Nice To Have:

• Experience working in the Federal/DoD IT environment

• Candidates with an ACTIVE 22SECRET22 or higher-level clearance are preferred.

• Experience in IT and Financial data management or USAF Financials

• Coding skills in Python, R, SQL, or other languages are a plus

• Experience with statistical software

• Experience with Automated connections to multiple systems

• Experience in 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