Financial Management Data Analyst

• Accessing financial data sources, establishing data connections, and pre-processing data for analysis
• Aggregate, clean and organize datasets from disparate sources and perform quality assurance of these tasks
• Manipulating large financial data sets, data mining, and structuring raw financial and operational data using open-source tools such as SQL and Python to formulate or recognize patterns to generate new information and insights to support financial decision-making, performance reporting, and resource allocation activities.
• Designing financial data modeling processes and performing ad hoc/exploratory data analysis to support data-driven decision making related to financial performance and budget execution.
• Ensuring financial data governance, financial data integrity, and quality assurance standards are met to support reliable reporting and federal compliance requirements.
• Help define data quality metrics associated with the quality of data ingested into Databricks to ensure accuracy and consistency across reporting environments.
• Organizing and leading client meetings, including scheduling meetings; drafting and delivering agendas and meeting minutes; providing and archiving required documentation; and documenting, tracking, and following up on action items
• Delivery of client services, while also supporting business development, internal firm initiatives, and ongoing professional development

• Must be able to OBTAIN and MAINTAIN a Federal or DoD "PUBLIC TRUST"; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse. Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred
• Bachelor's degree in Data Analytics, Data Science, Computer Science, Information Systems, Engineering, Statistics, Finance, Mathematics, Economics, or a related quantitative field
• ONE (1) or more years of experience supporting data analytics, data engineering, business intelligence, financial management modernization or reporting initiatives
• Experience querying and manipulating data using SQL
• Experience developing scripts and performing data analysis using Python or a comparable analytics programming language
• Experience working with Databricks or comparable cloud-based data platforms to transform, manage, and/or analyze data
• Experience developing dashboards, reports, or visualizations using Tableau, Power BI, or similar business intelligence tools, preferably supporting budget execution monitoring or executive reporting
• Understanding of data quality, data governance, and data management principles within the federal compliance landscape
• Experience integrating, cleaning, and validating datasets from multiple sources
• Proficiency with Microsoft Excel and the broader Microsoft Office Suite
• Strong analytical, problem-solving, and critical-thinking skills
• Strong written and verbal communication skills, including the ability to explain technical concepts to non-technical audiences
• Ability to work independently while collaborating effectively within a multidisciplinary team environment

• Experience supporting federal financial management, budgeting, accounting, audit, or CFO organizations, preferably within DHS
• Familiarity with federal financial management concepts, financial data, key performance indicators (KPIs), budget execution reporting, and management reporting processes
• Experience developing automated reporting or data transformation workflows
• Exposure to cloud analytics environments, such as Databricks
• Experience working in a consulting, government, or professional services environment
• Experience working with Agile delivery methodologies and project teams
• Tableau Desktop certification or similar analytics certifications
• Experience creating executive-level dashboards and data visualizations that communicate financial performance, resource utilization, operational metrics, and/or organizational priorities

The annual salary range for this position is $74,000.00-$124,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• 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