Data Analyst - IICS/PowerCenter

Golden Technology

Cincinnati (OH)

On-site

USD 70,000 - 90,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Imformatica Lead
Imformatica Lead

Diligent Tec, Inc • Santa Ana (CA)

On-site
USD 110,000 - 160,000
Data Analyst: IICS/PowerCenter & BI Dashboards
Data Analyst: IICS/PowerCenter & BI Dashboards

Golden Technology • Cincinnati (OH)

On-site
USD 70,000 - 90,000
IICS Lead
IICS Lead

TechDigital Group • Frisco (TX)

On-site
USD 80,000 - 120,000
Informatica Cloud Developer
Informatica Cloud Developer

TechDigital Group • Cary (NC)

On-site
USD 80,000 - 100,000
Informatica Developer
Informatica Developer

TechDigital Group • Denver (CO)

On-site
USD 95,000 - 120,000
Informatica IICS Powercenter / Data integration Branchville, NJ
Informatica IICS Powercenter / Data integration Branchville, NJ

Executive Staff Recruiters / ESR Healthcare • New Jersey

On-site
USD 110,000 - 150,000
Informatica Data Integration Engineer - PowerCenter/IICS
Informatica Data Integration Engineer - PowerCenter/IICS

Executive Staff Recruiters / ESR Healthcare • New Jersey

On-site
USD 110,000 - 150,000
Senior Technical Lead
Senior Technical Lead

TechDigital Group • Cedar Rapids (IA)

On-site
USD 95,000 - 130,000
Data Warehouse Analyst
Data Warehouse Analyst

Pointwest-North America • Florida

On-site
USD 100,000 - 130,000
ETL Developer - Informatica PowerCenter & Automation
ETL Developer - Informatica PowerCenter & Automation

Compunnel Inc. • Charlotte (NC)

Hybrid
USD 90,000 - 120,000