EIM Data Analyst
We are seeking a highly skilled and experienced Data Analyst with a strong background in ETL processes, data manipulation, and SQL query writing. As a Data Analyst, you will play a key role in transforming raw data into meaningful insights to help drive business decisions. You will work closely with cross functional teams to understand business requirements, design ETL workflows, and ensure data quality, integrity, and availability.
Key Responsibilities
Design, implement, and manage ETL processes to extract, transform, and load data from multiple sources into data warehouses.
Collaborate with business stakeholders to gather requirements and understand data needs for reporting and analysis.
Write complex SQL queries for data extraction, reporting, and analysis to support business insights.
Perform data cleansing, transformation, and validation tasks to ensure data accuracy and consistency.
Create and optimize SQL queries for reporting and analysis.
Develop and maintain data pipelines using ETL tools such as e.g., Pentaho, Informatica, Talend, etc.
Design and develop automated reports and dashboards using tools like Tableau, Power BI, or similar.
Monitor ETL workflows to identify performance bottlenecks and ensure timely and efficient data loads.
Perform data profiling and analysis to identify trends, anomalies, and opportunities for process improvements.
Troubleshoot and resolve data related issues, working with other teams when necessary.
Document and maintain data models, ETL process flows, and data quality standards.Skills and Qualifications
Bachelor s degree in Computer Science, Information Systems, Engineering, or a related field.
5 years of hands on experience as a Data Analyst, with expertise in ETL processes.
Strong experience in writing complex SQL queries for data extraction, transformation, and analysis.
Proficient in SQL and database management e.g MySQL, SQL Server, Oracle, etc.
Strong experience with ETL tools such as Talend, Pentaho, Informatica, SSIS, etc. is a plus.
Experience in snowflake is plus.
Experience in data warehousing concepts and design Star Schema, Snowflake Schema, etc.
Knowledge of scripting languages such as Python, Shell, or Java is a plus.
Familiarity with data visualization tools e.g, Tableau, Power BI, etc..
Ability to work with large datasets and manage performance optimization tasks.
Strong analytical and problemsolving skills.
Excellent communication skills with the ability to interact with both technical and non technical stakeholders.
Detail oriented with strong organizational and documentation skills.
Knowledge of sanctions regulations and compliance is a plus.
Preferred Qualifications
Experience with cloud platforms AWS, Azure, Google Cloud and big data technologies Hadoop, Spark, etc.
Familiarity with Agile methodologies and version control tools Git, SVN