Convergys Sr Analyst IT Solutions in Cincinnati, Ohio

Job Title:

Sr Analyst IT Solutions

Job Description

Data Warehouse Sr. Analyst

The Data Warehouse Sr. Analyst is critical to ensuring we have accurate data across our organization. The Sr. Analyst is responsible for architecting, designing and delivering warehouse designs, solutions and strategies. Duties will include interacting with various business teams to help define the data needs and translate these needs into data structures that are consumable by the users. This individual will work alongside the Data Warehouse and Business Intelligence (BI) development teams. This is a hands on role that will be responsible for analysis, requirements, prototypes, solutions, designs, development, validation, and obtaining user confirmation. The role requires high attention to detail and drive for data accuracy.

  • Minimum 5+ years’ experience in design and implementation of large-scale Data Warehouse and BI applications including star schemas, dimensional modeling, and extract transform load (ETL) methodologies.

  • Must have experience in creating Data Warehouse solutions on Oracle database. Experience with MS SQL server would be a plus.

  • Must have extensive hands on experience with SQL, PL/SQL and performance tuning.

  • Experience is creating test case as part of the design activity.

  • Excellent analytical and decision-making skills with high attention to data accuracy.

  • Map source data to data warehouse, operational data store databases, or target databases.

  • Expert in Data Warehouse life cycle methodologies and best practices with a continuous improvement mindset.

  • The individual must have full technical knowledge for all phases of a software development lifecycle and must be able to analyze and solve complex problems in a dynamic environment.

  • Collaborate with business users and analyze user requirements. This individual must have excellent oral and written communication skills. The individual must have strong interpersonal skills to build relationships and communicate effectively with all levels across the organization.

  • Solid communication skills and ability to work with global team.

  • Conduct Research/Design and Proof of Concepts for new data warehouse solutions.

  • Conduct and lead white-boarding sessions, workshops, design sessions, and project meetings as needed, playing a key role in IT and Business Unit relations.

  • Demonstrated ability to work effectively in a fast-paced, complex, and dynamic business environment.

  • Work independently or as part of a team to design and develop solutions using the tools available within Convergys. Pentaho ETL development is a plus.

  • Assist Warehouse Development team in understanding the designs and best way to implement them.

  • Assist in the estimating and planning of projects

  • Collaborate with the DW and Report development teams to standardize the warehouse structures to support reporting and analytics implementation(s) across a variety of Convergys business teams/users.

  • Review incoming Warehouse requests and determine if it is best fit through a standardized or custom solution. Determine the appropriate method for it to be developed and delivered.

  • Conduct walk-throughs of the Warehouse Development Team’s solutions to ensure best practices have been used and that it successfully meets the end user’s requirements.


USA, Cincinnati, OH

Language Requirements:

Time Type:

Full time

Who We Are

At Convergys, our mission is to set the standard in our industry through unparalleled care for our clients, customers & people.

For our clients, this means our 125,000 team members wake up every day united by a common goal: helping our clients maintain exceptional relationships with their customers.

For our people, this means a commitment to each other to accomplish great things, build careers, and have some fun along the way!

Build Your Career With Convergys

When you become part of our team, you join 125,000 talented people around the world who represent some of today’s leading brands. At Convergys, one of our values is to "Grow As a Team." It's in our DNA to prioritize teamwork and develop our people. By working together, we achieve great things for clients and create opportunities to build rewarding careers. You can be part of that when you join our team. And it's all at your fingertips!

Watch the video below to hear from some of our employees around the world as they talk about what it means to be part of the Convergys team.

Convergys has careers available in 31 countries at 150+ locations.

Establish your career with a company that has locations across the world. You can grow personally and professionally - and make a difference for customers and for the communities where we live and work.