• Job Description

  Req#: R-25008

  Our story

  At Alight, we believe a company’s success starts with its people. At our core, we Champion People, help our colleagues Grow with Purpose and true to our name we encourage colleagues to “Be Alight.”

  Our Values:

  Champion People – be empathetic and help create a place where everyone belongs.

  Grow with purpose – Be inspired by our higher calling of improving lives.

  Be Alight – act with integrity, be real and empower others.

  It’s why we’re so driven to connect passion with purpose. Our team’s expertise in human insights and cloud technology gives companies and employees around the world the ability to power confident decisions, for life.

  With a comprehensive total rewards package, continuing education and training, and tremendous potential with a growing global organization, Alight is the perfect place to put your passion to work.

  Join our team if you Champion People, want to Grow with Purpose through acting with integrity and if you embody the meaning of Be Alight.

  Learn more at careers.alight.com.

  As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions as part of our Technology Team. The Puerto Rico Client Technology Specialist I - System Analyst is responsible for systems requirements, files and/or interfaces development, configuration of internal platforms, or new/existing projects. The Puerto Rico Client Technology Specialist I - System Analyst will broaden his or her skills to other platforms and/or other services.

  Key Responsibility Areas:

  • Knowledge of T-SQL (Transact Structure Query Language) including stored procedures, views, and functions for reports used by internal and external clients.
  • Internal applications (H&W, Cobra, and LOA platforms) access provision to ensure authorized and unauthorized access to production data.
  • Ongoing maintenance of assigned and unassigned database projects.
  • Enhancement of existing system requirements based on new/changing business requirements.
  • You must report, research, correct, and test defects in files and/or interfaces, stored procedures, and other database related functions such as to run queries to analyze, review data accuracy and ensure quality.
  • Ability to accurately translate business requirements into functional implementations.
  • Provides ongoing production support by monitoring productions jobs, restarting failed jobs, and performing defect analysis and correction.
  • Investigate data and system troubleshooting maintaining accurate documentation on internal issue databases (Lotus issue database, Maestro issues, etc.).
  • Identify Root Cause of System Problems.
  • Ensures Optimal Solution to Potential System Issues.
  • Keep Others Informed.
  • Looks for opportunities to improve processes.
  • Coaching Benefit Center on processing procedures and system functionality.
  • Research complex participant benefit issues and formulates resolutions/recommendations by analyzing fact patterns and applying plan provisions and best practices.
  • Provides resolution in accordance with due dates and documents processes.
  • Provide technical expertise with internal and external users regarding data files/interfaces.
  • Manage all the programming and maintenance activities of electronic interface incoming and outgoing files for clients that have contracted our service.
  • Evaluate programming code (business rules) for efficiency, debugging, and quality assurance.
  • Understand data requirements and file/interface layouts required by internal/external clients and third parties and translate those requirements into file/interface specifications.
  • Design, update, and deliver unit, integration, regression, and acceptance test plans to ensure data integrity and reporting requirements meet customer needs.
  • Execute data reconciliation before and after implementation as part of the data conversion project.
  • Identify the problem's root cause, address the issue with the corresponding team, and provide relevant information that needs to be evaluated for alternative fixes.
  • Complete configuration, programming, testing, troubleshooting, and maintenance of all file interfaces into internal platforms.
  • Performing massive data uploads and supporting data conversion processes for new and existing clients.
  • Coordinate follow-up meetings with clients or vendors for new files interfaces implementation or updates to existing files interfaces.
  • Provide technical expertise with internal and external users regarding data files/interfaces.
  • Develop and maintain technical documentation.
  • Coach the Operation Team department on processing procedures and system functionality.
  • Provide resolution in accordance with due dates and documents processes.
  • Create SOPs for new processes related to supporting areas that will need to be put in place for the Operational Team to be able to address special requests or address service for our customers.
  • Replicate errors in our QC environment when a problem has been identified, fix and retest until it meets customer needs before moving into the production environment.
  • Document and update client technical data such as requirements according to analysis specifications.

  Formal Education & Certification:

  Bachelors/Master’s Degree in Computer Engineering/Computer Science

  • 4 + years of industry experience including: -
  • Strong verbal and written communication skills.
  • Structured programming, design, and language(s) understanding of application architecture and technology infrastructure (proficient).
  • Appropriate operating systems, MS Windows Server environment.
  • Application security best practices
  • Relational databases and data models (T-SQL, Stored Procedures, Views, and Triggers) including SQL Server environment.
  • Knowledge in transaction system construction and design best practices.
  • Strong testing and debugging skills.
  • Client plan provisions and business requirements (basic).
  • A solid understanding of the systems development life cycle (SDLC), Testing Methodology /or Human Resources, Human Capital Management, or benefits administration solutions experience is a plus.

  Flexible Working

  So that you can be your best at work and home, we consider flexible working arrangements wherever possible. Alight has been a leader in the flexible workspace and “Top 100 Company for Remote Jobs” 5 years in a row.

  Benefits

  We offer programs and plans for a healthy mind, body, wallet and life because it’s important our benefits care for the whole person. Options include a variety of health coverage options, wellbeing and support programs, retirement, vacation and sick leave, maternity, paternity & adoption leave, continuing education and training as well as a number of voluntary benefit options.

  By applying for a position with Alight, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Alight’s employment policies. Background checks may include some or all the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position.

  Our commitment to Diversity and Inclusion

  Alight is committed to diversity, equity, and inclusion. We celebrate differences and believe in fostering an environment where everyone feels valued, respected, and supported. We know that diverse teams are stronger, more innovative, and more successful.

  At Alight, we welcome and embrace all individuals, regardless of their background, and are dedicated to creating a culture that enables every employee to thrive. Join us in building a brighter, more inclusive future.

  Diversity Policy Statement

  Alight is an Equal Employment Opportunity employer and does not discriminate against anyone based on sex, race, color, religion, creed, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, marital or domestic partner status, citizenship, military or veteran status, sexual orientation, gender, gender identity or expression, genetic information, or any other legally protected characteristics or conduct covered by federal, state or local law. In addition, we take affirmative action to employ and advance in the employment of qualified minorities, women, disabled persons, disabled veterans and other covered veterans.

  Alight provides reasonable accommodations to the known limitations of otherwise qualified employees and applicants for employment with disabilities and sincerely held religious beliefs, practices and observances, unless doing so would result in undue hardship. Applicants for employment may request a reasonable accommodation/modification by contacting his/her recruiter.

  Authorization to work in the Employing Country

  Applicants for employment in the country in which they are applying (Employing Country) must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the Employing Country and with Alight.

  Note, this job description does not restrict management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units.

  We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.
  

  Pay Transparency Statement: Alight takes into consideration a candidate’s experience, education, certification/credentials, market data, internal equity, and geography when determining an offer for a successful employment candidate, and Alight does so on an individualized, non-discriminatory basis. Therefore, an offer may fall anywhere between the estimated minimum base salary for this role of $40,810.00/year (for full time employees) and the estimated maximum base salary for this role of $58,300.00/year (for full-time employees). Alight also offers a comprehensive benefits package; for specific details on our benefits package, please visit: https://careers.alight.com/us/en/alight-us-benefits-2023

  
  DISCLAIMER:

  
  Nothing in this job description restricts management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units.

  Alight Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, genetic information, pregnancy, childbirth or related medical condition, veteran, marital, parental, citizenship, or domestic partner status, or any other status protected by applicable national, federal, state or local law. Alight Solutions is committed to a diverse workforce and is an affirmative action employer.

• About the company

  Alight Solutions is an Information technology and consulting company based in Lincolnshire, Illinois.

Notice