Informatica/IICS SQL Data Analyst

SQL Data Analyst-Informatica

Our client is a leader in their industry and headquartered in Cincinnati for 80 years. Permanent, full time position in-house with full benefits. They are seeking a Data Analyst. The ideal candidate will have a strong background in building and executing SQL code, as well as experience with ETL (Extract, Transform, Load) processes. This role will involve working closely with various departments to gather, analyze, and interpret data to support business decisions and strategies. Must have experience with IICS or Informatica Power Center.

Key Duties and 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.

Required Skills and Experience:

• 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
• Proven experience in building and executing SQL code.
• Strong experience with Informatica Intelligent Cloud Services (IICS) to perform data extraction, transformation, and loading. Informatica Power Center will also be considered.
• 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.

• Strong analytical and problem-solving skills.
• Proficiency in data visualization tools such as Tableau, Power BI, or similar.