Analytics Engineer II

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 is partnering with a healthcare leader in Philadelphia to find an Analytics Engineer to join their growing team. This team is looking for a local candidate who can support onsite needs as needed. Must be able and willing to work on W2 without sponsorship as this client prefers to hire in the future. The Analytics Engineer owns the entire workflow of data associated with their domain; data pipeline development, ELT performance, timely loading of data sets, and maintenance.

Essential Functions:

• Collaborate with business subject matter experts, data analysts, and data scientists to understand/identify the opportunities to develop well-defined, integrated, re-usable 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 various visualization, BI tools and data science tools.
• Collaborate with Data Engineers, DevOps engineers and architects on improvement opportunities for DataOps tools and frameworks.

Required Skills & Experience:

• Minimum of six (6) years of experience working in data and analytics landscape.
• Strong SQL, Data Modeling and Data Warehousing fundamentals.
• Experience with software development practices; version control, code review, CI/CD.
• Experience with data integration tools: DBT, Informatica, MS Integration Services etc.
• Experience with big data toolset: Hadoop, Spark, Kafka, Hive, Sqoop etc.
• Experience working with Business Intelligence Tools (Business Objects) or Visualization tools such as Qlik, Tableau, Power BI etc.
• Experience with stream-processing systems: IBM Streams, Flume, Storm, Spark-Streaming, etc.
• Good hands-on experience with Linux (RHEL/Debian) operating system.
• Ability to code with other scripting languages such as Python, Bash, groovy etc.
• #LI-DT1