Consultant (Talend Data Integration & Informatica BDM)

ITCAN PTE. LIMITED; Singapore; On-site; SGD 50,000 - 80,000; Full time

Job summary

ITCAN PTE. LIMITED is seeking a Data Integration Analyst to extract, normalize and transform data for business insights and dashboard delivery. You will work across data sources, collaborate with data engineers, and ensure data quality through lifecycle management.

The role emphasizes delivering measurable outcomes with a focus on data-driven decision making, using SQL and BI tools to create impactful visualizations for stakeholders.

Qualifications

• Undergraduate or graduate degree in Computer Science or equivalent.
• Experience with data analysis and visualization (1-2 years).
• Proficiency in SQL and scripting (Python or R).
• Experience using Talend for data integration and ETL.
• Ability to build dashboards using BI tools.

Responsibilities

• Own data lifecycle tasks from sourcing to presentation.
• Prepare, normalize and transform data for business insights.
• Collaborate with data engineers to optimize data warehouse usage.
• Develop and operationalize dashboards for stakeholders.
• Provide status updates with project managers and leads.

Skills

Communication

Critical thinking

Data analysis

Data visualization

SQL

Python/R

Education

Bachelor's or Master's in CS or equivalent

Tools

Talend

Tableau

Power BI

Qlik

Informatica

Job description

Job Description

We are looking for a data analyst to generate and operationalize insights from numerous data sources in support of key stakeholders. You will perform a variety of duties around data lifecycle management and data supply chains, related to sourcing, analysing, and presenting data. As part of this, you will extract, normalise, and transform data for derivation of business and performance insights through dashboard visualizations. A successful Data Integration Analyst possesses strong analytical problem-solving skills, excellent attention to detail, and a passion for all things data.

What will you do?

• Ownership within area of responsibility and scope of services focused on outcomes to deliver high quality, dependable, cost effective solutions for our customers. Lead, make decisions, and take actions.
• Responsible for the currency of the documentation and automation in area of responsibility.
• Accountable for adherence to standards, controls, processes and procedures in Security, Service Control & Service Management, with operational discipline and successful outcomes.
• Dive into company data to identify sources and features that will drive business objectives.
• Work with data engineering team to rationalise the data warehouse throughout the data lifecycle from source to analysis to modelling.
• Work closely with project manager and technical leads to provide regular status reporting and support them to refine issues/problem statements and propose/evaluate relevant analytics solutions
• Bring your experience and ideas to effective and innovative engineering, design and strategy
• Work in interdisciplinary teams that combine technical, business and data science competencies that deliver work in waterfall or agile software development lifecycle methodologies

Qualifications

What do you need to succeed?

• Possess good communications skills to understand our customers' core business objectives and build end-to-end data centric solutions to address them
• Good critical thinking and problem-solving abilities
• Expected to grow your skills and capabilities by becoming a SME within area of responsibility and scope of services and staying current on the new and emerging market offerings/technologies.

Must-have:

• Experience working with Talend
• Prior experience building compelling and usable data visualizations and analytics with commercial and/or open source BI tools
• SQL proficiency necessary to build and maintain complex queries and data pipelines
• Python/R (or similar scripting language) coding capability to operationalize data analytics workflows & processes
• 1-2 years of experience in data analysis and visualization
• Undergraduate or graduate degree in Computer science or equivalent

Nice to have:

• Experience with Amazon Web Services, Cloudera (or other cloud services)
• Data pipeline and/or database development experience
• Knowledge of statistical modelling, predictive analytics or machine learning
• Certification in leading data analytics platforms such as:- Tableau
• Qlik
• Microstrategy
• Informatica
• Talend
• Microsoft
• SAS
• IBM