Data Modelling Specialist

Data Modelling Specialist (KYC/CLM) – Salt Lake City (Hybrid)

Company: Delta Capita
Location: Salt Lake City, USA (Hybrid)

Our Tier 1 Investment Banking client’s Data Modelling team is looking for skilled BI and Data Modelling Specialists to help design and implement data architecture for tracking and reporting on their KYC rolling review process. This role requires experience in building robust data solutions to support end-to-end data processing, from extraction to loading, and ensuring data quality and integrity.

Key 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.

Qualifications:

• 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.

Preferred Skills:

• Familiarity with KYC or compliance data processes.

• Experience in an agile work environment with a track record of delivering complex data solutions.

This position provides an opportunity to work with industry-leading data experts, driving critical compliance initiatives and gaining valuable experience in a fast-paced environment.

Expectations Regarding Hybrid Working:

As we are a Service Provider and Consulting firm servicing clients, our policy on physically working from the office (which may be the client’s offices or our own offices depending on the client) aligns to what our client’s policies and expectations are, and these vary. Most of our clients now require a minimum of 3 days per week in the office, 2 days from home, and accordingly, this is also the minimum expectation that Delta Capita requires. However, some of our clients have now moved up to 4 or even 5 days in the office and we require candidates to be flexible to meet our clients’ demands.

How We Work:

Delta Capita is an equal opportunity employer. We positively encourage applications from suitably qualified and eligible candidates regardless of age, color, disability, national origin, ancestry, race, religion, gender, sexual orientation, gender identity and/or expression, veteran status, genetic information, or any other status protected by applicable law.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. If you require any reasonable adjustments through your interview process, please use the designated space within the application questionnaire.

As the selection and interview process is ongoing, please submit your application in English as soon as possible. If your profile is selected, a member of our team will contact you. For this role a valid work authorization for the US is mandatory.

Who We Are:

Delta Capita is a global capital markets consulting, managed services and technology provider. Delta Capita has a unique combination of experience in Financial Services and technology innovation capability. Headquartered in London with offices around the world, we work with the world’s top financial institutions to help them comply with regulations, simplify operations, reduce costs and innovate their business models and leverage leading financial technology

We believe the future of financial services success rests in looking at organizations with a new lens and a dynamic perspective.

Our mission is to help our clients materially reduce costs by creating and leveraging mutualized platforms and increase revenue by exploring the art of the possible using technology as a key design cornerstone. Our clients range from Tier 1 Investment Banks, Wealth Management firms, Private Banks to Insurance companies. We partner with our clients through the delivery of infrastructure, technology, people, and consulting services across the entire financial services value chain.

Technology is at the heart of our solutions, and as the financial services arm of Prytek, we leverage the substantial FinTech portfolio of the group, allowing us to create new services and operate as a leading FinTech accelerator. We have been on an incredible journey since the business launched in 2012. Currently in seven locations, with over 1000 staff, we seek extraordinary people to join our growing business.

To learn more about Delta Capita and our culture click here: Working at DC - Delta Capita.