[Hiring] Reports/Automation Specialist @JCTM

Role Description

This position is contingent upon JCTM receiving a contract award and authorization to proceed. Employment opportunities and anticipated start dates are dependent upon contract award, government approval, and satisfaction of applicable onboarding and suitability requirements.

USCIS relies on accurate and timely reporting to evaluate customer service operations across telephone, chat, and digital communication channels. JCTM is seeking a Reports/Automation Specialist to develop, maintain, and improve automated reporting processes that support data integrity, operational visibility, and informed decision-making.

Key Responsibilities

• Report Development and Maintenance:
  • Analyze, design, implement, test, and maintain recurring and ad-hoc operational reports within the CDR environment.
• Reporting Automation:
  • Develop and improve automated processes supporting data collection, processing, report generation, and distribution.
• Data Integration:
  • Support the collection, transformation, and integration of reporting data from Amazon Connect, Salesforce, chat platforms, and other authorized sources.
• Recurring Reporting:
  • Maintain daily, weekly, monthly, quarterly, and annual reports in accordance with established USCIS requirements and delivery schedules.
• Dashboard Development:
  • Support the creation, maintenance, and enhancement of reports and interactive dashboards using Amazon QuickSight, Amazon Connect Reporting, Crystal Reports, or comparable tools.
• Data Quality Assurance:
  • Review incoming data, identify missing files or anomalous statistics, and coordinate the resolution of reporting discrepancies.
• Process Improvement:
  • Identify manual reporting activities suitable for automation and implement approved improvements to reliability and operational efficiency.
• Automated Task Monitoring:
  • Monitor automated data imports, scheduled reporting tasks, and related processes to identify performance issues and implement corrective actions.
• Ad-Hoc Analysis:
  • Prepare specialized data extracts, reports, and analytical products in response to USCIS operational requirements.
• Testing and Validation:
  • Test new and modified reports, automated workflows, and reporting system enhancements before deployment.
• Technical Documentation:
  • Maintain reporting documentation, operational procedures, automation workflows, and records of system modifications.
• Cross-Functional Coordination:
  • Collaborate with USCIS stakeholders, technical teams, and external vendors to ensure reporting requirements are understood and implemented effectively.
• System Support:
  • Provide ongoing technical and analytical support for the CDR and associated reporting processes.

Qualifications

• Associate's degree or higher.
• Minimum of 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.

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.

Clearance

Applicants selected will be subject to a security investigation and must meet eligibility requirements for access to applicable government information and systems. This position requires a satisfactory USCIS Enter-on-Duty (EOD) determination prior to beginning work and the ability to obtain and maintain the required government suitability determination.

Compensation

JCTM is committed to fair and transparent compensation practices. The anticipated compensation for this position will be determined based on a variety of job-related factors, which may include the candidate’s relevant education, training, certifications, security clearance and access requirements, years and depth of relevant experience, specialized skills and qualifications, position level, assigned responsibilities, work location, applicable contract or customer requirements, internal equity, and the approved compensation budget for the position.

Equal Opportunity Employer Statement

JCTM is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.