Senior Analytics Engineer: ELT, Data Pipelines & BigQuery

Human Power BG; United States; On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

25 days paid leave

Laptop

Health insurance on company expenses

Multisport card

Vouchers for food and monthly utility

Job summary

Human Power BG is seeking an Analytics Engineer to design and maintain ELT pipelines, transforming data for analytics. You will build scalable data ingestion using SQL and Python, leveraging DBT and dimensional modeling to enable fast insights for end users.

You will optimize data delivery, monitor data quality, and reduce costs as part of a fast-moving agile team. Fluency in English is required and experience with cloud data warehouses is a plus.

Qualifications

• Excellent understanding of ELT techniques.
• 3+ years of experience with data warehousing and/or large and complex database management systems.
• Expert knowledge of SQL.
• Hands-on experience in writing complex analytical SQL.
• Strong dimensional data modeling skills.
• Intermediate Python programming to manage pipelines and compose SQL.
• DBT (or similar SQL transformation tool).
• Fluent English writing, reading and speaking.

Responsibilities

• Extract & load data from OLTP systems to big data warehouse (Google BigQuery).
• Create and maintain flexible data ingestion pipelines including data delivery process optimization from various source systems.
• Implement new ELT processes in support of business analytics and reporting.
• Use dimensional modeling (or similar framework) to prepare data for analysis.
• Proactively monitor the ELT processes and procedures and provide preemptive measures ensuring data quality, system performance, and optimizations of the flows.
• Decrease the related costs by optimizing the structure, systems, processes and the use cases of the data.

Skills

ELT techniques

SQL

Dimensional modeling

Python

DBT

Fluent English

Complex analytical SQL

Tools

Google BigQuery

DBT

Job description

Human Power BG is seeking an Analytics Engineer to design and maintain ELT pipelines, transforming data for analytics. You will build scalable data ingestion using SQL and Python, leveraging DBT and dimensional modeling to enable fast insights for end users.

You will optimize data delivery, monitor data quality, and reduce costs as part of a fast-moving agile team. Fluency in English is required and experience with cloud data warehouses is a plus.