Data Analyst - IICS/PowerCenter

Overview 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. Responsibilities 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. Qualifications 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 #J-18808-Ljbffr Golden Technology