Mission Description & Consulting Profile
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
Technical Focus Areas
- Data Pipelines
- Data Modelling & Storage
- Complex SQL Queries
- Tune SQL and jobs
- Maintain existing jobs, fix failures, manage changes/releases, and support new onboardings.
Expected Role & Responsibilities
- 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.
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)