Data Engineer

Avensys is a reputed global IT professional services company, and our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. And we service a client base across banking and financial services, insurance, information technology, healthcare, retail, and supply chain.

We are currently looking for a Data Engineer. This is an exciting opportunity to expand your skill set, achieve job satisfaction, and work-life balance. More details as below.

Job Description:

We are seeking a skilled Data Engineer to design, build, and maintain robust data pipelines and analytics infrastructure. The ideal candidate will have strong hands-on experience in ETL development, Azure Databricks, and Power BI integration, enabling efficient data flow and insight generation across the business. This role will work closely with analysts, data scientists, and business stakeholders to ensure data is clean, reliable, and readily available for decision-making.

The work:

• Design, develop, and maintain ETL pipelines for data ingestion, transformation, and loading across multiple data sources.

• Build and optimize data workflows and models using Azure Databricks and PySpark/SparkSQL.

• Develop and maintain data models supporting analytics and reporting in Power BI.

• Implement data quality, validation, and monitoring frameworks to ensure reliability and integrity.

• Collaborate with business teams to understand reporting requirements and translate them into scalable data solutions.

• Support data warehousing and data lake solutions within Azure ecosystem (Data Lake Storage, Synapse, etc.).

• Maintain and enhance metadata, data lineage, and documentation for all data processes.

• Optimize performance of queries and pipelines for scalability and cost efficiency.

• Ensure security, compliance, and access control within all data environments.

Here's what you need:

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

• 3+ years of experience in data engineering or related roles.

• Strong hands-on experience with:

• ETL tools and frameworks (e.g., Azure Data Factory, SSIS, or custom Python pipelines)

• Databricks (PySpark, SparkSQL, Delta Lake, cluster management)

• SQL and relational database design (e.g., SQL Server, Snowflake, or Azure Synapse).

• Power BI (data modelling, DAX, dataset management, dashboard integration).

• Familiarity with Azure ecosystem (Data Lake, Synapse Analytics, Key Vault, Logic Apps).

• Solid understanding of data modelling, data governance, and best practices for performance tuning.

• Strong analytical thinking, problem-solving, and communication skills.

Bonus points if:

• Knowledge of Python for data manipulation and automation.

• Exposure to RAG (Retrieval-Augmented Generation) or AI/ML data preparation is a plus.

• Experience in Agile development or DevOps environments.

• Exposure to Gen Ai and Agentic Ai

WHAT'S ON OFFER

You will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.

To submit your application, please apply online or email your UPDATED CV in Microsoft Word format to [Confidential Information] Your interest will be treated with strict confidentiality.

CONSULTANT DETAILS

Consultant Name: HARI

Reg No: 201201037177

Avensys Consulting Sdn Bhd