Data Modeller

Arca Blanca has a mission to disrupt the management consulting industry by delivering better outcomes, faster and with greater precision using data. You will have the opportunity to help build a growing business that is bringing original solutions to interesting and multi-faceted client issues with some of the UK’s leading companies. We combine data science and transformation and, as such, we challenge the methods that traditional management consultancies adopt.  

Whilst no two projects are the same, you can be sure that each one will be challenging and complex, testing your resilience, thinking, and influencing skills as you engage with the client to take them on the change journey. You will see the impact of your work on clients’ businesses in terms of growth, profit and value. Our flat structure means that you will be integral in shaping the culture and employee experience at Arca Blanca whilst rapidly developing your own skills and progressing your career. At present, our projects are UK based and predominantly in London. We offer an innovative and generous benefits package including a well-being allowance, flexible leave policies, all travel costs and market-leading health cover. 

Key Responsibilities 

  • Understand and translate business needs into data models supporting long-term solutions. 
  • Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models. 
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy. 
  • Create operational and analytical data models (3NF and Dimensional) 
  • Leverage NoSQL technologies where appropriate (Document, graph databases) 
  • Optimize and update logical and physical data models to support new and existing projects. 
  • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models. 
  • Perform reverse engineering of physical data models from databases and SQL scripts. 
  • Analyse data-related system integration challenges and propose appropriate solutions. 
  • Develop data models according to company standards. 
  • Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces. 
  • Review modifications to existing software to improve efficiency and performance.
  • Examine new application design and recommend corrections if required. 

Personal Characteristics 

  • Flexible and proactive, with the ability to prioritise effectively  
  • Strong interpersonal skills to develop excellent internal relationships as well as with clients and suppliers 
  • A collaborative and creative strong team player 
  • Ability to see each new projects as a challenge to problem solve an innovative and unique solution for 
  • A self-starter who is comfortable working with ambiguity and can take the initiative to move the agenda forward  

 Desired Skills and Experience 

  • 4- 5+ years’ experience within Data Modelling 
  • Communication and presentation experience 
  • Good knowledge of SQL, operational and analytical data modelling best practices  
  • Metadata management experience 
  • Consultancy experience a plus 
  • High level of experience with Python a plus 

Benefits 

  • Competitive salary plus bonus 
  • Salary-sacrifice pension, health cover, critical illness and life assurance 
  • 25 days holiday + several flexible leave policies 
  • Well-being allowance 

How to apply

Please submit a covering letter, together with your CV to recruitment@arcablanca.com