This job is closed
We regret to inform you that the job you were interested in has been closed. Although this specific position is no longer available, we encourage you to continue exploring other opportunities on our job board.
Delta Capita - Salt Lake City, UT
posted 2 months ago
Full-time - Mid Level
Hybrid - Salt Lake City, UT
501-1,000 employees
About the position
The Data Modelling Specialist (KYC/CLM) role at Delta Capita involves designing and implementing data architecture to support the KYC rolling review process for a Tier 1 Investment Banking client. This position requires expertise in building robust data solutions that ensure data quality and integrity throughout the end-to-end data processing lifecycle, from extraction to loading.
Responsibilities
- Design and create data architecture to support the KYC rolling review process, tracking client information and compliance status.
- Utilize Alteryx and SQL to build ETL processes that extract data from multiple systems, transform it according to business requirements, and load it into well-defined SQL tables.
- Develop and document efficient SQL scripts and workflows in Alteryx for large-scale data processing.
- Collaborate closely with cross-functional teams to understand business needs and translate them into data requirements.
- Conduct regular data quality checks and optimize data workflows to enhance reporting accuracy and efficiency.
Requirements
- Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
- 3+ years of experience with Alteryx and SQL, including hands-on experience with ETL processes.
- Strong understanding of data modelling principles and experience in creating SQL tables and views.
- Proven experience in data transformation and loading techniques to ensure data is ready for reporting and analysis.
- Ability to work in a collaborative, hybrid environment, managing tasks both in-office and remotely.
Nice-to-haves
- Familiarity with KYC or compliance data processes.
- Experience in an agile work environment with a track record of delivering complex data solutions.
Benefits
- Equal opportunity employer
- Flexible working arrangements
- Opportunity to work with industry-leading data experts
- Support for individuals with disabilities
