Senior Data Warehouse / OLAP Engineer

Intetics·Armenia, Remote·26 авг.

Senior Data Warehouse / OLAP Engineer

🌍 УдалённоSeniorПолная занятость🌐 Глобал

Зарплата не указана

Вилки нет, про деньги придётся договариваться с нуля.

Нажмите на сигнал, чтобы увидеть, на чём он основан

Наша компания

Intetics Inc., a global technology company providing custom software application development, distributed professional teams, software product quality assessment, and “all-things-digital” solutions, is seeking a highly skilled and experienced Senior Data Warehouse / OLAP Engineer to join our dynamic team on a full-time basis. The client is a leading company specializing in advanced cybersecurity solutions. They provide comprehensive security measures designed to protect sensitive data and systems from cyber threats. Their offerings include vulnerability management, threat intelligence, inciden

О роли

About the project: The only Risk-Based Vulnerability Management Platform purpose-built for the world’s most complex enterprises. Role Overview

Чем предстоит заниматься

Design, develop, and maintain scalable OLAP and data warehouse solutions

Create and optimize data models for reporting, analytics, and large-scale data processing

Design fact tables, dimension tables, aggregation layers, and analytical datasets

Develop efficient ETL/ELT pipelines for processing and transforming large volumes of data

Write, analyze, and optimize complex SQL queries

Review existing queries, schemas, and data-processing workflows and recommend performance improvements

Identify bottlenecks related to data access, transformations, storage, and query execution

Design appropriate partitioning, indexing, distribution, sorting, and sharding strategies

Ensure that analytical workloads remain performant as data volumes increase by significant factors

Evaluate when calculations should be performed in the database, in a processing layer, or pre-aggregated in advance

Improve data warehouse architecture, schema design, and storage efficiency

Build and maintain reusable data models and aggregation layers

Ensure data quality, consistency, completeness, and traceability across analytical datasets

Monitor pipeline performance, query execution, and data warehouse resource utilization

Troubleshoot production data issues and perform root-cause analysis

Collaborate with backend engineers, data engineers, analysts, and product stakeholders

Document data models, transformation logic, dependencies, and architectural decisions

Наши требования

Minimum of 5 years of professional experience in data engineering, data warehousing, database engineering, or a similar role

Strong hands-on experience with OLAP systems and data warehouse architecture

Extensive experience working with large and continuously growing volumes of data

Excellent knowledge of SQL, including writing and optimizing complex analytical queries

Strong understanding of dimensional data modeling, including fact and dimension tables

Experience designing star, snowflake, or other analytical schemas

Experience developing and maintaining ETL/ELT pipelines

Strong knowledge of query execution plans and database performance optimization

Understanding of indexing, partitioning, sorting, data distribution, and sharding strategies

Experience with relational, column-oriented, or distributed analytical databases

Understanding of data aggregation, pre-calculation, incremental processing, and historical data management

Experience identifying and resolving performance and scalability issues

Experience maintaining data solutions on Linux platforms in cloud environments

Demonstrated experience with technical troubleshooting and production support

Ability to work independently and collaboratively with distributed teams across different time zones

Experience working within Agile/Scrum development environments

Strong written and verbal communication skills in English

Experience with SingleStore/MemSQL or other distributed SQL databases

Experience with columnar or MPP analytical databases

Experience working in AWS or another major cloud environment

Experience with data orchestration and transformation tools

Experience with streaming or near-real-time data pipelines

Experience with data lake or lakehouse architectures

Experience building analytical solutions for SaaS products

Experience working with data analytics, business intelligence, or data science teams

Experience with cybersecurity, vulnerability management, or vulnerability scanning technologies such as SCA, SAST, DAST, IAST, container scanning, or VM scanning

Understanding of security-related datasets, including assets, vulnerabilities, threats, findings, and risk scores

Intetics

Armenia, Remote

ГрейдSenior

ЗанятостьПолная занятость

РегионАрмения

ФорматУдалённо

ИсточникСкрыто

Опубликовано26 авг.

Все вакансии компании

AI-помощник

под эту вакансию

Войди, чтобы AI оценил твоё соответствие вакансии и написал сопроводительное письмо

Мы против мошенников на площадке: если тебя просят заплатить, продиктовать код или установить непонятное приложение, прекращай общение и сразу пиши нам (чат с основателем или форма обратной связи).