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
Click
here to apply!
|
Didn't find what you're looking for? Search again!
Other IT / Software / Systems JobsTechnical Lead (API/.NET) Description: If you are a Technical Lead with 3-5 years of API/ .Net, and SOAP orREST web services experience, please read on We are a constantly expanding wholesaler and supplier of electric and tech products located (more...) Company: Optello Location: Harrisburg Posted on: 03/8/2021 Entry Level Software Developer Description: Revature is the fastest growing employer of emerging technology talent. We will hire over 300 Entry Level Software Developers across the country in the next 4 weeks.One day someone is going to ask you (more...) Company: Revature Location: Bowie Posted on: 03/8/2021 Computed Tomography/Radiologic Technical Specialist Description: Job Description br br Want to join World-Class Healthcare for Northern Virginia and the D.C. Metro area br br Click Here To Learn About INOVA br br Inova is Northern Virginia's leading nonprofit (more...) Company: Inova Health System Location: Leesburg Posted on: 03/8/2021 Software Engineer Description: Mosaic ATM, located in the Northern Virginia / Washington, DC Metro area, is seeking talented full-time Software Engineers/Developers to add to our great team.--We're looking for people who are passionate (more...) Company: Mosaic ATM Location: Leesburg Posted on: 03/8/2021 Entry Level Java Developer Description: Revature is the fastest growing employer of emerging technology talent. We will hire over 300 new Entry Level Java-- Developers in the next 4 weeks.One day someone is going to ask you where you got your (more...) Company: Revature Location: Bowie Posted on: 03/8/2021 Staff Technical Analysts - TS/SCI w/poly required Description: Category: Information Technology Location: Chantilly, Virginia US Citizenship Required for this Position: Yes Clearance Type: Polygraph Telecommute: No Teleworking not available for this position Shift: (more...) Company: Northrop Grumman Location: Chantilly Posted on: 03/8/2021 Technical Recruiter Description: Job Location: US-VA-DullesID--2021-2015 Job Type--Immediate Hire Category--Human ResourcesOverviewSkyePoint Decisions is seeking a dynamic, outgoing, creative, and motivated Technical Recruiter to identify (more...) Company: SkyePoint Decisions, Inc. Location: Sterling Posted on: 03/8/2021 Software Engineer (JD 193) Description: Description: br Job Summary: Develop PC/Windows-based software for automated laboratory instrumentation, including User Interface, System Control, and Data Processing collection, reduction, analysis (more...) Company: Dynex Technologies Location: Chantilly Posted on: 03/8/2021 Staff Technical Analysts - TS/SCI w/poly required Description: Category: Information TechnologyLocation: Chantilly, VirginiaUS Citizenship Required for this Position: YesClearance Type: PolygraphTelecommute: No -Teleworking not available for this positionShift: 1st (more...) Company: Northrop Grumman Location: Chantilly Posted on: 03/8/2021 Full Stack Developer (Java) Description: Job Description This position is NOT open for 1099, C2C, H1-B or OPT We are seeking an experienced Full Stack Developer to support Agile Application Development technologies and capabilities in (more...) Company: Primastep, LLC Location: Sterling Posted on: 03/8/2021 |