What are the responsibilities and job description for the Senior Data Engineer position at BCMC?
Position: Senior Database Engineer
Start Date: ASAP
Clearance: Unclassified, eligible for DoD SECRET
Hours: 8:00 AM – 5:00 PM, Monday – Friday ET (excluding Government Holidays)
Place of Performance: Remote
Years of Experience: 8
Education/Certification Requirements: Bachelor’s degree in Computer Science, Engineering, Management Information Systems, or an equivalent field
Overview
The candidate will support data transformation and migration services to extract, transfer and load historical order, customer, and reference data from legacy system and other sources. Responsibilities include analyzing data alignment rules and exceptions, executing SQL/JDBC queries or transform map loads in ServiceNow to import data.
Specific Duties
Perform data transformation to align with customer requirements, including but not limited to:
· Editing and/or optimizing government provided queries to meet size limits or selection specific formatting requirements.
· Configuring, testing and executing SQL/JDBC queries from ServiceNow to import data into ServiceNow development, test, production or sandbox environments.
· Verifying imports execute properly.
· Analyzing data import results against target system specifications to validate mapping results and identify gaps or transformation issues.
· Developing transform maps to load data to target tables.
· Executing XML export/Import transformations.
· Maintaining reports and controls to provide evidence of successful transformations, loads and exceptions.
· Developing queries to meet import requirements.
· Meet with project team members to discuss status, approach, technical challenges or
other timely topics related to data migration or overall project objectives.
Specific High Experience ServiceNow/other skills required
· Configuring interfaces, including configuring security settings.
· Assessing table contents, structure, and related data management.
· Creating Transform Maps.
· Creating and managing Excel data files for data import.
· SQL coding and configuring JDBC connection.
Our Company Overview:
Business Computers Management Consulting Group, LLC (BCMC) is a small business specializing in Information Technology (IT), Cybersecurity, Information Assurance (IA), SOA, Big Data Management, Program Management, and more for Federal, State, and Local agencies. We possess highly skilled engineers, providing innovative solutions backed by strong past performances. We are ISO 9001:2015, ISO 27001:2013, 20000:2018, and CMMI L3 certified and registered promising highest quality and services to all of our clients.
Benefits
Extremely competitive salary
95% employer paid for employee medical, dental, & vision coverages
100% employer paid for employee life, STD & LTD disability coverages
401k with company match and profit sharing
Flexible Spending Account (FSA) for dependent & health care
11 standard holidays & 3 weeks of annual leave