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