Reports/Automation Specialist
About The Position
The Reports/Automation Specialist supports the analysis, design, implementation, testing, and maintenance of periodic and ad-hoc reports within the USCIS Centralized Data Repository (CDR). The role helps maintain reporting processes, develop automation improvements, validate data accuracy, and support reporting systems serving multiple USCIS programs. The specialist develops and improves automated processes for data collection, processing, report generation, and distribution; integrates reporting data from sources such as Amazon Connect, Salesforce, and chat platforms; and maintains recurring reports on established USCIS schedules. The position also supports dashboards and reporting tools, data-quality reviews, ad-hoc analysis, workflow testing, technical documentation, and ongoing system support. The role involves coordination with USCIS stakeholders, technical teams, and external vendors. This remote position is contingent upon JCTM receiving a contract award and authorization to proceed. A satisfactory USCIS Enter-on-Duty determination and required government suitability determination are required before work begins. Compensation will be determined based on job-related factors; no specific salary range is stated.
Requirements
- Associate's degree or higher.
- At least 5 years of experience in the Information Technology field.
- Ability to analyze, design, implement, test, and maintain reports and information technology processes.
- Ability to support reporting system enhancements, technical documentation, and ongoing system maintenance.
- Strong analytical skills and attention to detail.
- Ability to troubleshoot technical issues and communicate findings effectively.
- Must meet eligibility requirements for access to applicable government information and systems.
- Must receive a satisfactory USCIS Enter-on-Duty determination before beginning work and be able to obtain and maintain the required government suitability determination.
Nice To Haves
- Experience developing automated reports, data processing workflows, or business intelligence solutions.
- Experience with Amazon QuickSight, Amazon Connect Reporting, Crystal Reports, or comparable reporting tools.
- Proficiency with SQL queries, relational databases, or data extraction and transformation techniques.
- Experience using scripting or programming languages such as Python or PowerShell to automate reporting functions.
- Familiarity with AWS cloud services, including Amazon S3.
- Experience designing dashboards, analyzing large datasets, and validating reporting outputs.
- Advanced Microsoft Excel skills, including data analysis and reporting automation.
- Familiarity with Jira, Confluence, SharePoint, or enterprise change management tools.
- Experience supporting federal reporting systems or large-scale customer service operations.
Responsibilities
- Analyze, design, implement, test, and maintain recurring and ad-hoc operational reports within the CDR environment.
- Develop and improve automated processes for data collection, processing, report generation, and distribution.
- Support collection, transformation, and integration of reporting data from Amazon Connect, Salesforce, chat platforms, and other authorized sources.
- Maintain daily, weekly, monthly, quarterly, and annual reports according to USCIS requirements and delivery schedules.
- Support the creation, maintenance, and enhancement of reports and interactive dashboards using Amazon QuickSight, Amazon Connect Reporting, Crystal Reports, or comparable tools.
- Review incoming data, identify missing files or anomalous statistics, and coordinate resolution of reporting discrepancies.
- Identify manual reporting activities suitable for automation and implement approved improvements to reliability and operational efficiency.
- Monitor automated data imports, scheduled reporting tasks, and related processes; identify performance issues and implement corrective actions.
- Prepare specialized data extracts, reports, and analytical products in response to USCIS operational requirements.
- Test new and modified reports, automated workflows, and reporting system enhancements before deployment.
- Maintain reporting documentation, operational procedures, automation workflows, and records of system modifications.
- Collaborate with USCIS stakeholders, technical teams, and external vendors to understand and implement reporting requirements.
- Provide ongoing technical and analytical support for the CDR and associated reporting processes.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Education Level
Associate degree
