Data Analyst
Beacon Hill Staffing Group, LLC

Job Info

---

Our client is seeking to hire a Data Analyst to join their team. The ideal candidate will have experience working an enterprise environments, and specifically companies who provide group benefits such as health, life, disability insurance, and retirement plans. The Data Analyst will join a division which is embarking on an exciting and transformative data migration project. The goal is to move vital claims and case data from legacy systems (mainframe and SQL databases) into a cutting-edge, cloud-based platform powered by AWS and Snowflake.

As a Data Analyst, you'll play a critical role in this high-impact project, helping ensure a smooth transition to the new system while maintaining the accuracy and integrity of the data that drives their business.

Must have Mainframe and SQL

Role: Data Analyst
Location: Remote (must be based in EST or CST)

Key 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.

Preferred Skills:

Experience working in AWS environments

Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and 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 .

We look forward to working with you.

Beacon Hill. Employing the Future™

---