Search for More Jobs
Forward job to a friend
Apply without Registering
Apply by creating/using an account
Please enter your registered email address, and we'll email you a link to reset your password right away.
• Req Description: Responsibilities of a Business Technical Solutions/End User Computing Analyst are related to cross functional support of the various units within the Corporate Compliance Group. In this role, the analyst would rely on their knowledge of general programming, data architecture, and data management to create innovative and robust technical solutions. The analyst would use their knowledge of various programming languages (C#, ASP, etc...) to develop custom user interfaces that will be deployed globally. The analyst would use their knowledge of end user computing (VBA and general Microsoft standard automation) to create automated solutions for various ad-hoc requests including the development of standard reporting for our global Enterprise Wide Risk Assessments, Regulatory Change Management system, as well as Policies Reporting Systems. Our automation requirements may involve synchronizing feeds from various sources such as Oracle, SQL Server, and Microsoft SharePoint. Finally, the analyst would use their general knowledge of web-technology (HTML, jQuery, AngularJS) and advanced knowledge of SharePoint to help drive custom web-interface solutions within Microsoft SharePoint 2010/2013.
• Req Qualifications:
This role requires a bachelor's degree and 5+years of relevant experience.
Candidate should have knowledge in OO programming (understanding of data abstraction [classes, objects, member functions , etc...]) .
Candidate should understand "under the hood " of Windows OS and understand how to manipulate windows through batches, VBS, API calls , etc...
• Microsoft Office.
VBA for MS Office; Should be able to program and run code for automation of ALL MS Office Products (specifics for Access and Excel listed below.)
Candidate should understand Late Binding vs. Early Binding development and be able to adjust his/her code accordingly.
• Web Development
knowledge of Microsoft SharePoint services 2007 or 2010; Understanding of lists, document libraries, user administration, etc...
• Databases and/or Microsoft Access
ANSI SQL / Access SQL / (nested queries, inline queries, pass-through queries, etc...)
Knowledge in RDBMS (one-to-one, one-to-many, many-to-many, 3NF, BCNF, etc...)
Understanding of ODBC /OLE etc... and other Microsoft connectivity standards.
-Understanding of Access design elements - Forms, Reports, Macros, etc..
-Understanding of DAO library.
-Understanding of ADO library.
• Microsoft Excel
Applicant should have very advanced knowledge of excel.
Advanced pivot table and pivot chart construction.
Very Advanced skills in creating Excel forms
Advanced Microsoft Excel communication strategies with databases using Microsoft Query.
Advanced Worksheet techniques for constructing business forms using ActiveX controls and form controls.
Dashboard and Advanced Formula construction.
Advanced skills for linking separate workbooks and worksheets.
Advanced skills for linking with other applications (OLE).
Advanced skills for importing text files.
Advanced skills for sharing workbooks.
Advanced skills for constructing time formulas on the worksheet.
Advanced use of Goal Seek and Solver, etc...
Apply by creating/using an account
Axelon Services, Corp is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, gender identity, national origin, disability, or protected veteran status.