Data Analyst

Responsibilities

• Oversee the collection, receipt validation, and recordkeeping of monthly application registration data from Accrediting Entities (AEs).
• Analyze monthly data by country to identify trends, anomalies, areas for improvement, and actionable recommendations.
• Produce monthly reports, summaries, and leadership readouts, maintaining supporting materials in OneNote.
• Maintain the Adoption Tracking System (ATS) with monthly, semi-annual, and annual data, ensuring data accuracy and integrity across records.
• Conduct data reconciliation to remove duplicates and inconsistent naming conventions, upholding consistent data standards across systems.
• Monitor changes in Adoption Service Provider (ASP) accreditation status and coordinate timely updates with Accrediting Entities.
• Support provider change requests and respond to ATS inquiries from Accrediting Entities, Adoption Service Providers, and government personnel.
• Generate country-specific and provider-specific reports to support leadership briefings, travel planning, meetings, and operational analysis.
• Utilize the CLEAR Adoption Dashboard within the Consular Launchpad for Enterprise Analytics and Reporting to fulfill data requests and validate reporting accuracy.
• Review dashboards and reports for inconsistencies, document discrepancies, and coordinate corrective actions with stakeholders.
• Download, manipulate, and analyze data to support ad hoc reporting requirements and leadership requests.
• Compile and analyze statistical data for the Annual Report to Congress, including narrative explanations, historical comparisons, trend analysis, and anomaly identification.
• Coordinate with internal stakeholders to ensure completeness, accuracy, and timely clearance of annual reporting requirements.
• Prepare statistical information for publication on government websites and provide data updates to international stakeholders as required.
• Develop meaningful data visualizations, dashboards, charts, and graphics to communicate operational metrics and performance indicators.
• Create visual reporting products using complaint registry data, accreditation information, and monthly and semi-annual reporting data.
• Prepare executive presentations, briefing materials, and reports using Microsoft PowerPoint and other Microsoft Office applications.
• Maintain organized documentation and knowledge management resources within OneNote and SharePoint to support continuity of operations.
• Identify opportunities to improve reporting processes, workflow efficiencies, and data quality while ensuring compliance with policies and procedures.
• Collaborate effectively with government personnel and cross-functional teams, maintaining professionalism, confidentiality, and strong customer service.

Requirements

• Bachelor's degree required; five years of government experience (preferably supporting the Department of State) may substitute for the degree.
• Minimum of three years of experience in a professional office environment.
• Proven experience analyzing data, identifying trends, and preparing reports for executive or senior leadership.
• Strong analytical, organizational, and problem-solving skills with meticulous attention to detail.
• Excellent written and verbal communication skills.
• Proven ability to manage multiple priorities while meeting deadlines in a fast-paced environment.
• Proficiency with Microsoft Office Suite, including Excel, Word, PowerPoint, Outlook, Teams, and SharePoint.
• Experience using OneNote for documentation and knowledge management.
• Ability to exercise sound judgment, maintain confidentiality, and work independently with minimal supervision.

Technologies

• Microsoft Excel
• Microsoft Word
• Microsoft PowerPoint
• Microsoft Outlook
• Microsoft Teams
• SharePoint
• OneNote
• Adoption Tracking System (ATS)
• Consular Launchpad for Enterprise Analytics and Reporting (CLEAR) Adoption Dashboard
• Microsoft Power BI