Excel Analyst at The Computer Merchant, LTD.
Hicksville, NY 11801
About the Job
JOB TITLE: Excel Analyst
JOB LOCATION: Hicksville, NY (Hybrid)
WAGE RANGE*: $45-49/hr.
JOB NUMBER: NGGJP00015444
Required experience
Junior to mid level position to assist with the support/development of a homegrown Excel-based Investment Financial Management tool; With an opportunity to explore alternate technologies down the road
Required Skills:
Office 365:
Excel
SharePoint
MS Power Query
MS Power Apps
o Agile ways of working and associated tools (i.e. Jira)
o Good communication skills are a must
Nice to have Skills:
o Power BI
o Snowflake
o SQL
o Python
o Visio
o Experience leading training
o Some basic accounting experience
Need to be able to work in a cross-functional team
Must be comfortable providing support to a large user community that will be comprised of a mix of employees & contractors at varying levels of the IT&D organization
Job Description:
The IT Business Analyst is part of the Strategy & Planning team and reports to the Program & Project Management Manager. They will assist with the development & maintenance of the Financial Workbook, which is a homegrown tool used by the US CIO teams to manage their investments' financials. Also responsible for assisting in the creation, delivery and optimization of Financial Management processes and functions to ensure IT operates with maximum financial efficiency and transparency to generate the greatest value for the Business.
Position Responsibilities (including but not limited to):
The IT Business Analyst is accountable to perform a wide range of functions which will include, but not be limited to, the following:
• Under guidance of the Program & Project Management Manager, responsible for the development, support & training of the Financial Workbook (Excel-based proprietary tool)
• Liaise with the IT Finance, Regulatory, CIO Delivery Towers and Global Solutions Engineering teams, to gather requirements for new features to be incorporated into the Financial Workbook
• Coordinate the release of new features to production
• Document new features and update existing guidance and training material
• Utilize historical financial data to assist with the development of project budget, resource and forecasting plans
• Assist in ad-hoc reporting to support requests
Equal Opportunity Employer Veterans/Disabled
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
JOB LOCATION: Hicksville, NY (Hybrid)
WAGE RANGE*: $45-49/hr.
JOB NUMBER: NGGJP00015444
Required experience
Junior to mid level position to assist with the support/development of a homegrown Excel-based Investment Financial Management tool; With an opportunity to explore alternate technologies down the road
Required Skills:
Office 365:
Excel
SharePoint
MS Power Query
MS Power Apps
o Agile ways of working and associated tools (i.e. Jira)
o Good communication skills are a must
Nice to have Skills:
o Power BI
o Snowflake
o SQL
o Python
o Visio
o Experience leading training
o Some basic accounting experience
Need to be able to work in a cross-functional team
Must be comfortable providing support to a large user community that will be comprised of a mix of employees & contractors at varying levels of the IT&D organization
Job Description:
The IT Business Analyst is part of the Strategy & Planning team and reports to the Program & Project Management Manager. They will assist with the development & maintenance of the Financial Workbook, which is a homegrown tool used by the US CIO teams to manage their investments' financials. Also responsible for assisting in the creation, delivery and optimization of Financial Management processes and functions to ensure IT operates with maximum financial efficiency and transparency to generate the greatest value for the Business.
Position Responsibilities (including but not limited to):
The IT Business Analyst is accountable to perform a wide range of functions which will include, but not be limited to, the following:
• Under guidance of the Program & Project Management Manager, responsible for the development, support & training of the Financial Workbook (Excel-based proprietary tool)
• Liaise with the IT Finance, Regulatory, CIO Delivery Towers and Global Solutions Engineering teams, to gather requirements for new features to be incorporated into the Financial Workbook
• Coordinate the release of new features to production
• Document new features and update existing guidance and training material
• Utilize historical financial data to assist with the development of project budget, resource and forecasting plans
• Assist in ad-hoc reporting to support requests
Equal Opportunity Employer Veterans/Disabled
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
Salary
45 - 49 /hour