Data Analyst

Defense Technology Integration Llc; Washington (District of Columbia); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Defense Technology Integration (DTI), LLC is seeking a Data Analyst with a finance background to support a federal government client in Washington, DC. The role is hybrid telework: 2 days onsite and 3 days remote, with a possible shift to 1 day onsite and 4 days remote.

The analyst designs, builds, and delivers executive dashboards and reports using Salesforce and Oracle financial systems, portfolio data, and other sources.

Qualifications

• Bachelor's degree in finance, economics, business analytics, data science, statistics, accounting or related field.
• 5+ years of data analysis and reporting experience, with at least 3 years in financial services or federal programs.
• Experience building executive dashboards for C-suite or senior leadership.

Responsibilities

• Design, develop, and maintain enterprise dashboards and reports for executives and business units.
• Create recurring (weekly/monthly/quarterly) and ad hoc analyses for C-level audiences.
• Produce briefing materials, summaries, and talking points for committees and boards.
• Define and standardize KPIs with business owners (cycle time, approval rates, pipeline metrics).
• Reconcile Oracle financial data with Salesforce and flag discrepancies for resolution.

Skills

Dashboard design

Data visualization

Salesforce reporting

SOQL / data exports

Financial data analysis

Stakeholder communication

Education

Bachelor's degree in finance or related field

Tools

Salesforce

Oracle Financials

Excel / BI tools

S&P Cap IQ Pro

Bloomberg

Job description

Job Description Defense Technology Integration (DTI), LLC is seeking a Data Analyst with a background in finance to support a federal government client in Washington, DC.

The position is a hybrid telework position 2 days onsite and 3 days remote (may shift to 1 day onsite and 4 days remote).

Position Overview

The Data Analyst designs, builds, and delivers enterprise C-suite executive-level and business unit level dashboards and reports using data sources such as Salesforce and Oracle financial systems, CIA Factbook, FDI, IMF PortWatch, S&P Cap IQ Pro, Bloomberg, Wood Mackenzie, Green Street Infrastructure, International Energy Agency (IEA), UN Conference on Trade and Development, UN Comtrade, World Bank Open Data . The analyst examines insurance, debt, credit, loan, equity, and fund transactions, contract agreements, financial data; and the workflow processes. The role combines hands-on analysis with executive communication. The analyst translates complex portfolio data into clear findings, visualizations, and recommendations for C-suite leaders, Investment Committee members, and business unit heads, often on short deadlines in a fast-paced environment.

Key Responsibilities

Executive and business unit reporting

• Design, develop, and maintain enterprise executive dashboards and business unit reports covering pipeline volume, commitments, disbursements, exposure, and portfolio performance across and enterprise portfolio.
• Build recurring reports (weekly, monthly, quarterly) and ad hoc analyses for the C-suite executives and departments staff.
• Produce briefing materials, executive summaries, and talking points for Committees, Boards, and Congressional or OMB requests.
• Define and standardize key performance indicators (KPIs) with business owners, including workflow cycle time, approval rates, pipeline conversion, concentration risk, and development impact.

Data analysis across products

• Analyze Direct Equity, Project Development, Political Risk Insurance, Debt, and Funds transactions to identify trends, risks, bottlenecks, and opportunities.
• Analyze loan, credit, and insurance data, including exposure by country, sector, and product; tenors; pricing; premiums; guaranty coverage; and repayment status.
• Review contract agreements (loan agreements, insurance contracts, grant agreements, limited partnership agreements) to extract key terms, covenants, conditions precedent, and milestone dates for reporting.
• Reconcile financial data managed in Oracle with transaction data in Salesforce and other data repositories and flag discrepancies for resolution.

Pipeline workflow analysis

• Map and analyze workflow processes
• Measure workflow phase durations, hand-offs, and backlog to identify delays and recommend process improvements.
• Work with software application engineers and DFC business owners to define data models, ontology objects, and reporting requirements as new pipeline phases go live.
• Support user acceptance testing (UAT) by validating that reports and dashboards reflect accurate pipeline data.

Data quality and governance

• Establish data validation rules, data dictionaries, and documentation for report sources and calculations.
• Monitor data completeness and accuracy across database repositories and lead remediation with data owners.
• Protect sensitive financial, legal, and personally identifiable information in line with federal data policies.

Communication and stakeholder engagement

• Present findings to C-suite executives and senior managers in clear, concise written and oral briefings.
• Gather and translate executive requirements into report specifications.
• Train business unit staff to use dashboards and self-service reports.

Required Qualifications

• Bachelor's degree in finance, economics, business analytics, data science, statistics, accounting, information systems, or a related field.
• 5+ years of experience in data analysis and reporting, including at least 3 years in financial services, development finance, banking, insurance, investment management, or federal financial programs.
• Demonstrated experience building executive-level dashboards and reports for C-suite or senior leadership audiences.
• Hands-on experience with Salesforce reporting and data (reports, dashboards, SOQL, or data exports).
• Working knowledge of financial instruments, including loans, guaranties, credit, insurance, equity, and fund investments.

Salary Negotiable Based On Relevant Experience