Praca: Technical Analyst
Avenga is a global IT and digital transformation champion. We deliver strategy, customer experience, solution engineering, managed services, software products and outsourcing services like: staff augmentation, team leasing and permanent employment.Together, we are more than 2500 professionals with over 20 years of experience. We are present in Europe, Asia and the USA.
Miejsce pracy: woj. kujawsko-pomorskie
Nr ref.: LP/AS/ZD/11
Nr ref.: LP/AS/ZD/11
- Work directly with business subject matter experts to understand data created by different business processes and translate this knowledge into domain data models
- Analyze source system data and data-related system integration challenges to propose appropriate solutions.
- Building understanding of information and data models represented in ER or Semantic notations.
- Create and maintain conceptual, logical and physical data models using best practices to ensure high data quality and easy integration of different systems
- Work with development teams to translate logical data models into physical structures.
- Support development teams in optimizing and updating existing solutions.
- Work with solution architects to develop the solutions that will address business needs.
- Recommend opportunities for reuse of data models in new environments.
- Evaluate data models and physical databases for variances and discrepancies.
- Review new application designs and recommend corrections if required.
- Enhance data analytics pipelines to better fit the need of the business.
- Document the requirements (URS,FS) in ALM tool.
- Sufficient experience in data analysis and modeling is required (must)
- Knowledge of Data Architecture (must)
- Exceptional interpersonal skills (direct work with business) (must)
- Fluent English (must)
- Experience with Oracle (must) and other databases
- Understanding of most common Data Warehousing and Data Modelling concepts
- At least basic knowledge in writing and analyzing SQL, PL/SQL
- Knowledge of NoSQL document databases (especially how to analyse XML/JSON files)
- ER modelling (nice to have)
- UML Modelling (nice to have)
- Use of data modeling tools (ER/Studio & SPARX) (nice to have)
- Knowledge of CDIS, HL7 BRIDG or other Pharma standard models (nice to have)
- Data Vault physical modelling (nice to have)
- Ontology modelling (nice to have)
- Pharma Development knowledge (highly desirable)