Technical Engineer

Prism IT Global; Plano (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Prism IT Global is seeking a skilled IT professional to support Fraud and AML Risk Management applications within the Risk, Legal, and Compliance domain. You will assist with enhancements, bug fixes, and data integration across platforms while ensuring security and regulatory compliance.

The role emphasizes MS SQL expertise, Power BI reporting, and PowerShell scripting to automate data tasks and support enterprise data governance.

Qualifications

• Advanced MS SQL skills and data engineering mindset.
• Experience designing and building Power BI reports and dashboards.
• Scripting in PowerShell to automate data tasks and workflows.
• Experience integrating multiple data sources via APIs and ETL processes.
• Understanding of risk, fraud, and AML domains and related regulations.

Responsibilities

• Assist with enhancements and bug fixes for Fraud and AML Risk Management apps.
• Develop SRSS reports in FCRM Data Mart; update ETL jobs to stay in sync with PROD.
• Collaborate with 3rd party data sources (Premier, Q2, MANTL, Cenlar, etc.) for data extraction.
• Capture technical requirements from stakeholders for integrations and implementations.
• Advise on onboarding new tenants/products into FCRM and related systems.
• Configure workflows in FCRM; support API-driven information relay between systems.
• Ensure SOX IAM controls and enterprise security policies are met.

Skills

MS SQL

Power BI

PowerShell

API integration

Data engineering

Tools

Premier

Q2

MANTL

Cenlar

Wholesale Intelligence

Job description

• Working closely with the Product Owner, the Toyota IT Domain Teams, the business, the Technical Engineer will assist in all internal support function roles to sustain the Fraud and AML Risk Management applications and tools under the Risk, Legal, and Compliance domain of TFS(TMCC) with the goal of keeping them viable as needed to meet the strategic goals of the organization.
• Assist with efforts to support FCRM operations with enhancements and bug fixes and conforms with industry standards and complies with Information Technology and InfoSec requirements around securitization of PII and confidential information maintained in these platforms.
• Assist with development of SRSS reports within the FCRM Data Mart including the required efforts to update any ETL jobs to ensure that the data remains in sync with the current FCRM PROD environment and any other data that product or TFS would require for reporting.
• Work closely with the Fraud Factory to engage with BSA/AML teams to identify customer fields not currently available in the Premier to FCRM Mapper to devise and develop an automated solution that extracts key data in Premier and inserts into FCRM via custom scripts that can set up on a job scheduler and can be adjusted as needed.
• Elicit and capture the technical requirements for FCRM enhancements, integrations and implementations from internal stakeholders including extractions of additional data from Fiserv Premier, Q2, Payments Exchange, MANTL, Cenlar, and Wholesale Intelligence applications and platforms to assist with regulatory requirements for transaction monitoring, OFAC and Watchlist scanning, Customer Risk Rating, and overall Fraud and AML risk mitigation.
• Work with domain team on functional and technical components of the implementation project including product configuration, interfaces, installation, and testing, placing a priority on the use of API’s to relay information and decisions that drive actions across divergent systems to reduce manual processes and touchpoints between divergent teams that impact the Fraud and AML operational processes.
• Working with internal partners within the domain and the Product Owner by providing technical and data engineering perspective on 3rd party data integration into FCRM, Zodiac, and/or Hunter (Experian), including potential automation of data from Point-Predictive, Sentilink, TransUnion, LexisNexis, Carfax, NICB, Q2, Plaid, and other industry add-on tools where possible.
• Working with the Product Owner, serve as an advisor from a technical and data engineering perspective on the onboarding of all new tenants (new OEM’s) or products (Income Driver) into FCRM and/or other case management systems as needed in support of the continued expansion of Private Label Growth (PLG) initiatives.
• Convey general information to the domain concerning platform compatibility and other technical standards of the solution.
• Advanced expertise in MS SQL to facilitate the implementation of diverse solutions while ensuring the integrity of the core codebase remains unaffected.
• Extensive experience with FCRM especially the ability to configure workflows and covert specifications into scenarios. Real time scenario configuration experience would be beneficial.
• Extensive experience in developing and designing Power BI reports.
• Extensive experience in developing and designing PowerShell scripts.
• Ensure compliance of Fraud and BSA/AML technology with enterprise infrastructure policy, procedures and industry best practices, including but not limited to SOX Compliance, Identity and Access Management, Control M functions, etc.