Principal Business Analyst

Company: Diversified Systems, Inc.
Location: Trenton
Posted on: March 16, 2023

Job Description:

Job DescriptionDeveloper Location: On-Site - Trenton, NJDiversified Systems is searching for a Developer who specialize in Access and Excel VBA and SQL. Responsibilities: Analyzing the needs of internal department and assist staff and leadership with development of Microsoft (MS) Access Databases, including but not limited to, tables, queries, forms and reports. Expert working with MS Access (all versions) and MS Excel (all versions). This includes dealing with advanced MS Excel capabilities - formulas, tables, and graphs as well as manipulating, and analyzing data using Visual Basic for Applications (VBA). Work with State business units to design/develop/debug new and existing MS Access database desktop applications and optimization of process with MS Suite of software. Develop MS Access/Excel VBA programs to perform tasks automatically. Analyze complex data to develop automated reporting. Create/edit new and/or existing macros to work with a large amount of data. Reviewing code to ensure best practices are in place and ability to following business unit naming conventions. Developing test plans and documentation of code to support modifications and additions. Use of other applications such as MS Project, MS Visio, Adobe Acrobat, and MS OneNote will be necessary. Follow existing and establish new improved cross-applications workflows. Must be able to write clear and constructive comments, during development, upgrades, maintenance and troubleshooting. Perform other duties and projects as necessary and assigned, such as data entry, report production, analysis of data, power point presentations, and executive summaries with narratives and appropriate formatting. Effectively communicate, to managers and team members, technical and business issues or challenges. Confidence to provide recommendations and design changes to improve processes as well as acceptance of the ideas of others. Must be able to work with changing priorities and communicate well with leadership, coworkers and customers. Must be able to work independently without direct supervision and able to assume responsibilities to maintain, troubleshoot, debug and support a set of existing MS Access or MS Excel applications. Strong written and verbal communication skills. Positive can do attitude and great team player mentality. About Diversified Systems Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.Diversity, Equity and InclusionDSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.

Keywords: Diversified Systems, Inc., Trenton , Principal Business Analyst, Professions , Trenton, New Jersey