Data Architect
About the job you’re considering
We are looking for a data architect to become part of our data integration and design, data governance, data catalog discussions. Based in anywhere in the UK, we are seeking someone who understands data mappings from different systems and is able to Identify main entities from different systems and identify their mandatory fields and key columns and alignment with EDM(enterprise data model).This role will also see you consult BAs while preparing functional specifications documents and create conceptual, logical and physical data models in Erwin.
Hybrid working: The places that you work from day to day will vary according to your role, your needs, and those of the business; it will be a blend of Company offices, client sites, and your home; noting that you will be unable to work at home 100% of the time.
If you are successfully offered this position, you will go through a series of pre-employment checks, including:identity, nationality (single or dual) or immigration status, employment history going back 3 continuous years, and unspent criminal record check (known as Disclosure and Barring Service)
Your Role- Drive and manage the development and maintenance of Data Architecture artifacts aligning to the enterprise architecture standards
- Implement the right Data management Frameworks and Practices
- Work with Enterprise-wide Data Transformation Programs and design data flows /architecture designs for Data Management
- Works closely with business partners, product owners and stakeholders to understand business needs and determines data requirements supporting reporting, analytics, application development and/or integrations, to convert the data requirements and corresponding logical models into physical models
- Identify and propose data model and data integration improvements
- Ensures ongoing effective & efficient documentation of data requirements to support the build of logical and physical data models, extraction and transformation pipelines, data stores and reports in-line with business requirements and/or solution documentation
- Working on multiple data transformation projects, creating master data elements excel files for each domain
- Understand and meet referential data integrity requirements based on business needs. Develop and/or assist in generating source to target data mapping.
- Designs and creates logical and physical model designs utilizing best practices and established organization standards, supporting the implementation of the data lake(s), data marts and operational data stores as part of the overall established enterprise data architecture
- Understand existing environment and landscape and envisage better solutions/ tools for implementing the data governance framework
- Conceptualize technical implementation, strategize solutions, and evaluate the best suited tool
- Gather data requirements and implement the right solutions
- Liaise with business and IT teams to solve the data related challenges
You can bring your whole self to work. At Capgemini equity, diversity and inclusion is part of everyday life, and will be part of your working reality. We have built an inclusive and welcoming environment, for everyone.
Your skills and experience- Hands on experience building enterprise grade data models.
- Hands on experience with relational modeling, domain modeling, and dimensional modeling
- Experience with data modeling tools such as Erwin, Visio, Sparx Enterprise Architect
- Experience with business and technical requirements analysis
- Solid understanding of architecture principles and frameworks
- Solid understanding of ETL design patterns, methodologies, and tools
- Solid understanding BI & Data warehouse, Master data management, data profiling, data catalogue and data quality tools
- Hands-on in designing conceptual, logical, and dimensional data models and flowcharts
- Experience of working remote teams across geographies
- Experience on ETL implementations
- Strong attention to detail and outstanding communication and organizational skills
- Excellent communication and troubleshooting skills
- Experience working with Agile Methodology
Your security clearance
To be successfully appointed to this role you will need to undergo Baseline Personnel Security Standard checks.There are no nationality or residency restrictions, although if you have resided outside of the UK within the last 3 years, further checks may be required.
There are other criteria and check required for BPSS, and throughout the recruitment process, you will be asked questions about your security clearance eligibility such as, but not limited to, country of residence and nationality.
What does ‘Get The Future You Want' mean for you?
You’d be joining an accredited Great Place to work for Wellbeing in 2024. Employee wellbeing is vitally important to us as an organisation. We see a healthy and happy workforce a critical component for us to achieve our organisational ambitions.
To help support wellbeing we have trained ‘Mental Health Champions’ across each of our business areas, and we have invested in wellbeing apps such as Thrive and Peppy.
You’ll be bringing your unique skills and perspectives to the team, inspiring and taking inspiration from your teammates as you unlock value in everything you do. You’ll be joining a professional community of experts, who have got your back and will support you, every step of the way.
Capgemini. Get The Future You Want.
Why you should consider Capgemini
Growing clients’ businesses while building a more sustainable, more inclusive future is a tough ask. When you join Capgemini, you’ll join a thriving company and become part of a diverse collective of free-thinkers, entrepreneurs and industry experts.We find new ways technology can help us reimagine what’s possible. It’s why, together, we seek out opportunities that will transform the world’s leading businesses, and it’s how you’ll gain the experiences and connections you need to shape your future.
By learning from each other every day, sharing knowledge, and always pushing yourself to do better, you’ll build the skills you want. You’ll use your skills to help our clients leverage technology to innovate and grow their business. So, it might not always be easy, but making the world a better place rarely is.
About Capgemini
Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries.With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fuelled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem.
The Group reported 2023 global revenues of €22.5 billion.