ETL system analyst for DWH integrations

Intellias; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

Intellias ищет ETL System Analyst для работы в динамичной команде над проектами в области обработки больших данных и интеграции DWH. Ваша роль будет включать сбор требований, анализ, формирование технических спецификаций и сопровождение процессов интеграции между DWH и внешними системами.

Требуется опыт работы с ETL-инструментами, SQL, Oracle PL/SQL и знание BI-решений. Работа предполагает взаимодействие с бизнес-клиентами и командами разработки; приветствуется знание AWS, BigQuery и NoSQL.

Qualifications

• Более 2 лет коммерческой разработки ETL и Oracle PL/SQL.
• Отличное владение SQL и понимание принципов RDBMS.
• Опыт работы с Agile/Scrum и Kanban; знание Atlassian Suite.

Responsibilities

• Работа в составе одной или нескольких Agile-команд как ETL System Analyst.
• Сбор требований у бизнеса (до 30% времени).
• Анализ требований (до 40% времени).
• Разработка технических спецификаций для интеграции DWH и 3PP систем (до 30% времени).
• Подготовка спецификаций для слоя DWH.
• Анализ и поиск ошибок в слоях DWH.
• Постановка и прием задач от разработчиков, тестировщиков и администраторов.

Skills

SQL

Data analysis

Agile/Scrum

JIRA/Confluence

Python

REST/JSON

BigQuery

AWS

NoSQL

Tools

Oracle PL/SQL

Informatica

Power BI

Confluence

JIRA

XML/JSON

Job description

Описание:

Let’s breathe life into great tech ideas! With more than 3 000 people globally, Intellias is a company where benchmark technological solutions are born. Join in and take your part in digitalizing the world. What project we have for you Our Client is the largest Ukrainian telecommunication operator providing communications and data services based on a broad range of mobile and fixed‑line technologies, including 4G. Company’s customer base amounts to over 26 million in mobile and more than 1 mln in broadband internet.

Задачи:

• Working as a part of one or more agile teams as an ETL System Analyst
• Gathering requirements from business (30% of time)
• analysing of requirements (40% of time)
• writing technical specification (30% of time) for integration between DWH and 3PP systems
• writing technical specification for DWH layer
• analysing and finding bugs in DWH layers
• Setting and accepting tasks to/from developers, testers and administrators
• providing results to business customers

Требования:

• 2+ years of commercial project development experience as an ETL System Analyst and an Oracle PL/SQL developer
• Strong data analytical skills
• Excellent SQL knowledge
• Understanding of RDBMS principles
• Methodology: Agile / Scrum and Kanban
• Knowledge of Atlassian Suite (JIRA, Confluence)
• Practical experience of handling big production volumes of data (200TB+)
• Будет плюсом: Experience working with any ETL tool is a must (PWC Informatica is highly recommended and is a plus)
• Experience working with any BI Tools (PowerBI, Report Builder is highly recommended and is a plus)
• Knowledge and practical experience with Python, HTTP, Telnet, JSON, HTML, REST, SOAP, XSLT, JavaScript
• Practical experience with NoSQL/Cassandra DB, MariaDB, AWS, BigQuery, understanding of non‑relational DBs
• Understanding of Telecom billing or provisioning systems architecture

Условия:

At Intellias, where technology takes center stage, people always come before processes. By creating a comfortable atmosphere in our team, we empower individuals to unlock their true potential and achieve extraordinary results. That’s why we offer a range of benefits that support your well-being and charge your professional growth. We are committed to fostering equity, diversity, and inclusion as an equal opportunity employer. All applicants will be considered for employment without discrimination based on race, color, religion, age, gender, nationality, disability, sexual orientation, gender identity or expression, veteran status, or any other characteristic protected by applicable law. We welcome and celebrate the uniqueness of every individual. Join Intellias for a career where your perspectives and contributions are vital to our shared success.