Stellar Life Insurance Company Seeks SQL BSA (REMOTE!)

Posted 2025-04-22
Remote, USA Full-time Immediate Start

Company Name: A Great Life Insurance Company

Job Title: Business Systems Analyst X2

Style: 9-12 month contract + ext, could convert to FTE after 6 months, could extend

# Positions: 2

Target Conversion Salary: $70,000-$90,000

Location: Remote, but on site once a quarter in Wisconsin may be required

Duties:
? Working with stakeholders/business to gather requirements.
? Creating UAC for Agile stories (this is a scrum team on 2-week sprints).
? Creating test plans for stories.
? Executing test plans for stories.
? SQL query experience.
? Insurance experience is a plus.
? These are on our Data team, so someone who has worked with data/reporting would be good too.

Work Hours: Standard office hours

Experience Needed:
? Minimum of three years of experience in business system analysis, system testing, or related field required.
? Working in an Agile team environment required.
? Insurance industry knowledge preferred with a strong understanding of multiple functional areas.
? Experience using ID3, OIPA, OnBase, Eloquence, or Salesforce preferred.
? Experience working with third-party vendors is a plus.
? Minimum of one year of experience writing SQL queries desired.

Job Description:

Business Systems Analyst

Position Summary: The Business Systems Analyst is accountable for providing Business, System, and Data Analysis, Quality Assurance, and Production Support ensuring quality solutions are delivered that meet business needs. This role operates under minimal supervision in a team environment. Primary responsibilities include acting as a liaison between the business and IT, supporting both systems and processes, and delivering quality solutions. Tasks assigned to this level require a general understanding of the company-wide system processes and solution requirements as well as data structures of the system being utilized. Work includes independently analyzing the business process, documenting requirements, and recommending solutions. This role also includes advocating for quality solutions by creating and executing test plans. Business Systems Analysts must be able to work in a changing, fluid environment that is dedicated to continuous improvement.

Responsibilities: ? Quality Assurance: Perform and support a full cycle of testing functions including exploratory, integration, system, regression, performance, and user-acceptance testing. Develop, execute, and maintain test plans, test scenarios, test cases, and test scripts. Write queries as needed for testing/analysis of data. Document and evaluate test results and defects; ensure that quality issues and defects are appropriately identified, prioritized, documented, tracked, and resolved. Work with the team and business units to identify and develop acceptance criteria; apply understanding of acceptance criteria to test and evaluate new or modified software features and functionality with an emphasis on delivering high-quality software. Assist in building and maintaining a stable and reliable automated testing infrastructure. Identify testing challenges that arise and collaborate with others to resolve. Follow best practices for quality assurance; implement, adopt, and document applicable testing practices and expectations. Accountable for identifying features and functions that are impactful to the business so that Risk Base Testing is properly executed. Recreate business processes and functionality in test environments to ensure business needs have been met. Facilitate UAT with stakeholders. ? Business Systems Analysis: Collaborate with stakeholders and IT team members to develop end-to-end technical solutions across teams that improve operational capabilities and customer experience. Identify and foresee both business process and system issues, perform analysis, and recommend solutions so respective business functions can successfully run the business and are using properly functioning technology. Lead without authority, facilitate business need sessions, document, and translate business needs into usable functional/nonfunctional requirements. Communicate to the business areas using simple, non-technical language but can consult with IT in a more technical manner. Act in a liaison role between the business and IT. ? Data Analysis: Understand the meaning of business data in order to specify how the data enables work activity in respective and cross-functional business functions. Query, extract, and analyze business data to identify patterns and solutions to root causes of problems. ? Production Support: Provide process and system support as necessary to ensure the business is functioning effectively. Support and complete system configuration work. Coordinate with the team and business stakeholders to ensure operational stability in their software product and follow up on any reported issues. Analyze, research, and document reported problems and resolution. Provide system support including maintenance, upgrades, and releases. ? Other: Participate in Daily Stand-up, Release Planning, Review, and Retrospective meetings. Be a positive influence to other members of the team and with other departments of the organization. Represent and communicate the mission and values of A Great Life Insurance Company and comply with conduct policy, security policy, and confidentiality expectations. Effectively facilitate meetings with stakeholders, team members, or vendors.

Qualifications:

Knowledge, Skills, and Abilities:
? Self-motivated with the ability to work independently and in a collaborative team environment.
? Ability to bring stakeholders together and influence at all levels of the organization.
? Excellent analytical, critical thinking, and problem-solving skills.
? Ability to help drive decision-making.
? Understands techniques related to diagramming, modeling, and prototyping.
? Excellent verbal, written, and interpersonal communication skills.
? Ability to bring groups of stakeholders together using effective facilitation and presentation skills.
? Solid understanding of testing techniques and tools.
? Passion for mentoring and providing knowledge to others.
? Proficient in all necessary technology, including computers, software applications including Microsoft Office Tools, Confluence, and JIRA.
? Knowledgeable in policy administrative systems and development processes with an emphasis on agile methodology.
? Ability to extract meaning from data.
? Insurance industry knowledge preferred with a strong understanding of multiple functional areas.
? Experience working with third-party vendors.

Education Requirements: ? 4-year degree preferred.

Years of Experience:
? Minimum of three years of experience in business system analysis, system testing, or related field required.
? Working in an Agile team environment required.
? Insurance industry knowledge preferred with a strong understanding of multiple functional areas.
? Experience using ID3, OIPA, OnBase, Eloquence, or Salesforce preferred.
? Experience working with third-party vendors is a plus.
? Minimum of one year of experience writing SQL queries desired.

Beacon Hill is an equal opportunity employer and individuals with disabilities and/or protected veterans are encouraged to apply.

California residents: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser: https://jobs.beaconhillstaffing.com/eeoc/

Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.

Company Profile:

Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.

Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.

Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.bhsg.com.

Benefits Information:

Beacon Hill offers a robust benefit package including, but not limited to, medical, dental, vision, and federal and state leave programs as required by applicable agency regulations to those that meet eligibility. Upon successfully being hired, details will be provided related to our benefit offerings.

We look forward to working with you.

Beacon Hill. Employing the Future?

Apply Job!

 

Similar Jobs

Back to Job Board