Company: Latitude Inc.
Posted on: February 25, 2021
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
Demonstrated experience with automating sets of very complex excel
Direct experience developing and documenting test cases and
thorough test case documentation for regression testing of all
VBA scripting experience that involves tailoring complex
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
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
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
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
Didn't find what you're looking for? Search again!