Integration Consultant II (SQL Developer)

As a Consultant at UKG, you will be responsible for designing, configuring, and implementing Benefits solutions within the UKG Pro platform. Your expertise in MSSQL for reporting, interfaces, and troubleshooting, along with in-depth domain knowledge of Benefits administration and integration, will be crucial for success. Key Responsibilities: - Understand customer requirements related to Benefits setup, eligibility, enrollment, and compliance. - Design, configure, and implement Benefits modules within UKG Pro. - Create and maintain MSSQL queries, stored procedures, and reports to support Benefits processing and integrations. - Develop inbound/outbound interfaces with third-party Benefits providers. - Prepare and maintain design documents, configuration guides, and test scripts. - Support User Acceptance Testing (UAT) and resolve issues during test cycles. - Deploy solutions to production environments and provide transition-to-support documentation. - Upgrade clients to newer UKG Pro releases and ensure Benefits functionality is delivered seamlessly. - Collaborate with customers during evening calls (as needed) to align with US time zones and project schedules. - Support major Benefits releases, open enrollment cycles, and compliance updates. Qualifications: - Bachelor's degree or equivalent in Computer Science, Information Systems, or a related field. - Strong expertise with MSSQL (queries, stored procedures, performance tuning, troubleshooting). - Hands-on experience configuring Benefits modules within HCM systems (preferably UKG Pro). - Solid understanding of Benefits administration (eligibility rules, enrollment, open enrollment, COBRA, ACA, 401k, etc.). - Experience integrating with third-party providers for Benefits (healthcare, retirement, insurance vendors). - Knowledge of data mapping, ETL processes, and interface design. - Excellent oral and written communication skills. - Strong analytical, problem-solving, and customer-facing skills. At UKG, you will be part of a team that is on a mission to inspire every organization to become a great place to work through award-winning HR technology. With a focus on diversity and inclusion, UKG is committed to promoting a collaborative and inclusive workplace environment.,