VBA Developer

Company: Latitude Inc.
Location: Baltimore
Posted on: February 25, 2021

Job Description:

Description: PROGRAMMING & REPORTING ANALYST This position is responsible for programming and performing complex analyses and problem resolution for its Division and in support of market segment performance analysis (SBUs). Manages coding of projects and prepares routine and unique presentations for upper management. Provides innovative analytical and reporting support for such purposes as: Monthly and Quarterly Operations Stat and Graph Packs, including: tactical analysis, operational efficiency/quality analysis and productivity analysis; ACA enrollment reporting and analysis; SBU business plan targets and performance analysis; and, corporate enrollment and financial analysis. Takes a proactive approach in advising management of noteworthy SBU and corporate trends. Programs and utilizes corporate and Divisional systems to run queries, reports and extract data. PRINCIPAL ACCOUNTABILITIES: -Develops, tests, and implements efficient and maintainable program logic for existing and new applications. Develops, runs and troubleshoots new and existing macro scripts. Determines if there is a viable macro solution for a project and makes simple and complex macro modifications. Produces clear and concise documentation as required for applications developed. Monitors performance of assigned system applications, resolving program defects, and investigating and resolving reported code defects.
-Specializes in the reporting and data analysis functions for the Division and uses this information to produce various statistics, metrics, and trend analyses related to the Division, Board and the SBUs/market segments. Responsible for the creation and maintenance of monthly, quarterly and annual reports.
-Develops, recommends and implements new procedures and policies to improve the operation of the Division. Operates as an expert on best practices and process improvements related to the Division. Evaluates, maintains and improves the efficiency of the organization, particularly related to streamlining, enhancing and increasing the efficiency of all reporting and analysis.
-Responds to manager and director inquiries, handles special requests, researches complex issues, develops custom reports/tools to assist management. Prepares various ad hoc analyses and reports to support Board and strategic deliverables or operational metrics reporting, frequently in a fast turnaround, high pressure environment. Analyzes and interprets data and makes recommendations to improve reporting processes. REQUIRED ABILITIES/SKILLS: 3-5 years Advanced VBA proficiency and appropriate skills for developing applications in the MS Office Suite using MS Excel and MS PowerPoint.
Demonstrated experience with automating sets of very complex excel 2010 spreadsheets.
Direct experience developing and documenting test cases and thorough test case documentation for regression testing of all enhancements.
VBA scripting experience that involves tailoring complex scripts.
Demonstrated ability to build and manage macro content across multiple spreadsheets, workbooks and presentations.
Ability to demonstrate the integration of macros written into usable excel controls, buttons and menus.
Ability to automate exports of spreadsheet content into other MSOffice tools. This includes Access, Excel and PowerPoint using excel workbooks content.
Specific experience with VBA language functions and modules code that utilizes Looping, IF.THEN.ELSE, CASE, named ranges.
Demonstrates an ability to create VBA code that is maintainable and is not positional sensitive across sheets and workbooks as the contents of workbooks that are to be automated will change often and are very dynamic both in columnar and row functionalities.
Advanced MS Access skills.
Highly developed analytical skills, including the ability to synthesize and create a cohesive picture from a wide variety of information types and sources in a fast-paced high-pressure environment.
Independent and self-starter. Proven ability to handle multiple tasks and projects simultaneously and to produce insightful and reliable quantitative analyses in a high-pressure deadline oriented environment.
Organizational maturity. Ability to build cooperative, productive relationships with internal clients and information sources.
The ability to work independently and with those in various departments and areas not directly reporting to the Division.
Ability to work with and support Senior Management and to disseminate and summarize information into a format that can facilitate high level decision making processes.
Keen attention to detail.
Ability to work independently and in small teams, as well as the willingness to work overtime when necessary and to multi-task in a fast-paced environment.
Good conceptual skills, with high-quality oral and written communications abilities. Preferred: Masters Degree. Healthcare insurance industry experience. In 150 characters or fewer, tell us what makes you unique. Try to be creative and say something that will catch our eye!* 150 Your full LinkedIn profile
will be shared. Learn More

Keywords: Latitude Inc., Baltimore , VBA Developer, IT / Software / Systems , Baltimore, Maryland