Careers

Business Intelligence Developer

Constellation Service Company, headquartered in Topeka, KS, is seeking a Business Intelligence Developer to help drive decision-making across our organization through meaningful data reporting and analysis. You’ll work closely with subject matter experts to create custom reports, dashboards, and KPIs using Microsoft SQL Server and Power BI. This role is ideal for someone who thrives in a fast-paced, collaborative environment and enjoys solving business problems with data.

Responsibilities:

• Design, develop, and maintain custom reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI
• Write and optimize T-SQL queries, stored procedures, functions, and views to support reporting needs
• Collaborate with stakeholders to define and refine KPIs and performance metrics
• Serve as an internal data consultant, helping teams interpret and use data effectively
• Analyze and validate data to ensure accuracy and consistency across reports
• Assist with ERP system administration, particularly related to reporting and data access

Payroll Administrator

Position Summary:

Constellation Service Company is seeking a highly organized and detail-oriented Payroll Administrator to manage weekly payroll processing for a multi-entity, multi-state organization. This role plays a critical part in ensuring all employees are paid accurately and on time, while maintaining compliance with state and federal payroll regulations.

Ideal candidates will have experience in complex payroll environments, strong communication skills, and a collaborative mindset to work effectively with HR, accounting, and field operations.

Key Responsibilities:

• Review, audit, and process weekly timecards for accuracy and compliance
• Handle time corrections and timecard exceptions as needed
• Maintain employee payroll records, including wage rates, union classifications, and labor cost rates
• Maintain and update payroll templates, including union jurisdictions and prevailing wage rates
• Ensure timely and accurate processing of payroll-related tax and benefit payments
• Prepare and submit certified payroll reports and union remittances
• Coordinate with HR to ensure proper onboarding, employee classification, and deduction setup
• Maintain accurate records for ACA compliance and benefit eligibility tracking
• Process terminations; verify timing of inactivation and support COBRA eligibility processing
• Collaborate with HR during open enrollment; maintain data accuracy in payroll system and benefits portals
• Monitor payroll-related compliance including federal and state returns (e.g., 941s, 940s, SUTA)
• Provide reporting for workers’ compensation and labor allocations
• Support audits and internal reporting requests

Risk and Insurance Analyst

Company Overview:

Constellation Service Company is a dynamic and forward-thinking organization committed to fostering a culture of safety, compliance, and strategic growth. We are seeking a highly detail-oriented and proactive Risk and Insurance Analyst to join our team. This is an excellent opportunity for individuals with a background in insurance, risk analysis, or legal compliance to contribute to critical company initiatives.

Position Overview:

The Risk and Insurance Analyst will be a hands-on contributor to the company’s risk management initiatives, with a primary focus on insurance and claims administration. The role includes managing insurance claims, maintaining compliance records, and serving as the liaison between business units and the company’s insurance broker. This is not a managerial position but requires a highly organized professional who excels in executing detailed administrative and compliance-related tasks.

Key Responsibilities:

1. Insurance and Claims Administration:

• Manage the company’s insurance claims process, ensuring accurate and timely filing, effective communication with internal stakeholders, and resolution in coordination with the insurance broker.
• Oversee administrative aspects of the bonding program, ensuring compliance with all bonding requirements and timely renewals.
• Act as the primary liaison between business units and the insurance broker for updates, policy administration, and claims inquiries.

2. Compliance Support:

• Review Certificates of Insurance (COIs) to verify accuracy and alignment with company requirements.
• Monitor and maintain compliance with internal policies, regulatory requirements, and industry best practices.
• Conduct research and provide analysis to support risk management and compliance initiatives.

3. Contract and Document Review:

• Review contracts, agreements, and related legal documents to identify potential risks or areas requiring clarification.
• Collaborate with business units to ensure accurate documentation and timely collection of outstanding contracts.

Interested in our company?

Don't see the right position? Apply here and tell us what you're good at. We are always looking for talented people to join our team.