The primary role of the Financial Data Analyst will be to be able to create, debug, modify and fine tune complex SQL statements. The candidate will also assist in the data migration from the SAS environment into AWS cloud platform by rewriting the SAS codes in a SQL language. The incumbent will also assist in documenting the SAS/AWS migration process.

　　Work with the financial close team in the reconciliation of data between SAS, Workday and AWS environments.

　　Assist in training the financial close team on how to use SQL language to build adjustments required for the financial close.

　　Assist in the maintenance and improvement of monthly financial close process in AWS.

　　Additional duties as assigned.

　　Minimum Qualifications:

　　Bachelor's degree from an accredited institution.

　　Work experience with data analytics.

　　Experience in creating, maintaining and running complex queries using SQL.

　　Work experience with large volumes of data in Excel utilizing advanced functions such as VLookups, Pivot Tables, formulas, model building.

　　Preferred Qualifications:

　　Bachelor's degree in Finance, Math, Statistics or Computer Science from an accredited institution.

　　Extract Transformation and Load/ETL experience.

　　Experience with SAS to AWS migrations.

　　Analytical experience in a healthcare environment (such as a managed care organization, commercial health insurance plan, hospital system, etc.)

　　Ability to effectively communicate with all levels of the organization, including technical staff, internal non-technical staff, and business stakeholders.

　　Ability to effectively and efficiently adapt in a dynamic environment.

　　Ability to challenge the status quo and drive lean implementation.

　　Ability to quickly develop an understanding of systems and technology.

　　WE ARE AN EQUAL OPPORTUNITY EMPLOYER. Applicants and employees are considered for positions and are evaluated without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, age, genetic information, military or veteran status, marital status, mental or physical disability or any other protected Federal, State/Province or Local status unrelated to the performance of the work involved.

　　If you have a disability under the Americans with Disability Act or a similar law and want a reasonable accommodation to assist with your job search or application for employment, please contact us by sending an email to careers@Healthfirst.org or calling 212-519-1798 . In your email please include a description of the accommodation you are requesting and a description of the position for which you are applying. Only reasonable accommodation requests related to applying for a position within Healthfirst Management Services will be reviewed at the e-mail address and phone number supplied. Thank you for considering a career with Healthfirst Management Services.

　　EEO Law Poster and Supplement (http://www.dol.gov/agencies/ofccp/posters)

　　All hiring and recruitment at Healthfirst is transacted with a valid “@healthfirst.org” email address only or from a recruitment firm representing our Company. Any recruitment firm representing Healthfirst will readily provide you with the name and contact information of the recruiting professional representing the opportunity you are inquiring about. If you receive a communication from a sender whose domain is not @healthfirst.org, or not one of our recruitment partners, please be aware that those communications are not coming from or authorized by Healthfirst. Healthfirst will never ask you for money during the recruitment or onboarding process.

　　Hiring Range*:

　　Greater New York City Area (NY, NJ, CT residents): $67,200 - $97,155

　　All Other Locations (within approved locations): $59,800 - $88,910

　　As a candidate for this position, your salary and related elements of compensation will be contingent upon your work experience, education, licenses and certifications, and any other factors Healthfirst deems pertinent to the hiring decision.

　　In addition to your salary, Healthfirst offers employees a full range of benefits such as, medical, dental and vision coverage, incentive and recognition programs, life insurance, and 401k contributions (all benefits are subject to eligibility requirements). Healthfirst believes in providing a competitive compensation and benefits package wherever its employees work and live.

　　*The hiring range is defined as the lowest and highest salaries that Healthfirst in “good faith” would pay to a new hire, or for a job promotion, or transfer into this role.