Constellation Insurance, Inc.

Role Description The Tax Intern role offers college students hands-on experience supporting state and local tax compliance within a corporate finance environment. Working alongside experienced tax professionals, this fully remote internship provides exposure to real-world tax filings, research on tax law changes, and cross-functional collaboration. The role is designed to help students apply academic learning to practical work while building foundational skills for a future career in accounting, finance, or tax. Here's a glimpse of your responsibilities and the meaningful impact you'll create as the Tax Intern: - Assist with the preparation of state and local income tax filings, including estimates, returns, and quarterly filings - Support compliance with applicable federal, state, and local tax laws to ensure timely and accurate reporting - Research current tax law changes related to assigned filings - Assist with tax-related documentation and analysis - Support special projects and ad hoc requests within the Tax department - Collaborate with team members while developing professional and technical skills Qualifications - Currently enrolled in a Bachelor's or Master's degree program in Accounting, Finance, or Taxation - Basic knowledge of accounting and tax concepts - Proficiency in Microsoft Office, including Word, Excel, and PowerPoint - Strong written and verbal communication skills - Ability to follow instructions, manage multiple tasks, and work independently or as part of a team - Ability to research tax topics and prepare written summaries or analysis - Experience preparing simple tax returns or tax-related documents - Positive attitude and eagerness to learn - Availability to work full-time during the Summer (approximately May--August) Benefits - Competitive pay: Fair compensation for your hard work. - Dress for your day: Express your style comfortably at work. - Inclusion and Culture: A respectful environment that values unique contributions. - Flexible work options: Remote, hybrid, and onsite opportunities at various locations across the U.S. for better work-life integration. - Well-being focus: Programs to support a healthy balance between work and home life. - Community connections: Build strong relationships through virtual and in-person interactions, with resources for your growth.

Role Description The Institutional Sales Compensation Analyst will pay compensation in a timely and accurate manner on business produced through the Institutional Sales Distribution Channel. The Analyst must provide excellent customer service to the distribution team, broker dealer back offices, agents, and other internal/external customers. The Analyst must have in-depth knowledge of AWD, Performance Plus, and SCS systems, and the ability to answer complex questions regarding the calculation of commissions and in-force selling agreements. Here's a glimpse of your responsibilities and the meaningful impact you'll create as the Institutional Sales Compensation Analyst: - Process work types from AWD and work in Performance Plus - Meet the department standard of 95% accuracy and meet productivity requirements - Maintain broker dealer commission rate tables - Commission cycle processing and disbursement - Interact with both internal and external Institutional sales organizations to answer complex questions and to resolve critical issues when they occur - Perform necessary controls to ensure compliance with all internal and external rules and regulations - Support the Traditional/IMO Distributor Comp team as required, based on the needs of the department - Process queue work, assist with individual responsibilities, etc. Qualifications - Four year college degree or business equivalent - Strong written and verbal communication skills - Strong analytical skill and attention to detail - Ability to apply basic algebraic concepts in the calculation of commissions and production credit - Excellent PC skills, competent with Microsoft Office and mainframe systems - Must exhibit excellent team skills to ensure department standards and guidelines are met - Thorough understanding of AuguStar agent contracts, selling agreements, and supplements Benefits - Competitive pay: Fair compensation for your hard work. - Healthcare coverage: Comprehensive medical, dental, and vision from day one. - Life insurance: Company-paid coverage for you and your loved ones. - 401(k) plan: Matching contributions to help secure your financial future. - Family support: Paid parental leave and reimbursement for adoption and surrogacy expenses. - Work-life balance: Flexible time-off policy to recharge and pursue passions. - Dress for your day: Express your style comfortably at work. - Inclusion and Culture: A respectful environment that values unique contributions. - Flexible work options: Remote, hybrid, and onsite opportunities at various locations across the U.S. for better work-life integration. - Well-being focus: Programs to support a healthy balance between work and home life. - Community connections: Build strong relationships through virtual and in-person interactions, with resources for your growth.

