Guidehouse Senior Consultant – Global Investigations & Compliance - Technology in New York, New York
Guidehouse is a leading global provider of consulting services to the public and commercial markets with broad capabilities in management, technology, and risk consulting. We help clients address their toughest challenges and navigate significant regulatory pressures with a focus on transformational change, business resiliency, and technology-driven innovation. Across a range of advisory, consulting, outsourcing, and digital services, we create scalable, innovative solutions that prepare our clients for future growth and success. The company has more than 10,000 professionals in over 50 locations globally. Guidehouse is a Veritas Capital portfolio company, led by seasoned professionals with proven and diverse expertise in traditional and emerging technologies, markets, and agenda-setting issues driving national and global economies. For more information, please visit: www.guidehouse.com.
Participate on teams that guide clients through the selection, implementation, testing, and calibration/tuning of financial crime compliance technology solutions, covering transaction monitoring, sanctions compliance, KYC/CDD, blockchain analysis, and fraud prevention solutions.
Participate in projects that evaluate, test and review the supporting documentation for the selection and implementation of BSA/AML and sanctions technology solutions, including the selection of detection scenarios and determination of scenario thresholds and name matching algorithms.
Identify, research, and organize electronic information to assess the appropriateness and sufficiency of data to facilitate effective analysis.
Identify the relationships among multiple sources and types of information to identify duplicates, understand data flow, interrogate data, and identify patterns.
Analyze and interpret historical financial, operational, and transactional data.
Prepare reports, written analyses, quantitative exhibits, and other client deliverable regarding project and/or results of work performed.
Maintain detailed working records reflecting assumptions, methodologies, and information sources employed during the performance of all analytical tasks.
Participate in client meetings to review results of work performed.
Maintain professional image within the company and project the same to those outside of the company.
Able and willing to relocate to either NY or DC if not currently based there.
Bachelor’s degree from an accredited college/university.
Fluency in Microsoft SQL Server
Able to perform ad-hoc analysis in real time using T-SQL queries.
Experience developing complex functions and stored procedures.
Familiar with designing and working with database objects including tables, relationships, constraints, triggers and views.
In-depth knowledge of standard concepts, practices and procedures related to database management.
Experience analyzing and visualizing data
Ability to independently analyze, and gather insights from data in real time.
Knowledge of statistical methods & scripting (SQL, Python or R, PowerShell).
Experience with visualization of data including Tibco Spotfire, Tableau, R, PowerPivot, PowerBI, Excel and others.
Data Loading and Transformation
Experience with developing SSIS packages.
Experience designing ETL processes to transform and load various structured data formats.
Intellectual curiosity and the ability to ask probing, thoughtful questions and examine data from all angles/perspectives.
Able to manage several projects simultaneously and autonomously.
Strong conceptual as well as quantitative and qualitative analytical skills.
2+ years of experience within financial services or financial technology (fintech) industry.
5+ years of professional work experience.
Experience in a management consulting/advisory company.
Solid programming skills related to data processing and model building (including C#, C++, Python, Scala, Java etc.)
Understanding of transactions data, e.g. SWIFT, Fedwire, ACH, SEPA.
Experience with vendor-based solutions, such as Detica, Actimize, Oracle Mantas, Fircosoft, SAS, HotScan, Quantexa, SafeWatch, CipherTrace, Chainanalysis, Elliptic, etc.
Experience with data science, machine learning, and statistics.
Previous BSA/AML and Sanctions systems analytics experience including creating and reviewing data models; calibrating/tuning BSA/AML and Sanctions systems; developing, reviewing, and validating data/process flows; reviewing supporting documentation for thresholds, detection scenario selection and matching algorithms; and performing tests and reviews of detection scenario functionality.
Travel as required based on engagements.
The successful candidate must not be subject to employment restrictions from a former employer (such as a non-compete) that would prevent the candidate from performing the job responsibilities as described.
Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.
Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.
If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.
Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.
Rewards and Benefits
Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
This position may be eligible for a discretionary variable incentive.
Medical, Rx, Dental & Vision Insurance
Personal and Family Sick Time & Company Paid Holidays
Parental Leave and Adoption Assistance
401(k) Retirement Plan
Basic Life Voluntary Life Insurance
Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
Short-Term & Long-Term Disability
Tuition Reimbursement, Personal Development & Learning Opportunities
Skills Development & Certifications
Employee Referral Program
Corporate Sponsored Events & Community Outreach
- Guidehouse Jobs