Data Analyst - IICS/PowerCenter

Golden Technology; Cincinnati (OH); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading tech solutions provider in Cincinnati is seeking an experienced Data Analyst to analyze and interpret data for business decision-making. Responsibilities include optimizing SQL queries, maintaining ETL processes, and generating data reports. The ideal candidate will have a Bachelor's degree, 3+ years in data science, and strong skills in SQL and Informatica. This position offers a dynamic work environment with opportunities for professional growth.

Qualifications

• 3+ years of experience in the field of data science.
• Strong experience in SQL code execution and development.
• Ability to perform SQL Server databases maintenance activities.

Responsibilities

• Develop and optimize SQL queries to analyze data.
• Design and maintain Informatica ETL processes.
• Create and maintain reports and dashboards.

Skills

SQL

ETL processes

Informatica Intelligent Cloud Services

Data visualization

Data integrity

Problem-solving

Communication skills

Education

Bachelor's degree in computer science, Information Systems, or related field

Tools

Tableau

Power BI

Job description

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