DATA SPECIALIST/ANALYST (MS Access, VBA, XML, XSLT)

Audit, Best practices, Consulting, Energy, Energy management, Documentation, Database, Data integrity, Data QA, File formats, Information systems, Kofax, Microsoft Access, Microsoft Excel, QA, Reporting, SOLID, Scripting, System imaging, Transformation, VBA, XML, XSLT, Critical thinking, Problem solving, MS Excel, VBScript, Graphics design, BASH, PERL
Contract W2, Contract Independent
Depends on Experience
Travel not required

Job Description

JOB TITLE: Data Specialist/Analyst
LOCATION: Baltimore, MD
CONTRACT TERM: Long-Term
WORK SCHEDULE: 8:00am-5:00pm, except State Holidays. A flexible schedule is required for potential support outside of normal work hours and workdays.
DK Consulting Overview: Founded in May 2003, DK Consulting, LLC, a woman-owned small business, was formed to provide management and technology solutions based on industry best practices. DK Consulting, LLC works with multiple State, Federal, and Commercial customers, and our services range from providing customers with that one critical resource to assuming responsibility for an entire IT project. We maintain exceptional past performance and provide a personal touch to account management that is rarely seen in the industry today. Some of our awards include:

DK Consulting s CEO Named One of the Top Female CEOs in Baltimore by SmartCEO Magazine - 2015!
DK Consulting Recognized in Inc. Magazine s Top 5000 List 2012, 2016, 2017, 2018!
DK Consulting Awarded Top 100 MBE s in 2017 by CRMSDC!

Overview:  The Data Specialist/Analyst supports our client’s Energy Management Information Systems team. Primary responsibilities include preparing XML data for import by creating/maintaining XSLT documents, data quality assurance tasks, writing custom VBA modules to streamline data import processes, authoring and maintaining Access databases used to track data receipt and processing the development and production of reports and graphics.  This is a “hands-on” position requiring solid technical skills, as well as interpersonal and communication skills.
 

Requirements:

  • Advanced knowledge of Microsoft Excel and working knowledge of other Office products including Microsoft Access.
  • Experience using VBA/VBScript to create validation rules and other program logic.
  • Ability to maintain/modify custom scripts for XML data transformations (XSLT)
  • Experience with document capture and imaging software (Kofax 10.1/KTM 6.1)
  • Prior experience or knowledge of Microsoft Access.
  • Strong problem solving, analytical, and critical thinking skills
  • Detail oriented and results driven
  • Ability to grasp new concepts quickly
  • Strong communication skills and ability to multi-task and maintain/meet deadlines
  • Experience in energy/utility industry desired but not required
  • EnergyCap experience is desired but not required.

Responsibilities:

  • Excel VBA – Create functions/modules to prepare raw data for import and automate QA tasks.
  • XSLT/XML – Author and maintain documents to extract data from source files into comma-delimited file formats.
  • Kofax Capture – Create and maintain batch classes and program Kofax Transformation Modules Projects.
  • Access Database – Author, maintain, and track the lifecycle for data artifacts (receipt, loading, QA) and provides meaningful reports to management.
  • Analyze and verify large datasets (delimited data, high volume pdf processing, large spreadsheets) and document issues/provide suggestions to management.
  • Review/create audit reports and resolves errors to ensure data integrity
  • Download/import data files; manipulate and analyze large data sets using scripting and query tools
  • Responsible for preparing, loading, auditing, and correcting data imports
  • Create, implement, and maintain data file structures

 

Posted By

Suite 240 Columbia, MD, 21046

Contact
Dice Id : 10176030
Position Id : 6447082
Originally Posted : 3 months ago
Have a Job? Post it

Similar Positions

Senior Software Engineer with asset management domain knowledge
  • Merritt Technical Associates
  • Baltimore, MD
Xamarin Developer
  • Paramount Software Solutions, Inc
  • Baltimore, MD
Charles River Developer
  • INFOMATICS
  • Maryland City, MD
Scientific Programmer
  • Global Science & Technology, Inc
  • College Park, MD
.NET DEVELOPER
  • EPTech Consulting Group
  • Baltimore, MD
Database Engineer
  • Booz Allen Hamilton
  • Annapolis Junction, MD
C#.Net Dev with Heavy SQL
  • Lenmar Consulting
  • Lutherville-timonium, MD
Database Engineer 3
  • Peraton
  • Fort Meade, MD
C#.Net/Developer - Backend
  • Hired by Matrix, Inc.
  • Lutherville, MD
Senior Node Software Developer
  • iPlanner
  • Baltimore, Maryland
Software Engineer Intermediate
  • Apex Systems
  • Aberdeen, MD
Senior Business Intelligence/Data Warehouse Developer
  • TechTu Business Solutions Inc
  • Annapolis, MD