Analytics Engineer II: ELT Pipelines & Data Products

Ektello; Philadelphia (Philadelphia County); On-site; USD 110,000 - 160,000; Full time

Job summary

ektello partners with a Philadelphia healthcare leader to hire an Analytics Engineer who will own end-to-end data workflows, ELT pipelines, and timely data loading. You will collaborate with subject matter experts, data analysts and scientists to develop reusable data assets and data products using BI tools such as Tableau, Power BI or Qlik.

This onsite role requires strong SQL and data modeling, with exposure to modern data integration and big data tools.

Qualifications

• Six or more years of experience in data and analytics.
• Strong SQL, data modeling and data warehousing fundamentals.
• Experience with data integration tools: DBT, Informatica, MS Integration Services.
• Experience with big data toolset: Hadoop, Spark, Kafka, Hive, Sqoop.
• Experience with BI/Visualization tools (e.g., Business Objects, Tableau, Power BI, Qlik).
• Experience with stream-processing systems: IBM Streams, Flume, Storm, Spark-Streaming.
• Good hands-on experience with Linux (RHEL/Debian).
• Ability to code with Python, Bash, Groovy.

Responsibilities

• Collaborate with business subject matter experts, data analysts, and data scientists to understand opportunities to develop well-defined, integrated, reusable data sets which power analytics.
• Codify reusable data access patterns to speed up time to insights.
• Perform Logical and Physical data modeling with an agile mindset.
• Build automated, scalable, test-driven ELT pipelines.
• Utilize software development practices such as version control via Git, CI/CD, and release management.
• Build data products using visualization, BI tools and data science tools.
• Collaborate with Data Engineers, DevOps engineers and architects on improvement opportunities for DataOps tools and frameworks.

Skills

SQL

Data modeling

Data warehousing

Git

CI/CD

Python

Bash

Groovy

Tools

DBT

Informatica

MS Integration Services

Hadoop

Spark

Kafka

Hive

Sqoop

IBM Streams

Flume

Storm

Spark Streaming

Tableau

Power BI

Qlik

Business Objects

Linux

Job description

ektello partners with a Philadelphia healthcare leader to hire an Analytics Engineer who will own end-to-end data workflows, ELT pipelines, and timely data loading. You will collaborate with subject matter experts, data analysts and scientists to develop reusable data assets and data products using BI tools such as Tableau, Power BI or Qlik.

This onsite role requires strong SQL and data modeling, with exposure to modern data integration and big data tools.