SQL Database Architect

SQL Database Architect

Full-Time 43200 - 72000 £ / year (est.) No home office possible
J

At a Glance

  • Tasks: Lead the design and optimisation of data integration and identity resolution processes.
  • Company: Coface is a global leader in credit insurance and risk management with 75 years of experience.
  • Benefits: Enjoy a diverse work culture, remote work options, and opportunities for professional growth.
  • Why this job: Join a close-knit team impacting global trade while enhancing your data architecture skills.
  • Qualifications: Bachelor’s or Master’s in Computer Science or related field; 7+ years in data architecture required.
  • Other info: Experience with cloud ecosystems and entity resolution tools is a plus.

The predicted salary is between 43200 - 72000 £ per year.

About Us

Coface is a team of 4,500 people of 78 nationalities across nearly 60 countries, all sharing a corporate culture across the world. Together, we work towards one objective: facilitating trade by helping our 50,000 corporate clients develop their businesses.

With 75 years of experience, Coface is a leader in the credit insurance and risk management market. We have also developed a range of other value-added services, including factoring, debt collection, Single Risk insurance, bonding, and information services.

As a close-knit, international organization at the core of the global economy, Coface offers an enriching work experience on several levels: relational, professional, and cultural.

We are seeking an experienced Business Data Architect – Keying and Linking to lead the design, development, and optimization of keying and linking processes that support enterprise-wide data integration, master data management (MDM), and identity resolution. You will be responsible for creating data architecture strategies that enable the accurate identification, deduplication, and unification of data entities across complex systems and business domains.

  • Design and implement keying and linking architectures to enable accurate entity resolution and data deduplication across diverse data sources.
  • Define and maintain data matching rules and record linkage strategies in support of Multi-sourcing and product 360 initiatives.
  • Collaborate with business stakeholders to gather requirements and translate them into technical design for data integration and unification.
  • Develop data profiling, data quality assessment, and cleansing activities to support accurate keying and linking.
  • Partner with IT and business teams to ensure governance and stewardship policies are upheld across data platforms.
  • Develop and maintain metadata and data lineage for all keying and linking components.
  • Support data modeling efforts for domains such as customer, product, and vendor.

Qualifications:

  • Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Science, or related field.
  • ~7+ years of experience in data architecture, with at least 3 years focused on keying/linking or MDM.
  • ~ Strong understanding of data modeling, data integration, and identity resolution techniques.
  • ~ Hands-on experience with entity resolution tools (Informatica, IBM MDM, Reltio, etc.).
  • ~ Proficiency in SQL and scripting for data profiling and transformation.
  • ~ Familiarity with data governance, privacy regulations (GDPR, CCPA), and data lineage.
  • ~ Experience in cloud-based data ecosystems (AWS, Azure, GCP).
  • Familiarity with graph databases or fuzzy matching algorithms.
  • Experience in financial services, healthcare, retail, or other data-heavy industries.

SQL Database Architect employer: Jobtraffic

Coface is an exceptional employer that fosters a collaborative and inclusive work culture, bringing together a diverse team of 4,500 professionals from 78 nationalities. Located at the heart of the global economy, we offer our employees meaningful opportunities for professional growth and development, alongside competitive benefits and a commitment to work-life balance. As a leader in credit insurance and risk management, joining Coface means being part of a dynamic organisation that values innovation and empowers you to make a significant impact in facilitating trade for our clients.
J

Contact Detail:

Jobtraffic Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land SQL Database Architect

✨Tip Number 1

Familiarise yourself with the specific tools mentioned in the job description, such as Informatica MDM and IBM InfoSphere. Having hands-on experience or even a solid understanding of these platforms can set you apart from other candidates.

✨Tip Number 2

Network with professionals in the data architecture field, especially those who have experience in keying and linking processes. Engaging with industry experts can provide insights into the role and may even lead to referrals.

✨Tip Number 3

Stay updated on the latest trends and best practices in data governance and privacy regulations like GDPR and CCPA. Demonstrating your knowledge in these areas during interviews can show your commitment to compliance and data integrity.

✨Tip Number 4

Prepare to discuss real-world scenarios where you've successfully implemented data integration or entity resolution strategies. Being able to share specific examples will highlight your practical experience and problem-solving skills.

We think you need these skills to ace SQL Database Architect

Data Architecture
Keying and Linking Processes
Master Data Management (MDM)
Entity Resolution Techniques
Data Integration
Data Profiling
Data Quality Assessment
Data Cleansing
SQL Proficiency
Scripting for Data Transformation
Data Governance
Privacy Regulations (GDPR, CCPA)
Metadata Management
Data Lineage
Cloud-Based Data Ecosystems (AWS, Azure, GCP)
Fuzzy Matching Algorithms
Graph Databases
Collaboration with Business Stakeholders
Data Modelling

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights relevant experience in data architecture, keying/linking, and MDM. Use specific examples from your past roles that demonstrate your skills in SQL, data integration, and entity resolution.

Craft a Compelling Cover Letter: Write a cover letter that not only outlines your qualifications but also shows your enthusiasm for Coface's mission. Mention how your experience aligns with their objectives in facilitating trade and supporting corporate clients.

Showcase Technical Skills: In your application, emphasise your hands-on experience with tools like Informatica, IBM MDM, and your proficiency in SQL. Be specific about projects where you applied these skills to achieve successful outcomes.

Highlight Collaborative Experience: Coface values collaboration, so include examples of how you've worked with business stakeholders to gather requirements and translate them into technical designs. This will demonstrate your ability to bridge the gap between technical and non-technical teams.

How to prepare for a job interview at Jobtraffic

✨Showcase Your Technical Skills

Be prepared to discuss your hands-on experience with entity resolution tools like Informatica and IBM MDM. Highlight specific projects where you successfully implemented data architecture strategies, focusing on keying and linking processes.

✨Understand the Business Context

Coface operates in a global environment, so it's crucial to demonstrate your understanding of how data architecture supports business objectives. Research their services and think about how your role as a SQL Database Architect can enhance their operations.

✨Prepare for Scenario-Based Questions

Expect questions that assess your problem-solving skills in real-world scenarios. Be ready to explain how you would approach data integration challenges or improve data quality assessments, using examples from your past experience.

✨Emphasise Collaboration Skills

Since the role involves working closely with IT and business teams, highlight your ability to gather requirements and translate them into technical designs. Share examples of successful collaborations that led to effective data governance and stewardship.

SQL Database Architect
Jobtraffic
J
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>