Guidehouse is a leading global provider of consulting services to the public sector and commercial markets, with broad capabilities in management, technology, and risk consulting. By combining our public and private sector expertise, we help clients address their most complex challenges and navigate significant regulatory pressures focusing on transformational change, business resiliency, and technology-driven innovation. Across a range of advisory, consulting, outsourcing, and digital services, we create scalable, innovative solutions that help our clients outwit complexity and position them for future growth and success.

The company has more than 16,500 professionals in over 55 locations globally. Guidehouse is a Veritas Capital portfolio company, led by seasoned professionals with proven and diverse expertise in traditional and emerging technologies, markets, and agenda-setting issues driving national and global economies.

As a database administrator and data analyst you will be working to identify external databases to be connected within a data warehouse tool. You will work with both the external database administrators and the data warehouse support team to connect data sets primarily using APIs. You will also be responsible for maintaining data syncs and data quality as well as maintaining data quality metrics and the data architecture/model for the project.

Job Description/Responsibilities:

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
• 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
• Update data architecture/model as needed

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
• Work with a team of analysts and other associates to process information

What You Will Need

• Ability to obtain and maintain a SECRET federal security clearance
• FIVE (5) year's or more experience working with large amounts of data
• Bachelor’s degree
• Coding skills in Python, R, SQL, or other languages
• Knowledge of reporting and data visualization skills

What Would Be Nice To Have

• An ACTIVE and CURRENT SECRET federal security clearance
• Experience working in the Federal/DoD IT environment
• Experience in IT and Financial data management
• Experience with statistical software
• Experience with APIs
• Technical writing skills
• Knowledge of modern database and information technologies
• Ability to work in high-pressure situations
• Excellent math, problem-solving, and analytical skills
• Excellent attention to detail