For out client EC we are looking for Enterprise Architect
1. DESCRIPTION OF THE TASKS
Following tasks will be performed by external service provider:
• Create architecture models that reflect the organization’s strategies and goals.
• Integrate the project and program strategies and ensure alignment with business strategies and drivers,
and management priorities.
• Analyse the current state of the HR Family data analytics technologies, processes, and services to
identify areas for improvement and create a plan for future development.
• Design the transition strategy from current data analytics tools to the target platform.
• Contribute to the design of HR Family Enterprise Architecture, with focus on data.
• Design Data Warehouse architecture.
• Design, develop and maintain ETL processes to ensure accurate and timely data integration from
multiple sources.
• Create and maintain data marts and dimensional model, and the logic to keep these updated.
• Implement best practices to ensure the integrity of data
• Conduct performance tuning and optimization of the data warehouse environment
• Develop and maintain data models to ensure efficient data storage and retrieval
• Participation in data governance initiatives to uphold data quality standards
• Participation in technical and business meetings with IT and business stakeholders to identify data
needs, clarify requirements, and design solutions
2. KNOWLEDGE AND SKILLS
Following skills and knowledge are required for the performance of the above listed tasks:
• Excellent knowledge of Enterprise Architecture best practices
• Excellent knowledge of Data Warehousing best practices
• Excellent analysis and design skills
• Ability to model data efficiently and fast
• Ability to work on multiple concurrent projects, activities or tasks under time constraints with a proven
ability to meet challenging deadlines
• Ability to give business and technical presentations
• Ability to apply high quality standards
• Ability to cope with fast changing technologies used in data and analytics domain
• Very good communication skills with technical and non-technical audiences
• Analysis and problem solving skills
• Capability to write clear and structured technical documents
• Ability to participate in and drive technical meetings and good communication skills
3. Specific Expertise
Following specific expertise is mandatory for the performance of tasks:
• Excellent ability to analyse, model and interpret data
• Working knowledge of a version control system such as Git
• Excellent Data Vault 2.0 modelling and implementation knowledge
• Extensive experience in data quality applied to Data Warehouse / Data Vault
• Extensive experience in using data warehouse and data vault automation tools such as Datavault
Builder
• Experience of preparing FSD/TSD (Functional/Technical Specification Document) documents from
BRD (Business Requirement Document) / Customer Requirements.
• Thoroughly proficient in SQL, PL/SQL development in Oracle. Expertise in other programming
languages such as Python or JavaScript is considered a big plus
• Working knowledge in cloud platforms such as Microsoft Azure or AWS
• Experience with Microsoft Azure Cloud platform and related components, SQL Server on Azure,
Azure Data Factory and Azure Synapse is considered a plus
• Experience working within an Agile/Scrum environment
• A valid certification in a recognized quality assurance standard is considered a plus (i.e. ISTQB),
certification in data and analytics testing is considered a plus (i.e. DAU-CDAT)
• More than 10 years’ experience in the abovementioned field
4. Certification and Standards
Following certificates & standards are considered a plus for the performance of tasks:
• Data Vault 2.0 Practitioner certification
• Good knowledge and ideally certification in the area of Artificial Intelligence in the data management
activities
• Certification in Microsoft Fabric Analytics Engineer
• Certification in Microsoft Azure Data Engineer
• Certification in Data Vault
5. Service Delivery
• The services shall be performed remotely in Near-Site location allowing to reach the Commission
premises in Brussels within 2 hours.
Laptop will be provided by the Commission.
The external service provider may be requested to participate in the meetings with the Commission’s
services in Brussels (and exceptionally in other locations).