ApTask
About Client:
The client provides information technology (IT) services, including business outsourcing, infrastructure technology, and application services. The application service offered by the company includes application development, maintenance, and support. The markets served by the company are financial services and insurance, healthcare, manufacturing, government, transportation, communications, and consumer and retail industries.
Rate Range: $35-$37/Hr
Job Description: We're seeking a highly skilled Excel professional to design, develop, and optimize complex spreadsheet tools and dashboards. You'll automate data processes, perform in-depth analysis, and collaborate with teams to drive data-driven decisions. Key Responsibilities:
Design, build, and maintain
advanced Excel models , including complex formulas (e.g., XLOOKUP, INDEX/MATCH, array formulas), pivot tables, and dynamic dashboards Automate repetitive tasks via macros/VBA scripts, including custom functions (UDFs) and Lambda usage Leverage Power Query / Power Pivot to extract, transform, and model external data Utilize tools like Solver, Goal Seek, and scenario tables for advanced what-if and optimization analysis Implement data cleaning & validation: using text-to-columns, filters, conditional formatting, data validation rules Develop and maintain interactive dashboards with charts, sparklines, slicers, and visual cues for executive reporting Ensure model integrity, performance optimization, documentation, version control, and sharing across teams Troubleshoot and resolve formula errors, file corruption, and integration issues across Office apps Provide training and support to business users; promote Excel best practices and empower teams Required Qualifications:
Bachelor's degree in Business, Finance, IT, Engineering or related field 3+ years of hands-on experience building advanced Excel solutions Expert proficiency in formulas (XLOOKUP, INDEX/MATCH, array functions), pivot tables, charts, conditional formatting VBA & macros development experience, including debugging and custom functions Practical experience with Power Query / Power Pivot / Data Model Knowledge of Solver, Goal Seek, What-if analysis tools Exceptional attention to detail and analytical thinking Strong communication skills to explain complex data insights clearly Ability to manage multiple projects, meet deadlines, and work independently or in teams Preferred (Nice-to-Have):
Experience with Power BI, SQL, Python or integrating Excel with databases Knowledge of spreadsheet architecture principles, named ranges, modular design, workbook best practices Familiarity with
version control , documentation of assumptions, and model traceability Financial or engineering modeling experience in Excel Qualities & Mindset:
A systematic, user-oriented Excel engineer who builds robust, maintainable tools Proven ability to automate end-to-end processes, saving significant time and errors Strong documentation discipline and a commitment to version control and traceability Ability to drive business impact through automation and insightful reporting
About ApTask: ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com .
Applicant Consent: By submitting your application, you agree to ApTask's (www.aptask.com) Terms of Use and Privacy Policy , and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-355-8000 or help@aptask.com. Message frequency may vary. Msg & data rates may apply.
Rate Range: $35-$37/Hr
Job Description: We're seeking a highly skilled Excel professional to design, develop, and optimize complex spreadsheet tools and dashboards. You'll automate data processes, perform in-depth analysis, and collaborate with teams to drive data-driven decisions. Key Responsibilities:
Design, build, and maintain
advanced Excel models , including complex formulas (e.g., XLOOKUP, INDEX/MATCH, array formulas), pivot tables, and dynamic dashboards Automate repetitive tasks via macros/VBA scripts, including custom functions (UDFs) and Lambda usage Leverage Power Query / Power Pivot to extract, transform, and model external data Utilize tools like Solver, Goal Seek, and scenario tables for advanced what-if and optimization analysis Implement data cleaning & validation: using text-to-columns, filters, conditional formatting, data validation rules Develop and maintain interactive dashboards with charts, sparklines, slicers, and visual cues for executive reporting Ensure model integrity, performance optimization, documentation, version control, and sharing across teams Troubleshoot and resolve formula errors, file corruption, and integration issues across Office apps Provide training and support to business users; promote Excel best practices and empower teams Required Qualifications:
Bachelor's degree in Business, Finance, IT, Engineering or related field 3+ years of hands-on experience building advanced Excel solutions Expert proficiency in formulas (XLOOKUP, INDEX/MATCH, array functions), pivot tables, charts, conditional formatting VBA & macros development experience, including debugging and custom functions Practical experience with Power Query / Power Pivot / Data Model Knowledge of Solver, Goal Seek, What-if analysis tools Exceptional attention to detail and analytical thinking Strong communication skills to explain complex data insights clearly Ability to manage multiple projects, meet deadlines, and work independently or in teams Preferred (Nice-to-Have):
Experience with Power BI, SQL, Python or integrating Excel with databases Knowledge of spreadsheet architecture principles, named ranges, modular design, workbook best practices Familiarity with
version control , documentation of assumptions, and model traceability Financial or engineering modeling experience in Excel Qualities & Mindset:
A systematic, user-oriented Excel engineer who builds robust, maintainable tools Proven ability to automate end-to-end processes, saving significant time and errors Strong documentation discipline and a commitment to version control and traceability Ability to drive business impact through automation and insightful reporting
About ApTask: ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com .
Applicant Consent: By submitting your application, you agree to ApTask's (www.aptask.com) Terms of Use and Privacy Policy , and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-355-8000 or help@aptask.com. Message frequency may vary. Msg & data rates may apply.