Vacancy expired!
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.
Currently NO visa sponsorship available- Required:
- Able and willing to work a hybrid schedule (both in Guidehouse's NY or DC office and remotely) when needed.
- 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, Snowflake or Redshift); Python or R, PowerShell a plus.
- Experience with visualization of data including Tibco Spotfire, Tableau, R, PowerPivot, PowerBI, Excel and others.
- 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.
- Preferred:
- Local to NYC or DC
- 2+ years of experience within financial services or financial technology (fintech) industry.
- 4+ years of professional work experience.
- Experience in a management consulting/advisory company.
- Solid programming skills related to data processing and model building (such as C#, C, Java, Scala, R and Python)
- Understanding of transactions data, e.g. SWIFT, Fedwire, ACH, SEPA.
- Experience with software vendors servicing the financial crimes market.
- 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:
- 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.
Vacancy expired!