Skip to content

Senior Technical Support Business Analyst, Data Warehousing

General Information

Ref #:


Travel Amount Required:


Job Type:

Regular-Full Time


Alpharetta - Georgia - United States, Atlanta - Georgia - United States, Branchburg - New Jersey - United States, Lowell - Massachusetts - United States, Weston - Florida - United States

Description & Qualifications


Are you an experienced professional with a strong background in data warehousing and passion for solving tough problems and helping customers? If you’d like to work in a dynamic environment helping support UKG’s growing portfolio of data-driven reporting and analytics offerings, apply to join our Data team today.
As a Level 3 Support Business Analyst for Data Warehousing, you will triage complex data issues and customer escalations, identify root causes, and provide resolution recommendations. You will engage engineering and infrastructure teams as required, providing them with clear direction and helping them bring the issue to resolution. You will communicate issue status to customers and internal stakeholders and make recommendations for preventing similar problems from happening again.

Duties and Key Responsibilities
• Triage complex data integrity issues that Level 1-2 support staff is unable to solve without expert assistance
• Develop and execute queries and scripts for data reconciliation and investigation of data issues
• Conduct issue diagnosis, research the root cause, and provide resolution recommendations
• Understand DW and ETL designs and associated business logic and identify discrepancies in data and reports resulting from the flaws in data pipelines
• Create and dispatch trouble tickets to the appropriate engineering, infrastructure, and product support teams when their involvement is required
• Collaborate with DW Product Management to prioritize issue resolution in the overall DW Engineering team backlog
• Communicate directly with customers and internal staff to collect additional information required to diagnose and solve the issue
• Provide timely and clear status updates to affected customers and UKG stakeholders at all levels, including technical and business leaders



Required Qualifications
• 5+ years of experience in a business analyst or similar role in large-scale enterprise software environments, preferably SaaS, experience working with customers, troubleshooting incidents and escalations
• Min Bachelor’s Degree in related fields
• Proficiency in advanced SQL and data analysis
• Experience in data warehousing technologies such as ETL, BI, databases, etc.
• Solid understanding of data warehousing concepts, architectures, and design principles
• Strong communication skills, including ability to communicate complex technical concepts to non-technical audiences
• Ability to work independently and make informed, consequential decisions without management supervisor

• Experience in customer support, help desk, sustaining engineering or similar organizations is a plus
• Experience with Google Cloud Platform and associated data warehousing technologies such as Beam and BigQuery is a plus
• Experience with MySQL and/or SQL Server databases is a plus
• Experience with messaging systems such as Kafka, RabbitMQ, etc. is a plus
• Experience with ETL tools like Talend, Informatica, SSIS, etc. is a plus
• Experience in the HRMS/Payroll industry is a plus

Company Overview

Here at UKG, Our Purpose Is People. UKG combines the strength and innovation of Ultimate Software and Kronos, uniting two award-winning, employee-centered cultures. Our employees are an extraordinary group of talented, energetic, and innovative people who care about more than just work. We strive to create a culture of belonging and an employee experience that empowers our people. UKG has more than 13,000 employees around the globe and is known for its inclusive workplace culture. Ready to be inspired? Learn more at

EEO Statement

Equal Opportunity Employer

Ultimate Kronos Group is proud to be an equal opportunity employer and is committed to maintaining a diverse and inclusive work environment. All qualified applicants will receive considerations for employment without regard to race, color, religion, sex, age, disability, marital status, familial status, sexual orientation, pregnancy, genetic information, gender identity, gender expression, national origin, ancestry, citizenship status, veteran status, and any other legally protected status under federal, state, or local anti-discrimination laws. 

View The EEO is the Law poster and its supplement. 

View the Pay Transparency Nondiscrimination Provision

UKG participates in E-Verify. View the E-Verify posters here.

Disability Accommodation

For individuals with disabilities that need additional assistance at any point in the application and interview process, please email or please call 1 (978) 250 9800.