Senior Data Engineer - Pipelines, SQL & AWS (Redshift)

HIVE-X; Town of Belgium (WI); Remote; USD 120,000 - 150,000; Full time

Job summary

Hive-X is looking for a Senior Data Engineer to support projects related to data management and engineering. The role involves building and optimizing data pipelines, managing data lakes, and collaborating with stakeholders. Candidates should have over 10 years of experience, strong SQL, Python, and AWS skills. The position is based in the United States, Wisconsin, Town of Belgium, offering an opportunity to work in a dynamic environment focused on data analytics and business support.

Qualifications

• 10+ years of experience in data engineering.
• Strong experience with large-scale data pipelines and complex queries.

Responsibilities

• Build and operate data foundations for analytics and reporting.
• Maintain and optimize batch/streaming data pipelines.
• Design schemas and manage data lakes/warehouses.

Skills

SQL (advanced)

Python

AWS (Glue, S3, Redshift)

Job description

Thank you for not contacting Athora directly. You can reach out to ProUnity [e-mail].
Do NOT try and contact the Hiring Manager directly please. It is not appreciated.

Only the applications that meets’Athora’spredefined criteria (skills, work experience, language skills and availability) in this job post will be considered. If the above is not respected, Athora and/or ProUnity reserves the right to reject the candidate.

In attachment you can find different annexes part of the Framework Agreement of Athora. When proposing (a) candidate(s) you confirm you accept the conditions being part of the Framework Agreement.

MISSION DESCRIPTION & CONSULTING PROFILE

Description of The Mission

Title of the mission:

Data Engineer in the IT Front Data Team

Goal of the mission:

Support the projects: Transparency, Arizona, Verdi and BAU support tasks in the area of IT Front Data Management & Engineering

Data Pipelines
Data Modelling & Storage
Complex SQL Qeuries
Tune SQL and jobs
Maintain existing jobs, fix failures, manage changes/releases, and support new onboardings.

Expected role & responsibilities during the mission:

Building and operating the data foundation that analytics, reporting depend on.
Build, maintain, and optimize batch/streaming pipelines (ingestion → transformation → serving
Design schemas and models (e.g., dimensional, Data Vault), and manage & interrogate data lakes/warehouses (e.g. S3/ADLS + Redshift)
Handle incident troubleshooting/root-cause analysis
Orchestration & Automation
Stakeholder collaboration

Description of The Expected Profile

Knowledge:

SQL (advanced), Python, AWS (Glue, S3, Redshift)

Strong experience building and maintaining large-scale data pipelines and optimizing complex queries across big datasets. Hands-on Data Engineering, ETL/ELT pipelines, data ingestion, transformation, optimization, debugging & incident resolution.
Proven experience and ability working with project managers, business – and functional analysts, and source-system owners to clarify requirements and deliver datasets/data products.

Mindset:

Positive mindset including a will-can-do mentality, ability to work independently and manage / prioritize his/her own work. Efficient and transparent communicator, teamplayer. Demonstrate a proactive attitude.

Seniority expected:

Senior

Years of Experience:

10 yr +

Required Skills

AWS (Glue, S3, Redshift), Python, SQL (advanced !)