Reports, Automation Specialist

This is a fully remote position, open to applicants in United States.

📋 Description

• Conduct analysis, design, implementation, testing, and maintenance of both recurring and ad-hoc operational reports within the USCIS Centralized Data Repository (CDR).

• Create and enhance automated processes for data collection, processing, report generation, and distribution.

• Assist in the collection, transformation, and integration of data from platforms such as Amazon Connect, Salesforce, chat services, and other authorized sources.

• Ensure the preparation of daily, weekly, monthly, quarterly, and annual reports in compliance with USCIS standards and timelines.

• Aid in the creation, maintenance, and improvement of reports and interactive dashboards.

• Evaluate incoming data, pinpoint missing files or irregular statistics, and facilitate the resolution of reporting discrepancies.

• Identify manual reporting tasks that can be automated and implement approved enhancements.

• Oversee automated data imports, scheduled reporting tasks, and related processes.

• Generate specialized data extracts, reports, and analytical products to meet USCIS operational needs.

• Test new and modified reports, automated workflows, and enhancements to reporting systems prior to deployment.

• Maintain documentation for reporting, operational procedures, automation workflows, and records of system modifications.

• Collaborate with USCIS stakeholders, technical teams, and external vendors.

• Provide continuous technical and analytical support for the CDR and associated reporting processes.

⛳️ Requirements

• An associate's degree or higher is required.

• A minimum of 5 years of experience in the Information Technology sector is essential.

• Capability to analyze, design, implement, test, and maintain reports and information technology processes.

• Ability to support enhancements to reporting systems, technical documentation, and ongoing system maintenance.

• Strong analytical skills with a keen attention to detail.

• Proficient in troubleshooting technical issues and effectively communicating findings.

• Selected applicants must undergo a security investigation and meet eligibility criteria for access to relevant government information and systems.

• A satisfactory USCIS Enter-on-Duty (EOD) determination is required before commencing work.

• Must have the ability to obtain and maintain the necessary government suitability determination.

• Preferred: experience in developing automated reports, data processing workflows, or business intelligence solutions.

• Preferred: familiarity with Amazon QuickSight, Amazon Connect Reporting, Crystal Reports, or similar reporting tools.

• Preferred: proficiency in SQL queries, relational databases, or data extraction and transformation techniques.

• Preferred: experience utilizing Python or PowerShell for automating reporting functions.

• Preferred: knowledge of AWS cloud services, including Amazon S3.

• Preferred: experience in designing dashboards, analyzing large datasets, and validating reporting outputs.

• Preferred: advanced skills in Microsoft Excel, including data analysis and reporting automation.

• Preferred: familiarity with Jira, Confluence, SharePoint, or enterprise change management tools.

• Preferred: experience in supporting federal reporting systems or large-scale customer service operations.

🏝️ Benefits

• Mentorship and a collaborative work environment.

• Opportunities for career advancement and contributions to strategic objectives.

• Exposure to enterprise reporting and automation technologies.

• Opportunities to gain expertise in data automation, enterprise reporting integration, dashboard development, and large-scale operational analytics.