Data Analyst - IICS​/PowerCenter

Our client is looking for a Data Analyst to join their Team! This role will work closely with various departments to gather, analyze, and interpret data to support business decisions and strategies.

• Develop, execute, and optimize SQL queries to extract and analyze data from various databases.
• Design, implement, and maintain Informatica ETL processes to ensure data is accurately and efficiently loaded into data warehouses.
• Collaborate with stakeholders to understand data requirements and provide actionable insights.
• Create and maintain data, reports, dashboards, and visualizations to support business operations.
• Ensure data integrity and accuracy by performing regular data quality checks.
• Identify trends, patterns, and anomalies in data to support business decision-making.
• Document data processes, methodologies, and findings for future reference.
• Collaborate closely with cross-functional teams to gather requirements and deliver reporting solutions that meet business needs.
• Provide guidance on best practices and ensure compliance with company policies and industry standards.

• Strong background in building and executing SQL code
• Experience with ETL (Extract, Transform, Load) processes
• A bachelor’s degree in computer science, Information Systems, or a related field
• At least 3 years of experience in the field of data science
• Excellent problem-solving skills
• Excellent communication skills, written and verbal
• Strong experience with Informatica Intelligent Cloud Services (IICS) to perform data extraction, transformation, and loading
• Ability to perform SQL Server databases maintenance activities (table design, indexing, performance monitoring/tuning, security management, capacity planning, troubleshooting, etc.)
• Solid understanding of data warehousing concepts like star/snowflake schemas, slowly changing dimensions, degrees of normalization, partitioning strategies, table join options, surrogate keys, fact vs dimension tables
• Proficiency in data visualization tools such as Tableau, Power BI, or similar
• Ability to work independently and manage multiple tasks simultaneously