Role Description The Software Engineer II is designed to build and demonstrate core engineering competency through the application of established programming practices to real-world problems. The position involves delivering reliable, high-quality code by executing structured programming assignments based on clear specifications, while developing a strong understanding of data processing and system requirements. - Maintain, enhance, and support existing applications, interfaces, and vendor systems. - Develop new features and application enhancements independently or collaboratively. - Gather and translate user requirements for small, low-risk projects. - Design and execute test plans, including manual and automated testing. - Plan, track, and communicate project progress and status. - Participate in on-call support and resolve service-related issues. - Contribute across all phases of the SDLC, including design, development, testing, implementation, and training. - Write, test, and debug efficient, high-quality code. - Support technical design discussions and participate in code reviews. - Collaborate with cross-functional teams, including Business Analysts, QA, and Project Managers. - Mentor junior engineers and promote development best practices. - Develop and maintain technical documentation and operational procedures. - Analyze, diagnose, and resolve user-reported issues. - Develop and support client-facing applications and provide end-user training. - Troubleshoot application and interface issues, ensuring successful user acceptance and system functionality. Qualifications - Bachelor's degree in information systems, computer science, or a related field, or equivalent practical experience. - 4-6 years of relevant software development experience. - Strong problem-solving skills, with the ability to troubleshoot issues and translate business requirements into technical solutions. - Excellent written and verbal communication skills. - Experience creating technical documentation and system specifications. - Demonstrated ability to collaborate effectively with cross-functional teams and maintain a strong customer-focused approach. - Proficiency with programming languages and modern development frameworks. - Experience with version control and release management tools. - Knowledge of data integration, security best practices, and system design principles. - Basic understanding of data architecture and data governance. - Solid understanding of the software development lifecycle (SDLC), including testing methodologies. Requirements - Interpreting and aligning technical requirements from IT Architects, Business Analysts, Project Managers, QA teams, and end users. - Translating general guidelines into effective solutions for specific problems. - Strong understanding of existing systems and how they support evolving business needs. - Proactive, action-oriented mindset with a strong emphasis on continuous development through hands-on experience and on-the-job learning. Benefits - Competitive pay: Fair compensation for your hard work. - Healthcare coverage: Comprehensive medical, dental, and vision from day one. - Life insurance: Company-paid coverage for you and your loved ones. - 401(k) plan: Matching contributions to help secure your financial future. - Family support: Paid parental leave and reimbursement for adoption and surrogacy expenses. - Work-life balance: Flexible time-off policy to recharge and pursue passions. - Dress for your day: Express your style comfortably at work. - Inclusion and Culture: A respectful environment that values unique contributions. - Flexible work options: Remote, hybrid, and onsite opportunities at various locations across the U.S. for better work-life integration. - Well-being focus: Programs to support a healthy balance between work and home life. - Community connections: Build strong relationships through virtual and in-person interactions, with resources for your growth.

