Job Description
We are looking for a Senior Data / DWH Engineer to design, develop, and maintain scalable data warehouse and data engineering solutions across the full product lifecycle. The role focuses on building reliable ETL/ELT pipelines, optimizing data models, ensuring data quality, and enabling analytics and application integration in a modern Agile environment.
Responsibilities
- ▪Design, develop, and maintain data warehouse solutions, data marts, and data models.
- ▪Build and optimize ETL/ELT pipelines and automated data workflows.
- ▪Develop and maintain DBT-based transformation layers and DWH models.
- ▪Create and maintain source-to-target mappings and technical documentation.
- ▪Develop and support FastAPI-based data services and integrations.
- ▪Perform data validation, reconciliation, and post-load quality checks.
- ▪Optimize SQL queries and PL/pgSQL stored procedures for performance and scalability.
- ▪Collaborate with technical and business teams throughout the delivery lifecycle.
- ▪Support Agile delivery processes, testing, deployment, and release readiness activities.
- ▪Contribute to continuous improvement of data architecture and engineering practices. Profile / Requirements :
- ▪Strong experience in Data Engineering and Data Warehouse development.
- ▪Advanced proficiency in Python and SQL.
- ▪Experience designing and maintaining ETL/ELT pipelines.
- ▪Strong understanding of data modeling, OLTP, and OLAP concepts.
- ▪Hands-on experience with databases such as PostgreSQL, Redshift, Athena, Trino, or SQLite.
- ▪Experience with DBT, Airflow, and FastAPI.
- ▪Familiarity with testing and validation approaches (e.g. PyTests, SQL validation).
- ▪Experience working in Agile environments using tools like Jira.
- ▪Strong analytical, troubleshooting, and communication skills. About us :
ALGOTEQUE is an IT consultancy firm that helps startups, mid-sized and large corporations to create and deliver innovative technologies. Our team has a successful track record in designing, developing, implementing, and integrating software solutions (AI, ML, BI, Web, Automation) for Telecom, Energy, Bank, Insurance, Pharma, Automotive, Industry, e-commerce. We deliver our services both in fixed-price and time-and-materials models, helping our customers achieve their business and IT strategies.