Massachusetts Information Technology Jobs

Search for Jobs in Information Technology
MassHire JobQuest Logo

Job Information

Teksouth Corporation Data Analytics Tool Developer in Buzzards Bay, Massachusetts

Teksouth Corporation is currently searching for a Data Analytics Developer to be located at Otis Air National Guard Base, Cape Cod, MA. The Data Analytics Desktop Tools Developer will be responsible for using Microsoft technologies to develop new tools and functionalities, and will be responsible for expanding the functionality of existing solutions to meet the needs of new requirements. This role will work closely with the client during all stages of development.

Major areas of responsibility

  • Automate the process of integration of multiple sources of Air Force/Air National Guard Accounting, Financial, Budget, Personnel, and Logistics data

  • Develop, maintain, and customize desktop analytic tools using approved Microsoft products

  • Create reporting and dashboard solutions to improve the efficiency of daily operations

  • Provide reports to leadership and tenant units to support decision making

Specific Responsibilities

  • Conduct requirement gathering meetings and document identified requirements; design and develop desktop tools implementing approved requirements

  • Identify possible data sources to integrate using current and past legacy systems

  • Convert all data sources to interface/link with Microsoft Access and/or Excel

  • Integrate all data sources into one or multiple tables in a customized analytical format using MS Access

  • Perform daily data loads from source data systems

  • Link MS Access data sources to MS Excel Pivot Tables for multiple users

  • Create ad hoc and canned reports

  • Create advanced charts and dashboards in MS Excel and MS PowerBI

  • Perform quality checks on a routine basis for all tools and deliverables

  • Develop VBA code in MS Office to automate data collection and integration processes

  • Lead/Conduct training classes on tools developed in MS Access, Excel, PowerBI, PowerPoint, and automation techniques

  • Lead specialized analysis and development efforts for analysts and leaders

Job Requirements:

  • Broad knowledge of the DoD financial environment

  • Broad knowledge of DoD Financial Management, Accounting, and Budgeting processes and procedures

  • General knowledge of Air Force/Air National Guard Financial, Accounting, and Budgeting systems, including TRACS, DSAMS, CMCS, GAFS/BQ, CRIS, DTIM

  • Proficiency in Microsoft Access, Excel, SQL, Visual Basic for Applications (VBA), and PowerBI

  • Proficiency in tools/techniques to link data between Microsoft Access, Excel, and PowerBI

  • Proficiency in other Microsoft applications – MS Word, PowerPoint, and SharePoint

  • Demonstrated ability to communicate with clients, from analysts to senior DoD/Air Force officials

  • Demonstrated ability to work collaboratively across a large organization, managing diverse tasks, requirements, and commitments

  • Demonstrated ability to document processes and procedures and provide guidance on execution of developed tools

  • Defense Financial Manager certification (CDFM) is a plus

  • Understanding of CMMI framework

  • Must have an ACTIVE Secret security clearance


  • Degree or equivalent experience:

  • BS/BA degree in computer science, information systems, engineering, business, or other related scientific or technical discipline and a minimum of four (4) years of general experience in DoD Financial Management

  • No degree is required with eight (8) years of DoD Financial Management experience

Physical demands

  • Work sitting or standing at a desk, cubicle, or conference table for extended periods of time (1-3 hours), with the ability to shift positions while working: sit, stand, pace, adjust positioning in any of those without issue

  • Use standard office equipment such as computers, phones, photocopiers, filing cabinets, and facsimile machines.

  • Ability to work in a tempered climate-control office environment

  • May be required to lift and/or move up to 15 pounds

Teksouth values and engages the diversity of its teammates, customers, and business partners. EOE race/color/sex/sexual orientation/gender identity/disability/vet