ONSITE Data Analyst: SQL (heavy) + Advanced Excel / VBA

No C2C or third-party firm candidates. We cannot hire consultants on W2 or provide referral fees. Please do not call or email regarding this.

This role is hybrid onsite in New York City.

Training : 3-4 days / week onsite for 2-3 weeks.

Team Building : 2-3 days / week onsite for approximately 1 month following training.

Long-Term : High-performing candidates may transition to 100% remote.

This is a contract-to-hire position. The contract duration is projected to be 3-9 months.

KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for an ONSITE Data Analyst : SQL (heavy) + Advanced Excel / VBA

Responsibilities :

Design and develop tables, views, stored procedures, indexes, functions, dictionaries, and complex ad-hoc queries for SQL Server databases.

Design and develop user interfaces using AngularJS best practices (exposure to Angular is helpful but not required; no coding expected)

Work with the client and the management team to prioritize business and reporting / data needs.

Translate client-requested features into technical requirements.

Exercise critical thinking to identify opportunities to automate manual processes.

Communicate / coordinate with team to ensure proper implementation of company standards and procedures.

Use Microsoft Excel for data analysis and reporting, including working with prebuilt calculators, VLOOKUPs, and other functions to extract and interpret information

Develop and maintain VBA code for data analysis, reporting, and other automation tasks, potentially including but not limited to Excel

Requirements :

Bachelor's in Computer Science, Mathematics, Engineering, or related field

2+ years of experience with Microsoft SQL Server, including table structuring, creating queries and stored procedures (including joins, filtering vs aggregation, troubleshooting, etc)

Proficiency in advanced Microsoft Excel

Experience developing and maintaining VBA code

1+ years of development experience with object-oriented languages is a big plus (exposure is helpful, but coding is not required; mainly to communicate with dev team - you are working on part of a SaaS platform)

Proficiency in Angular framework is a big plus (helpful exposure only; no coding required)

Good communication skills - both written and oral

Must be able to work independently and in team environments

A live technical test is part of the interview process

Compensation depends on experience but is typically $35-46 / hr with a target salary to convert of $75-95K

ABOUT KORE1

Specializing in professional and technical recruiting, KORE1 is committed to supporting top IT, Engineering, Creative, Scientific, Accounting and Finance professionals in their career paths. We build deep relationships with leading companies, connecting them to exceptional talent every day. With extensive industry expertise and unmatched opportunities, our goal is to provide a unique experience for our contractors and consultants as they prepare for their next role. We are passionate about matching the right people with the right companies.

Kore1 provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Kore1 complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Kore1 expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Kore1's employees to perform their job duties may result in discipline up to and including discharge.