Vacancy expired!
We are looking for Data Engineer Senior / Sr. ETL developer (min 12 Yrs exp) (LOCAL Candidates preferred) (Webcam interviews) POSITION DESCRIPTION DIRECT CLIENT Position Number of positions: 1 Length: 15 Months + Location: Washington, DC 20019 Immediate interviews either Webcam or In-person interviews Please note that most of the resources are currently working remote. However, depending on the project situation, this position may require 1 -2 days onsite and rest REMOTE. 12+ years of experience needed to serve as the subject matter expert on data architecture for the client's multi-year Data Management Project to modernize the client's data management systems and implement an enterprise data warehouse. We are looking for the services of a Data Engineer staff augmentation consultant to serve as the data engineer for the Data Management Project team. The Data Management Project is a multi-year effort by client to ensure that the client has accurate and reliable data maintained by high quality systems, all client data are readily available and consistently used for well-informed decisions, and appropriate and accurate data are regularly released to the public. The Data Management Project team is responsible for meeting the project goals: (1) establish a data governance program, (2) perform a comprehensive data gap analysis, (3) design a master data architecture, (4) create a data warehouse for all data assets, (5) develop a front-end for program staff to quickly access workforce information and visualize program status, (6) create a public portal with user-friendly scorecards to help residents make more informed decisions about workforce opportunities The Data Management Project Data Engineer serves as an ETL developer and Catalog support specialist for the client's multi-year Data Management Project to modernize the client's data management systems and implement an enterprise data warehouse, with a focus on data asset analysis, supporting data quality measures, and the enhancement of reporting and analysis for program staff. Specific duties for the position include: Specific Duties:
Develop, test, and maintain extraction, transformation, and load (ETL) processes. Develop and maintain an understanding of the data landscape at DOES including the data catalog, master data, data sources, data lakes, data warehouses, data assets, analytic products, and associated tools and software. Support the Data Management Project team to develop and maintain data quality controls. Support the program staff and the Data Management Project team to develop and enhance data analysis and reporting to support program operations. Support business data stewards and Data Management Project team in maintaining accurate data asset meta-data and updating data documentation. Support the data stewards to troubleshoot and resolve data issues. Support business users to obtain requirements for enhancements and/or new analytic assets. Assist in the Development of data asset training and documentation. Participate in the development and implementation of data standards. Participate in the development and maintenance of data security, privacy, policies, procedures, and best practices. Bachelor's Degree from an accredited four-year university in Computer Science, Information Management, or other relevant field is preferred. Candidates must have ALL the "Required" skills in order to be considered for the position. "Desired" or "Highly Desired" skills are a PLUS but may NOT be required. Skill Matrix Experience with Business workflow processes Required / Desired Amount of Experience Experience in developing, testing, maintaining the process of transaction, transformation, and load (ETL) data processes Required 12 Years Experience with command-line scripting (Ex: Linux-Bash, GREP, SED, AWK, Kerberos, LDAP, CRON, Windows PowerShell, Windows Active Directory, Windows Required 12 Years Experience with programing scripting languages (Ex: Python, R/RStudio, JavaScript, JSON/CVS, Perl, Scala, C/C) Required 12 Years Experience leveraging SQL relational databases to manage complex datasets and analytical reporting Required 12 Years Bachelor's Degree from an accredited four-year university in Computer Science, Information Management, or other relevant field is preferred. . Required BS in CS or IS or overall exp of 16 yrs Years Experience with Linux-based Operating Systems and Servers Required 8 Years Experience with Windows-based Operating Systems and Servers Required 8 Years Experience with System Administration of Microsoft SQLServer Required 8 Years Experience with System Administration of PostGresSQL Required 8 Years Experience in the maintenance and monitoring of system & network related activities associated with data security and controls. Required 8 Years Understanding of the Software Development Lifecycle (SDLC) in Agile and Waterfall environments Required 5 Years Proficiency with Agile Testing, Automation Testing, Black-box Testing, Unit Testings, Cross-Browser Testing Required 5 Years Communication skills, both written and spoken, business level English mandatory Required 5 Years Writing System Guides, Manuals, and User Guides for complex systems Required 5 Years Strong communication skills - ability to articulate technical terms and complex data clearly to non-technical audience both verbally and in writing Required 5 Years Outstanding consultative skills, understanding business needs and translating those needs to technical requirements and solutions. Required 5 Years Ability to communicate effectively with all levels of the organization including business owners, leaders, and executives. Desired 5 Years Familiarity with CKAN, DKAN, and/or ArcGIS Desired 2 Years Experience and understanding of BI tool architecture, functions, features (ie. Tableau and/or MicroStrategy) Desired 2 Years Familiarity with CKAN, DKAN, and/or ArcGIS Required 2 Years Experience writing SQL queries for checking expected results and setting up test data; Required 12 Years Vacancy expired!