Role Description The AVP, Annuity Valuation AXIS Modeler directs a small team and has a lead role in AXIS modeling for annuity product-related projects, with close interaction on life and disability insurance initiatives. Responsibilities include: - Implementing regulatory changes (such as LDTI and VM22). - Managing reinsurance and capital optimization projects for inforce, acquired blocks, and new products. - Supporting valuation and reporting under multiple accounting bases. - Driving improvements in actuarial modeling processes. - Leading implementation of Long-Duration Targeted Improvements (LDTI), including methodology design, transition approach, data, testing, and audit support. - Collaborating with cross-functional teams (Actuarial, Finance, IT) to gather requirements and implement modeling and reporting solutions for new treaties and products. - Performing model validation, assumption testing, and financial analysis to ensure accuracy, compliance, and efficient runtime performance. - Analyzing and interpreting model results, preparing financial reporting deliverables, and providing insights into profit drivers, earnings projections, and capital impacts. - Providing support during audits and regulatory examinations, addressing inquiries and maintaining robust documentation. - Developing, enhancing, and maintaining actuarial models in AXIS software to support valuation and reporting across US GAAP LDTI/GAAP and statutory frameworks. - Staying informed of industry developments and evolving regulatory requirements internationally (US GAAP, IFRS17, local RBC frameworks) and integrating them into actuarial models and processes. - Mentoring junior team members, leading project meetings, and providing training on AXIS modeling and actuarial reporting processes. Travel domestically for quarterly company meetings. Reports to HQ at 1 Financial Way, Cincinnati, OH 45242 but may telecommute from anywhere. Qualifications - Bachelor's degree in actuarial science, mathematics, statistics, or related field. - Fellow of the Society of Actuaries. - Ten years of experience in actuarial roles, with specific experience in relevant modeling and project experience. - Three years of experience with AXIS software, including building, validating, and maintaining models for pricing and valuation. - Three or more years of experience with US GAAP reporting, including LDTI implementation. - Three years of experience quantifying impacts and identifying trends. - Two years of leadership experience, including managing teams and projects independently. - Experience collaborating with cross-functional teams (Finance, IT, senior management) on actuarial and reporting initiatives. - Excellent communication and influencing skills, with demonstrated experience presenting to senior management and driving decision-making. - Hands-on experience with LDTI frameworks, including methodology, systems, and process enhancements. - Prior involvement in audit engagement and preparation of supporting documentation for regulatory examinations. - Demonstrated ability to drive process improvements and automation within actuarial modeling or reporting functions. Requirements - Travel domestically for quarterly company meetings. - Reports to HQ at 1 Financial Way, Cincinnati, OH 45242 but may telecommute from anywhere. Benefits - Salary: $142,230+ - Apply online at https://myjobs.adp.com/constellationinsurancecareers/cx Company Description THIS NOTICE IS BEING POSTED IN CONNECTION WITH THE FILING OF AN APPLICATION FOR PERMANENT ALIEN LABOR CERTIFICATION. ANY PERSON MAY PROVIDE DOCUMENTARY EVIDENCE BEARING ON THE APPLICATION TO THE REGIONAL CERTIFYING OFFICER OF THE U.S. Department of Labor, EMPLOYMENT AND TRAINING ADMINISTRATION, OFFICE OF FOREIGN LABOR CERTIFICATION, 200 CONSTITUTION AVENUE NW, ROOM N-5311, WASHINGTON, DC 20210.

Role Description As the Actuarial Coordinator, Special Projects, you will play a key role in supporting enterprise-wide actuarial initiatives across annuity and life businesses. Unlike traditional valuation roles, this position is project-driven and focused on strategic initiatives, regulatory developments, model enhancements, and new product implementations. This role requires strong hands-on AXIS modeling expertise and the ability to operate independently in a dynamic, cross-functional environment. - Leading and supporting enterprise actuarial initiatives, including regulatory changes (e.g., VM-22) and model governance improvements - Supporting new product implementation and model development within AXIS - Performing in-depth AXIS liability modeling, including assumption updates, sensitivity testing, and model validation - Supporting asset and ALM modeling within AXIS, including integration of asset cash flows and liability projections where applicable - Performing model output validation, reconciliations, and analytical reviews to ensure accuracy and control integrity - Assisting with financial reporting impacts related to modeling changes (statutory, GAAP, and LDTI, as applicable) - Partnering with Finance, IT, Risk, and external stakeholders to coordinate deliverables and resolve technical issues - Supporting documentation of methodologies, model governance, and control frameworks - Contributing to process improvements to strengthen efficiency, transparency, and audit readiness This role is ideal for a technically strong actuarial professional who enjoys complex problem-solving, cross-functional collaboration, and working on high-impact initiatives that shape the company's actuarial infrastructure. Qualifications - A bachelor's degree in actuarial science, mathematics, statistics or related field - ASA designation or progression towards an FSA designation - At least five years in actuarial roles is expected - Direct, hands-on AXIS modeling experience in a production environment (required) - Excellent communication and influencing skills - Demonstrated experience with building and fostering relationships - Strong problem-solving skills - Strong analytical skills including the ability to quantify impacts and synthesize data from multiple sources and identify trends Benefits - Competitive pay: Fair compensation for your hard work. - Healthcare coverage: Comprehensive medical, dental, and vision from day one. - Life insurance: Company-paid coverage for you and your loved ones. - 401(k) plan: Matching contributions to help secure your financial future. - Family support: Paid parental leave and reimbursement for adoption and surrogacy expenses. - Work-life balance: Flexible time-off policy to recharge and pursue passions. - Dress for your day: Express your style comfortably at work. - Diversity and inclusion: A respectful environment that values unique contributions. - Flexible work options: Remote, hybrid, and onsite opportunities at various locations across the U.S. for better work-life integration. - Well-being focus: Programs to support a healthy balance between work and home life. - Community connections: Build strong relationships through virtual and in-person interactions, with resources for your growth.