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.
Technical Analyst
Miejsce pracy: woj.
warmińsko-mazurskie
Nr ref.: LP/AS/ZD/11
Nr ref.: LP/AS/ZD/11
Tasks:
- 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.
Requirements:
- 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)