We are looking for Data Engineer (ETL) and System Admin(min 12 yrs+ exp) (REMOTE) (Webcam interviews)
POSITION DESCRIPTION
DIRECT CLIENT Position
Number of positions: 1
Length: 10 Months +
Location: Washington, DC 20019
Immediate interviews Webcam interviews
Please note that this position is REMOTE. Candidate must go to Washington DC to pick up equipment and complete onboarding process on 1st day and then work remotely. Client will NOT ship equipment.
11-15 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.
client requires 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 DOES to ensure that the agency has accurate and reliable data maintained by high quality systems, all agency 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, and (7) foster relations with other DC agencies and improve inter-agency data integration.
Specific Duties:
The Data Management Project Data Engineer serves as an ETL developer and system administrator for the agency'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:
Develop, test, and maintain extraction, transformation, and load (ETL) processes.
Support the System Administration of associated tools and software of data and analytics landscape including the data catalog, master data, data sources, data lakes, data warehouses, data assets, and analytic products.
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 a client's data standard.
Participate in the development and maintenance of data security, privacy, policies, procedures, and best practices.
Required Skills And Experience
Programming: proficiency in SQL, Python, R, JavaScript, JSON, and Excel Formulas & Charts.
Familiarity with CKAN, DKAN, and/or ArcGIS is an added advantage.
Operating Systems: Windows and Linux.
Modeling Tools: proficiency in the use and administration of Erwin Modeling Suite (Data Modeler Navigator, Data Modeler WGE, Mart Server, Web Portal), or similar tools for developing and maintaining data models.
Testing: proficiency with Agile Testing, Automation Testing, Black-box Testing, Unit Testings, Cross-Browser Testing.
Nice to Have: Experience and understanding of BI tool architecture, functions, features (ie. Tableau and/or MicroStrategy).
Nice to Have: Outstanding consultative skills, understanding business needs and translating those needs to technical requirements and solutions.
Nice to Have: Ability to communicate effectively with all levels of the organization including business owners, leaders, and executives.
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.
Skill Matrix
Experience with Business workflow processes
Required / Desired
Amount
of Experience
Experience with System Administration of Linux-based Operating Systems and Servers
Required
12
Years
Experience with System Administration of Windows-based Operating Systems and Servers
Required
12
Years
Experience with System Administration of Microsoft SQLServer
Required
12
Years
Experience with System Administration of PostGresSQL
Required
12
Years
Experience in the maintenance and monitoring of system & network related activities associated with data security and controls.
Required
12
Years
Experience leveraging SQL relational databases to manage complex datasets and analytical reporting
Required
12
Years
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 S
Required
12
Years
Experience with programing scripting languages (Ex: Python, R/RStudio, JavaScript, JSON/CVS, Perl, Scala, C/C++)
Required
12
Years
Bachelor's Degree from an accredited four-year university in Computer Science, Information Management, or other relevant field is preferred.
Required
15
Years
Understanding of the Software Development Lifecycle (SDLC) in Agile and Waterfall environments
Required
8
Years
Proficiency in the use and administration of Erwin Modeling Suite (Data Modeler Navigator, Data Modeler WGE, Mart Server, Web Portal), or similar tool
Required
8
Years
Proficiency with Agile Testing, Automation Testing, Black-box Testing, Unit Testings, Cross-Browser Testing
Required
8
Years
Communication skills, both written & spoken, business level English mandatory ability to articulate technical terms and complex data clearly to non-te
Required
8
Years
Writing System Guides, Manuals, and User Guides for complex systems
Required
8
Years
Familiarity with Cloud Computing, Cloud Storage, DataLakes, and/or Data warehouses
Required
2
Years
Familiarity with CKAN, DKAN, and/or ArcGIS
Required
2
Years
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
Outsourcing/Offshoring
Referrals increase your chances of interviewing at Prohires by 2x