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.
• Developing dashboards and reports that present data-based insights, trends, and metrics to executives in a clear and concise manner.
• Ensuring financial data governance, financial data integrity, and quality assurance standards are met to support reliable reporting and federal compliance requirements.
• 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
• Support the technical upskilling of Federal staff and enable staff to independently operate solutions by developing and presenting training materials, desk guides, etc.
• 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
• FIVE (5) or more years of consulting experience, or financial services industry experience, supporting data analytics, data engineering, business intelligence, financial management modernization or reporting initiatives. Experience should include:
• • Assessing business processes to identify opportunities to improve data, reporting, and analytics capabilities, and recommending solutions to meet the identified business need

• • Architecting and developing reporting, visualization, and analytic solutions to improve client efficiency, capabilities, and performance

• • Querying and manipulating data using SQL and/or Python
• Establishing integrations and data pipelines between interfacing data sources and systems

• • Developing dashboards, reports, or visualizations using Power BI, or similar business intelligence tools, preferably supporting obligation, contract, budget, performance and risk analysis for executive-level reporting

• • Developing, refining, and presenting training materials to support end user adoption

• • Understanding of data quality, data governance, and data management principles within the federal compliance landscape

• • Integrating, cleaning, and validating datasets from multiple sources

• • Proficiency with Microsoft Excel and the broader Microsoft Office Suite

• Experience supporting federal financial management, budgeting, accounting, audit, or CFO organizations
• Familiarity with federal financial management concepts, financial data, key performance indicators (KPIs), budget execution reporting, and management reporting processes
• Experience building predictive models and analytics solutions using machine learning techniques to forecast budget, obligation, contract, and risk-based financial outcomes
• Experience with federal enterprise resource planning (ERP) systems such as Oracle Financials, OneStream, and Concur, amongst others
• Experience working in, or supporting clients, in the federal housing or mortgage markets
• 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
• Power BI 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
• Experience working with Databricks or comparable cloud-based data platforms to transform, manage, and/or analyze data

The annual salary range for this position is $85,000.00-$141,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