About the role
*This position is 100% on site in downtown Cincinnati, Ohio. We do not offer remote work nor do we assist with relocation.
Join Western & Southern – Somewhere You Want to Be
Western & Southern is somewhere to grow, lead, win and do good for others. Our supportive culture, continuous learning opportunities and connection to our local communities make our company the ideal place for a career. For more than 137 years, our long-term success has been fueled by a deep commitment to customer service and our community.
Headquartered in Cincinnati, W&S is a Fortune 500® company recognized as one of America’s Best Midsize Employers by Forbes. Our commitment to career growth and employee development earned us a top 100 ranking on the American Opportunity Index (AOI). We are dedicated to creating opportunities for our associates to grow and succeed. We take pride in our award-winning talent development team and our recognition as a Top 10 Military Friendly Employer and Top Spouse Employer.
Our Culture: Excellence and Collaboration
Western & Southern is built on a culture of integrity, top-notch performance, teamwork and collaboration. We’re committed to hiring and developing professionals who strive for excellence, demonstrate strong ethics and make fact-based decisions. Our associates are empowered to chase their career dreams while being supported every step of the way.
A Day in the Life of a Data Integration Engineer II
The SQA Data Integration Engineer II partners with management and team members to define, implement, and continuously improve data warehouse and Business Intelligence testing strategies, standards, and processes. This role develops and maintains project-level data testing frameworks, drives innovation to improve testing efficiency, and provides expertise in automating data warehouse and operational data store validations. The engineer also mentors peers and junior DI Engineers, and plays a key role in ensuring data quality, consistency, and maintaining sustainable test automation practices.
Key Tools & Technologies You’ll Work With:
• SQL
• NoSQL
• MongoDB
• Oracle
• Informatica
• DB2
• XML
• Flat Files
Responsibilities:
• Lead and standardize enterprise data integration test strategies.
• Manages the process for accepting, provisioning, and fulfilling data requests from ongoing projects, coordinating with the release team to align timelines with integrated application environments and code availability.
• Design, execute, and maintain automated ETL, data warehouse, and operational data store testing using Informatica and related tools.
• Develop and maintain reusable, scalable data testing frameworks, standards, and drive continuous improvement in data testing processes.
• Mentor and train data testing team members while ensuring compliance with enterprise policies and standards.
Job Requirements
• Preferred: hands-on experience writing complex SQL queries for testing ODS, Data Marts, Relational Databases, NoSQL databases, and Data Warehouses.
• Preferred: hands-on experience with various Data Integration / Business Intelligence testing in a complex environment working with an engine based ETL tool as well as Cognos or Tableau reporting tools.
• Preferred: Hands-on experience with data concepts including OLTP, OLAP, centralized, functional, federated data warehouses, data merging, cleansing, scrubbing, aggregation, dependent and independent data marts, star schema, various table dimensions, types of facts and fact tables, dimension modeling, and different types of OLAPs.
• Hands-on experience in software test engineering using the Software Testing Life Cycle (STLC).
• Experience with data models from a technical solution and business use.
Premier Benefits to Support You
We offer a comprehensive benefits package, including:
• Medical, dental, vision, and life insurance.
• 401(k) savings plan with pension options.
• Paid time off increasing with tenure.
• Tuition reimbursement and individualized career development plans.
• Parental leave and maternity leave with a 4-week transition back to work.
• Access to on-site amenities like a fitness center, cafeteria and more.
• Extensive employee discount program.
Western & Southern is not just a place to work—it’s somewhere to grow, lead, win and make a difference in your career and community. Learn more at www.westernsouthern.com/careers/home-office-careers.
From Fortune ©2025 Fortune Media IP Limited. All rights reserved. Used under license. Fortune and Fortune 500 are registered trademarks of Fortune Media IP Limited and are used under license. Fortune and Fortune Media IP Limited are not affiliated with, and do not endorse the products or services of Western & Southern Financial Group.
Millions of jobs, with real people getting hired every day
Questions, answered
Click "Apply with JobAssist" – we tailor your resume and application to this role and submit it for your approval.
Yes. This role at Western & Southern Financial Group was screened before publishing – we confirmed the employer before listing it.
The employer didn't disclose a salary range for this listing. JobAssist shows pay whenever it's available.
This position can be done from anywhere, with no in-office requirement.
Yes – every application is tailored from your profile and this job's requirements, and you can review and edit before it's sent.