ApTask
Data Engineer
ApTask, Jersey City, New Jersey, United States, 07390
About Client:The client is a global technology, consulting, and digital solutions company with problem-solving abilities and an emphasis on developing ingenious solutions that allow its clients to remain competitive, profitable, and secure in an evolving business environment.Client anticipates and leads change to remain in the leader's quadrant for profitable growth, driven by partnerships with globally leading hyperscales like AWS, Google Cloud, and Microsoft. It has built strong capabilities in new as well as existing technologies such as cloud, data, and digital, pioneering new frontiers.
Salary Range: $125K-$130K/Annum
Job Description:The purpose of this position is to support FP&A reporting platforms and associated technical.Responsible for all techno functional support aspects of current FP&A applications (with ERP/GL experience) while we migrate to a new SAAS vendor platform.Must be a strategic thinker and demonstrate leadership elements and considerable independent judgment and initiative in carrying out project objectives.Develop strategies for effective data analysis and reporting by working closely with Corporate Finance FP&A Controllers and managing a team of data engineers to ensure data accuracy and leading to optimal processes and procedures for analytics employees to follow.Should have the aptitude to learn newly introduced Financial ERP Cloud applications and ancillary Finance platforms.Must have Dimensional Reporting Knowledge, with the ability to develop complex SQL scripts and stored procedures with Hyperion, Essbase, Smart View, web forms and reports.Experience with financial statements, including income statements, balance sheet, P&L, and cash flow is a must.Qualifications:
Minimum 10 years Hands on experience with implementation, development, and support experience with various Reporting Platforms, preferably gained within one or more financial institution.Deep Financial management reporting, forecasting and budgeting experience in the Financial Services arena.Preferred knowledge in both Oracle Database Schema and Snow-Flake Schema data modeling techniquesCreate and maintain data forms, calculation scripts, MAXL automation, schedule jobs using batch scripts and business rulesDevelop and maintain Block Storage Outline / Aggregate Storage Outline (BSO/ASO) cubesKnowledge of Reporting Tools Hyperion BI+ (Web Analysis) Hyperion Reports 7.x/9.x, Hyperion Analyzer 7.x, Hyperion Excel Add-in, Smart View.SQL Loader functionality to interact with Essbase Cubes to and from with Oracle DatabaseExcellent communication and presentation skills, both verbal and written
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 .
Salary Range: $125K-$130K/Annum
Job Description:The purpose of this position is to support FP&A reporting platforms and associated technical.Responsible for all techno functional support aspects of current FP&A applications (with ERP/GL experience) while we migrate to a new SAAS vendor platform.Must be a strategic thinker and demonstrate leadership elements and considerable independent judgment and initiative in carrying out project objectives.Develop strategies for effective data analysis and reporting by working closely with Corporate Finance FP&A Controllers and managing a team of data engineers to ensure data accuracy and leading to optimal processes and procedures for analytics employees to follow.Should have the aptitude to learn newly introduced Financial ERP Cloud applications and ancillary Finance platforms.Must have Dimensional Reporting Knowledge, with the ability to develop complex SQL scripts and stored procedures with Hyperion, Essbase, Smart View, web forms and reports.Experience with financial statements, including income statements, balance sheet, P&L, and cash flow is a must.Qualifications:
Minimum 10 years Hands on experience with implementation, development, and support experience with various Reporting Platforms, preferably gained within one or more financial institution.Deep Financial management reporting, forecasting and budgeting experience in the Financial Services arena.Preferred knowledge in both Oracle Database Schema and Snow-Flake Schema data modeling techniquesCreate and maintain data forms, calculation scripts, MAXL automation, schedule jobs using batch scripts and business rulesDevelop and maintain Block Storage Outline / Aggregate Storage Outline (BSO/ASO) cubesKnowledge of Reporting Tools Hyperion BI+ (Web Analysis) Hyperion Reports 7.x/9.x, Hyperion Analyzer 7.x, Hyperion Excel Add-in, Smart View.SQL Loader functionality to interact with Essbase Cubes to and from with Oracle DatabaseExcellent communication and presentation skills, both verbal and written
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 .