Reports/Automation Specialist

Reports/Automation Specialist

Location: Remote

Contract Status: Pending Award

Notice: 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.

The Challenge

What if your data reporting and automation expertise could improve how federal decision-makers access critical operational information? 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.

Build Your Career

At JCTM, we value knowledge, experience, integrity, and commitment. Joining our team means becoming part of an organization that empowers individuals, prioritizes ethical practices, and fosters a culture of collaboration and growth.

Challenging Projects

As a Reports/Automation Specialist with JCTM, you will support the analysis, design, implementation, testing, and maintenance of periodic and ad-hoc reports within the USCIS Centralized Data Repository (CDR). You will help maintain reporting processes, develop automation improvements, validate data accuracy, and support the continued operation of reporting systems serving multiple USCIS programs.

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.

State-of-the-Art Technology

Expand your expertise through enterprise reporting and automation technologies, including Amazon Connect Reporting, Amazon QuickSight, AWS-hosted data environments, SQL databases, and business intelligence tools.

New Skills

Work alongside systems analysts, business analysts, technical developers, and federal program stakeholders while gaining additional experience in data automation, enterprise reporting integration, dashboard development, and large-scale operational analytics.

Room to Grow

You will have opportunities to grow your career and contribute to the company's strategic goals, supported by mentorship and a collaborative work environment.

You Have

• 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. Where required by applicable state or local law, JCTM will include the applicable good-faith salary or hourly pay range, along with any required information regarding benefits and other compensation, in the job posting.

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.