Data Analyst

Get AI-powered advice on this job and more exclusive features. Direct message the job poster from Pomeroy We are seeking an onsite Data Analyst in Cincinnati, OH for a full-time, direct hire opportunity. 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. Schedule: Onsite, Monday thru Friday 8am to 5pm 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. 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. Seniority level Seniority level Associate Employment type Employment type Full-time Job function Job function Information Technology Industries IT Services and IT Consulting Referrals increase your chances of interviewing at Pomeroy by 2x Inferred from the description for this job Medical insurance Get notified about new Data Analyst jobs in Cincinnati Metropolitan Area . Cincinnati, OH $90,000.00-$100,000.00 3 weeks ago Analyst Data Analytics - US Based Remote Data Analyst, Amazon Air Network Control Center, MXO Business Intelligence Internship - Fall 2025 Cincinnati, OH $70,000.00-$90,000.00 1 month ago Johnson & Johnson, Data Science Co-op - Fall 2025 - Application via WayUp Cincinnati, OH $86,360.00-$111,760.00 39 minutes ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr Pomeroy