Data Analyst - T1389849BCC_46528583812_12-4658

Beacon Hill Staffing Group - Springfield, IL

Full-time

Remote - Springfield, IL

Administrative and Support Services

About the position

The Data Analyst position at Beacon Hill Staffing Group involves joining a team focused on a transformative data migration project. The role is critical in ensuring the smooth transition of vital claims and case data from legacy systems into a modern, cloud-based platform powered by AWS and Snowflake. The ideal candidate will have experience in enterprise environments, particularly in companies providing group benefits such as health and life insurance, and will be responsible for maintaining data accuracy and integrity throughout the migration process.

Responsibilities

• Extract data from mainframe and SQL databases, transfer it into Excel, and manually enter it into the new system.
• Ensure data accuracy and integrity throughout the migration process.
• Migrate insurance claims and case data from the legacy systems into Excel, followed by keying it into the new system.

Requirements

• 5+ years of data analysis experience.
• Strong proficiency in SQL and Excel, including pivot tables and VLOOKUP.
• Experience working with mainframe and SQL databases.

Nice-to-haves

• Experience working in AWS environments.