Data Engineer

data modeling, SSIS, SQL, ETL
Full Time
Telecommuting not available Travel not required

Job Description




Design, test and implement automated data ingestion solutions to process disparate data sources. The Data Engineer role requires working ability with Data Analysts and Application Developers to prepare, structure and test large datasets that enable users to visualize operational effectiveness of business systems. The Data Engineer will help the organization manage disparate data sources in preparation for Analysis.





ASMR Role Description:



The Depart of Veterans Affairs (VA) has currently engaged ASM Research to assist in the creation and delivery of executive reporting based on the integration of many data sources. The Delivery Team will be responsible for full life cycle application development of data analytics, data visualization, and presentation with interaction of the solution. Additionally, this team will be responsible for the sustainment operations of the delivered solution within VA production operations environments. This individual should possess professional data management experience in conjunction with supporting development and validation of executive level reports utilizing enterprise level COTS software with custom application development.



Ideal Data Engineer candidates must be able to:



  • Primarily be responsible for designing, implementing and managing Analytical Database environment for reporting

  • Secondarily support function as a SME within structuring and managing data transformation and integration efforts

  • Continuously improve data integration performance and help improve the environment stability and efficient usage

  • Provide necessary project management artifacts as required to team lead including status, project planning, and reporting

  • Identify and communicate issues and risks to the team lead or end user to facilitate timely resolution

  • Support implementation of sound Software Quality Assurance activities to ensure the accuracy and precision of data sets and reports

  • Maximize personal productivity with progressively reduced dependence on supervisor's input by structuring own or others' activities to minimize delays, wasted effort, or rework including conducting work planning/prioritization for own or others' activities

  • Actively contribute to maintaining a collaborative work environment

  • Verify accuracy of items being deployed to production environment





Skills/Technical Expertise [required/preferred]



Required



Technical Expertise

  • Must be able to obtain a VA clearance

  • Minimum of 5 years or more experience with data modeling techniques using data modeling tools (e.g. PowerDesigner, ER/Studio or CA Erwin, Visio)

  • Minimum of 5 years or more experience with designing and developing ETL packages using COTS tools (e.g. SQL Server Integration Services)

  • Minimum of 5 years or more of professional experience with Database Developer and Administration functions, writing complex stored procedures and functions

  • Professional experience working with large unstructured and structured datasets to prepare for analytical reporting

  • Experience in software testing

  • The ability to produce documentation including Data Models, Source/Target Mappings, Data Integration Process flows, and data control or management policies and guidelines

  • Strong analytical, organizational, and interpersonal skills

  • Ability to apply best practices for Quality Assurance





Communication

  • Capable of balancing workload and upward communication i.e. provide timely updates on team status to the team lead

  • Express ideas clearly and effectively both verbally and written; Capable of adjusting communication styles to suit different audiences

  • Client facing skills





Teamwork

  • Able to work as part of a team and support collaboration with external stakeholders to deliver solutions as expected

  • Demonstrable capability when working in a team environment to assist other team members to produce deliverables in compliance with standard procedures





Education

  • Bachelor's degree in computer science, electronics engineering, or other engineering or technical discipline is required - eight years of additional relevant experience may be substituted for education



Preferred



  • Familiar with TFS Source and Version Control

  • Familiar with QA Best Practices





#L1-KL1

Posted By

ASM Research

Contact
Dice Id : 10238000
Position Id : 7231-132
Have a Job? Post it

Similar Positions

Data Engineer
  • GreenZone Solutions, Inc.
  • Washington, DC
Data Engineer
  • WeddingWire
  • Chevy Chase, MD
Penetration Tester
  • Defense Point Security
  • Reston, VA
Database Engineer (ETL / Test Data Management)
  • Precision Systems
  • Chevy Chase, MD
Data Warehouse Developer
  • Confidential Company
  • Quantico, VA
Test Engineer - Data
  • The Ascendant Group, LLC
  • Washington, DC
Test & Evaluation Engineer
  • The Judge Group
  • Dahlgren Center, VA
Data Architect/Data Sharing SME
  • Pro-Sphere Tek, Inc.
  • Washington, DC
Data Analyst III
  • InScope International, Inc.
  • Mclean, VA
Data warehouse tester
  • Collabera
  • Bethesda, MD
Enterprise Data Architect
  • Xoriant Corporation
  • Rockville, MD
Data Caching Engineer
  • CGI
  • Reston, VA
Test Engineer
  • Smartronix, Inc
  • Arlington, VA
Senior Systems Analyst / Modeler
  • Essex Management
  • Rockville, MD