Senior Data Engineer - Python/SQL/ETL

About Us :

At Calfus, we are known for delivering cutting-edge AI agents and products that transform businesses in ways previously unimaginable. We empower companies to harness the full potential of AI, unlocking opportunities they never imagined possible before the AI era. Our software engineering teams are highly valued by customers, whether start-ups or established enterprises, because we consistently deliver solutions that drive revenue growth. Our ERP solution teams have successfully implemented cloud solutions and developed tools that seamlessly integrate with ERP systems, reducing manual work so teams can focus on high-impact tasks.

About the Role :

As a Data Engineer - BI Analytics & DWH, you will contribute to building scalable data infrastructure and efficient data pipelines that power our business intelligence and analytics capabilities. With 6 - 9 years of experience, you'll apply your solid foundation in ETL/ELT development, data modelling, and database design to support data warehousing and data lake initiatives.

What You'll Do :

• ETL/ELT Development : Design, build, and maintain efficient ETL and ELT processes using tools such as Azure data factory, Databricks, or similar orchestration frameworks. Ensure reliable data ingestion from various sources into centralized storage systems.

• Data Modelling & Warehousing : Design relational and dimensional data schemas tailored to business use cases in data lakes or traditional data warehouses (e.g., Snowflake, Redshift, Postgres). Develop and maintain data models optimized for analytics and reporting.

• Database Engineering : Write efficient SQL queries and stored procedures to transform, clean, and aggregate data. Manage data transformations and complex joins to support analytical workloads.

• BI & Visualization Support : Provide basic support for report and dashboard development in visualization tools such as Tableau or Power BI. Collaborate with analysts and business users to understand reporting needs.

• Performance & Data Quality : Monitor and troubleshoot data pipelines and warehouse jobs to ensure timely and accurate data availability.

Requirements :

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field.

• 6 - 9 years of experience in data engineering with hands-on ETL/ELT development and data modelling.

• Solid SQL skills and experience with database systems such as SQL Server, Postgres, Snowflake, or Redshift.

• Exposure to cloud-based services and data tools (e.g., AWS S3, Azure Data Factory, Databricks).

• Familiarity with Python for scripting and data manipulation.

Benefits :

At Calfus, we value our employees and offer a strong benefits package, including medical, group, and parental insurance, gratuity, provident fund, and birthday leave.

Calfus is an Equal Opportunity Employer. We believe diversity drives innovation and are committed to creating an inclusive workplace.