We are seeking a highly skilled and knowledgeable DWH to join our Data Management team DWH project in Latvia.
The ideal candidate will have a Advanced experience with or knowledge of most of the following software, languages and tools: Oracle Analytics Server (+BI Publisher) and Oracle Data Integrator, PL/SQL
Responsibilities:
Design and Architecture:
Knowledge of warehouse architecture, including data models, schema designs, and ETL processes.
Choose the appropriate technology stack and tools for data warehousing solutions.
Develop and maintain ETL (Extract, Transform, Load) jobs to integrate data from various sources into the data warehouse.
Work with business analysts and stakeholders to understand data requirements and convert them into relevant data models.
Optimize data warehouse performance through indexing, partitioning, and query optimization techniques.
Ensure scalability and efficiency in data storage and retrieval.
Implement and enforce data governance policies to ensure data quality and compliance.
Ensure secure access to data warehouse environment and data protection measures.
Testing, Maintenance and Documentation.
Mandatory Skills :
Bachelors or Master s degree in Computer Science, Engineering, or a related field.
Minimum of 8 years of experience as a Data Engineer with a focus on Google cloud-based solutions.
Strong knowledge of versioning and CI/CD.
Advanced experience with or knowledge of most of the following software, languages and tools: Oracle Analytics Server (+BI Publisher) and Oracle Data Integrator, PL/SQL
Advanced knowledge and experience in Oracle database technologies, SQL, ETL process, reporting and analytics
Experience in database design and modeling for Oracle Data Warehouse and Business Intelligence applications, including relational database structures and normal forms.
Experience with software documentation and version control (GIT)
Knowledge of PCI standards and secure coding technics and tools (Sonar Cube)
Analytical and troubleshooting skills with complex technical subjects and tasks.
Ability to present and explain complex technical topics, problems, alternative solutions to others.
Ability to work and communicate in a team
Experience estimating solution development and delivering solutions against those estimates
Knowledge and understanding of the software development life cycle.