Data Analyst - U.S. Government Agency

Dexis is a dynamic professional services firm dedicated to partnering with government and community leaders both in the U.S. and internationally to achieve critical social outcomes in a rapidly changing world.At Dexis, you will experience a corporate culture of inclusiveness, respect, fairness, and trust. You will be given the means and mentorship needed to succeed, and your creativity will be rewarded.About the PositionThe Data Analyst will support a U.S. Government Agency by providing advanced data science, data analytics, statistical analysis, dashboard development, visualization, fraud-risk analysis, and investigative analytical support. This role supports audits, inspections, evaluations, investigations, and other oversight activities through the analysis of structured and unstructured data from multiple internal and external sources. The position plays a key role in supporting oversight and investigative functions by developing defensible, repeatable, and mission-relevant analytical products. The Data Analyst will support audit analytics, investigative analytics, fraud-risk detection and prevention activities, data engineering efforts, reporting requirements, process improvement initiatives, and analytical modernization efforts. This is a full-time role based in Washington, D.C. and is contingent upon award.ResponsibilitiesSupport audit and oversight teams by performing data acquisition, cleaning, normalization, profiling, exploratory analysis, statistical testing, risk scoring, control testing support, exception reporting, dashboard development, and preparation of analytic documentation suitable for inclusion in audit workpapers and reports. Support investigators and related personnel by performing investigative analytics, financial analysis, transaction tracing, relationship and link analysis, event sequencing, timeline development, entity resolution, and preparation of analytical outputs supporting investigative leads, case development, referrals, and prosecution support. Support fraud-risk modeling, hotline and triage analytics, data governance, data quality improvement, process automation, and development of reusable analytical scripts, templates, and dashboards. Receive, review, and clarify task requests; define analytic objectives, data needs, assumptions, dependencies, and timelines; recommend appropriate analytical methods and levels of effort; and track status, milestones, deliverables, and risks. Collect data from government-furnished systems, exports, files, and approved external sources; validate file completeness, schema consistency, format compatibility, and integrity; and document chain of custody or receipt logs when required. Clean and normalize datasets; perform de-duplication, standardization, field harmonization, and date/time normalization; address missing values, outliers, malformed records, and join-key inconsistencies; and create data dictionaries and metadata summaries where needed. Merge and reconcile datasets from multiple sources, perform entity resolution and record linkage, and create analysis-ready datasets. Identify high-risk transactions, vendors, awards, payments, disbursements, travel, payroll, grants, loans, contracts, and other program activities; perform trend, variance, outlier, duplicate, gap, and exception analyses; and support fraud risk indicators and internal control assessments. Assist in the development of population analyses and sampling frames, identify relevant universes and stratification criteria, produce exception lists, and support reconciliations and completeness checks. Analyze financial records, payment streams, invoices, procurement transactions, expense records, and related datasets. Conduct link analysis among individuals, entities, accounts, devices, vendors, addresses, awards, and transactions; perform entity resolution using identifiers and matching techniques; and create relationship charts and investigative visualizations. Apply descriptive and inferential statistical methods; conduct classification, clustering, anomaly detection, forecasting, propensity and risk scoring, and other advanced analytical methods. Develop dashboards, visualizations, reports, heat maps, trend charts, exception summaries, relationship diagrams, geospatial maps, timeline graphics, executive briefings, and technical appendices. Implement quality assurance and governance practices, maintain documentation supporting reproducibility and reviewability, and ensure compliance with applicable security and privacy requirements. Provide knowledge transfer, technical documentation, user guides, demonstrations, methodology briefings, and training support to government personnel. Perform other related duties as assigned. Qualifications Contractor personnel shall possess a bachelor’s degree from an accredited college or university in data science, statistics, mathematics, computer science, information systems, accounting, finance, economics, operations research, business analytics, or a closely related field. Contractor personnel shall possess a minimum of eight (8) years of specialized professional experience performing complex analytical work in support of data analytics, audit analytics, investigative analytics, fraud detection, forensic financial analysis, compliance review, or other closely related mission functions. Qualifying experience shall include the ability to collect, clean, validate, integrate, analyze, and present data from multiple sources; develop dashboards, visualizations, and written analytical products; and clearly communicate methods, assumptions, limitations, and results to Government stakeholders. Proficient in the use of Microsoft365 (including Excel, Access, and Purview), Power BI, Python, Tableau, and Splunk. The contractor shall be a U.S. Citizen and have the ability to obtain and maintain a Secret clearance. Preferred Qualifications An advanced degree in a relevant discipline may be considered advantageous for more complex assignments.Relevant professional certifications are preferred, but not required, and may include Certified Fraud Examiner (CFE), Certified Public Accountant (CPA), Certified Internal Auditor (CIA), Certified Information Systems Auditor (CISA), Certified in Financial Forensics (CFF), or recognized analytics and business intelligence platform certifications. Experience supporting a Federal Office of Inspector General, Federal law enforcement organization, audit organization, or comparable oversight, accountability, or investigative environment. Experience supporting audits, inspections, evaluations, investigations, hotline analysis, or fraud-risk activities. Experience handling sensitive, nonpublic, investigative, procurement-sensitive, or law-enforcement-sensitive information. Experience conducting transaction tracing, anomaly detection, link analysis, entity resolution, timeline analysis, and preparation of analytical products for use by auditors, investigators, attorneys, or senior leadership. Proficient in the use of Salesforce, Oracle, Azure, Entra AD, Intune, Zscaler, and/or Okta.Dexis is on a mission to help solve today’s most pressing global political, social, and economic challenges and create a world where all people are safe and prosperous. As a Dexis employee, you will be challenged, empowered, and mentored. Our motto is “find a way or make a way” — that’s how Dexis goes “all in.” How will you? If you are passionate about this opportunity, apply now! Only those applicants who meet the above criteria will be contacted for interview.Dexis is an Equal Opportunity Employer, and does not discriminate on the basis of race, color, sex, national origin, religion, pregnancy, disability, age, genetic information, military service, veteran status, ethnicity, citizenship, sexual orientation, gender identity, marital status, childbirth and related medical conditions, including lactation, or any other protected class under applicable law.As part of a competitive benefits package for eligible employees, Dexis provides healthcare insurance in addition to other staff welfare benefits and perks.