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.
Employment Type: Full Time, Permanent
Read full job description