Data Engineer II: Spark, SQL & Data Lakes (Onsite)

4P Consulting Inc.; Birmingham (AL); On-site; USD 80,000 - 110,000; Full time

Job summary

A prominent consulting firm located in Birmingham, AL, is seeking a Data Engineer II to enhance their data solutions. The ideal candidate will possess strong expertise in SQL, data modeling, and big data tools such as Spark, Hive, and Airflow, along with experience in relational databases, NoSQL platforms, and data lakes. A Bachelor's degree in a technical field is essential, with advanced degrees preferred, and a robust background in data engineering and analytics solutions is expected.

Qualifications

• 3–5 years of experience in data engineering or related role.
• Strong proficiency in SQL.
• Experience with data modeling and database normalization.
• Hands-on experience with Spark, Hive, and Airflow.
• 5+ years of experience with on-premises tools such as MSBI, Informatica, and Oracle.

Skills

SQL

Data modeling

Spark

Hive

Airflow

Hadoop

R

Python

Education

Bachelor’s degree in a technical field

Advanced degree preferred

Tools

MSBI (SSIS/SSAS)

Informatica

Oracle Golden Gate

SQL Server

Azure Data Lake

Azure Data Factory

Azure Databricks

Power BI

Job description

A prominent consulting firm located in Birmingham, AL, is seeking a Data Engineer II to enhance their data solutions. The ideal candidate will possess strong expertise in SQL, data modeling, and big data tools such as Spark, Hive, and Airflow, along with experience in relational databases, NoSQL platforms, and data lakes. A Bachelor's degree in a technical field is essential, with advanced degrees preferred, and a robust background in data engineering and analytics solutions is expected.