Data Analyst- Informatica IICS

Golden Technology

Cincinnati (OH)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Golden Technology is seeking a Data Analyst to support business decisions through data analysis and reporting. The role involves SQL query development, ETL processes with Informatica, and collaboration with various departments. Candidates should have a strong background in data science and excellent communication skills.

Qualifications

At least 3 years of experience in data science.
Strong experience in SQL and ETL processes.
Solid understanding of data warehousing concepts.

Responsibilities

Develop and optimize SQL queries for data analysis.
Design and maintain Informatica ETL processes.
Create reports and dashboards to support business operations.

Skills

SQL

ETL processes

Data visualization

Analytical skills

Problem-solving

Communication skills

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

Informatica Intelligent Cloud Services (IICS)

Tableau

Power BI

Job description

Exciting Opportunity: Hiring a Data Analyst- Informatica IICS!

Job Description

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.

Top skills you need to have:

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
Proven experience in building and executing SQL code
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
Strong analytical and problem-solving skills
Proficiency in data visualization tools such as Tableau, Power BI, or similar
Ability to work independently and manage multiple tasks simultaneously

Founded in 1997, Golden Technology is committed to connecting exceptional technologists with groundbreaking companies. With a proven track record of delivering top-tier talent to Fortune 500 clients, we've built a reputation for excellence.

Our culture is rooted in family, fostering growth and success for both our clients and candidates. Beyond professional goals, we're dedicated to community betterment through our Golden Community initiatives.

Join us in shaping the future of technology.

Seniority level