DCS Corp
Data Engineer
At a glance
Location: US-CA-Ridgecrest Map
Posted: 01/11/2022
Closing: 02/10/2022
Degree: Not Specified
Type: Full-Time
Experience: Not Specified
DCS Corp
Job description

COVID-19 continues to significantly impact our employees, families and communities. With the health and safety of employee as our top priority, DCS is taking action to address the increased risk and uncertainty COVID-19 variants pose in the workplace while ensuring we meet our commitments to national security.

To uphold safety for all employees, we will continue to request vaccination status for all DCS employees, including new hires. All current and newly hired employees who are unvaccinated will be required to adhere to safety protocols applicable to their worksite.

DCS Corp. is looking for an experienced mid-level Data Engineer to join the F/A-18 & EA-18G Integrated Product Team (IPT).

Essential Job Functions:

Collaborate with software developers, system operators, administrators and other IT staff members to support the IPT’s software development, reporting and IT infrastructure.

Develop advanced SQL scripts for data extraction from SQL Server databases. 

Create data structuring/mapping, the process of defining data types and the connections between them. 

Develop complex ETL pipelines to support organization. 

Experience with Azure DevOps Pipelines. 

Design & build both logical and physical data models for both Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) solutions. 

Manage metadata structures needed for building reusable Extract, Transform & Load (ETL) components. 

Design, code, test, correct and document programs and scripts using agreed standards and tools to achieve a well-engineered result. 

Ability to work on multiple areas like ETL, Data modeling & design, writing complex SQL queries etc. 

Data Warehousing and REST API's experience.

Maintain responsibility for completion and accuracy of work products. 

Create and manage multiple databases and assist in capacity planning and requirement gathering. 

Monitor, maintain database systems and troubleshoot problems that may arise. 

Maintain data integrity and security (manage roles and permissions of database users). 

Support software developers with database operations including the development of complex SQL and the creation of stored procedures. 

Manage work in production, QA and development database environments. 

Create detailed documentation including diagrams of database infrastructure. 

Learn relevant business processes and understand the data flow, criticality and dependencies. 

Coordinate and communicate with all the stakeholders (internal teams and clients) effectively. 

Set up and maintain database infrastructure for the organization’s Business Intelligence (BI) needs. 

Required Skills:

Due to the sensitivity of customer related requirements, U.S. Citizenship is required. 

Bachelor degree in an IT field with 2 years of experience, or equivalent and relevant certifications. 

Obtain and maintain a Security Clearance for the duration of employment. 

Experience with Database Administration, specifically working with Microsoft SQL Server (MS SQL Server). 

Experience with Microsoft infrastructures, MS SQL Server (2014/2017/2019), SSIS, Agile software development (Scrum/SAFe). 

Ability to build and maintain the MS SQL Server database infrastructure. 

Able to assist developers to configure database instances, code deployment, and user access management. 

Practical experience in managing internal and external Microsoft SQL Server database security. 

Up-to-date on the latest industry trends; able to articulate trends and potential clearly and confidently. 

Good interpersonal skills and communication with all levels of management. 

Able to multitask, prioritize, and manage time efficiently. 

Desired Skills:

Knowledge of and experience with Federal security regulations, standards, DoD STIGS and processes including FISMA, FIPS, NIST, and FedRAMP. 

Experience with SSRS highly preferred. 

Experience with R, Python, Tableau, Qlik, PowerBI highly preferred.

Data Engineer