Senior Production Support Engineer – NICE ActimizeETL

Req number:

Employment type:

Worksite flexibility:

CAI is a global services firm with over 9000 associates worldwide and a yearly revenue of $1.3 billion. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients colleagues and communities. As a privately held company we have the freedom and focus to do what is rightwhatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

Job Description

We are looking for a Senior Production Support Engineer NICE Actimize/ETL to manage and optimize production operations for financial crime detection platforms. This position will be full-time and remote.

What Youll Do

• Actimize Application & Platform Support (L2/L3)

• Incident & Problem Management: Provide end-to-end support for core Actimize platforms including SAM (Suspicious Activity Monitoring) UDM (Universal Data Model) CDD (Customer Due Diligence) and ActOne

• System Troubleshooting: Actively investigate diagnose and resolve platform issues related to Actimize risk-case generation alert processing engines and the Risk Case Manager (RCM) worker processes

• Root Cause Analysis (RCA): Spearhead technical investigations on high-impact incident tickets using tools like ServiceNow or Jira publishing precise technical post-mortems and long-term resolution paths

• Environment Maintenance: Lead hotfix and emergency patch installations supporting platform upgrades and regular deployments across development staging and production clusters

• Database Data Auditing & SQL Optimization

• Production Debugging: Write complex highly optimized SQL queries stored procedures joins and indexing tasks to parse and resolve data discrepancies across high-volume relational systems like Oracle MS SQL Server or PostgreSQL

• Database Performance Tuning: Track background performance locks database fragmentation and blocking processes to ensure query executions do not breach defined production latency thresholds

• Data Rectification: Formulate safe data-patching scripts to fix upstream corruption issues affecting Actimize reporting metrics without violating data schema rules

• ETL & Batch Pipeline Monitoring

• Batch Operations Management: Monitor and support overnight ETL batch loads automated data feeds and incoming file ingestion pipelines

• Pipeline Debugging: Quickly isolate and correct pipeline breaks stemming from malformed source data arrays or schema mismatches in data integration routines

• Automation Engineering: Build or improve operating system wrappers using Linux Shell Scripting (Bash) or Python to automate repetitive pipeline verification checklists and reduce manual validation workloads

• Scheduling Governance: Schedule monitor and optimize orchestration tasks using commercial enterprise work schedulers such as Control-M Autosys or UC4

What Youll Need

Required:

• 5 years of experience in database data auditing and SQL optimization

• Expertise in writing optimized SQL queries stored procedures joins and indexing tasks

• Proven ability to debug pipeline breaks and manage ETL batch operations

• Experience with enterprise work schedulers such as Control-M Autosys or UC4

• Proficiency in Linux Shell Scripting (Bash) or Python

Preferred:

• Familiarity with NICE Actimize modules including SAM UDM CDD and ActOne

• Hands-on experience with incident management tools like ServiceNow or Jira

Physical Demands

• Ability to safely and successfully perform the essential job functions

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings etc

• Ability to conduct repetitive tasks on a computer utilizing a mouse keyboard and monitor

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application interviewing completing any pre-employment testing or otherwise participating in the employment selection process please direct your inquiries to or (888).