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.
Job Description
We are looking for a Senior Data / Data Warehouse Engineer to design and deliver scalable data solutions across the full product lifecycle. In this role, you will build robust data models, develop reliable ETL/ELT pipelines, and ensure high data quality to support analytics, reporting, and application integration in an Agile environment.
Responsibilities:
- Own end-to-end data engineering and DWH delivery, from requirements and design to development, validation, and deployment.
- Design and maintain data models, data marts, and table structures for OLTP and OLAP reporting.
- Develop and maintain ETL/ELT pipelines and DBT-based transformation layers.
- Build automated data pipelines and FastAPI-based data access layers for application integration.
- Implement data validation, reconciliation, and quality checks using SQL.
- Optimize and maintain PL/pgSQL stored procedures for data processing.
- Collaborate with cross-functional and distributed teams to ensure timely and high-quality delivery.
- Work in an Agile environment using Jira and support demos or user training when needed.
Required qualifications
- Strong experience in data engineering and data warehouse development.
- Hands-on experience with ETL/ELT pipeline design and implementation.
- Proficiency in SQL and experience with PL/pgSQL stored procedures.
- Experience with DBT for data modeling and transformation.
- Experience building APIs or data access layers using FastAPI.
- Strong understanding of data modeling concepts for OLTP and OLAP systems.
- Experience implementing data quality checks, validation, and reconciliation processes.
- Familiarity with Agile methodologies and tools such as Jira.
- Strong communication skills and ability to collaborate with cross-functional and distributed teams.
