Data Engineer (ETL Developer & System Administration concentration) (min 11 yrs+ exp) REMOTE (Webcam or in-person interviews)
Data Engineer (ETL Developer & System Administration concentration) (min 11 yrs+ exp) REMOTE (Webcam or in-person interviews)
Prohires
Washington, DC
See who Prohires has hired for this role
POSITION DESCRIPTION
DIRECT CLIENT Position
Number of positions: 1
Length: 8-20 Months +
Location: Washington, DC 20019
Immediate interviews Webcam or in-person interviews
Please note that this position is REMOTE.
12+ years of experience needed to serve as the subject matter expert on data architecture for the agency's multi-year Data Management Project to modernize the agency'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 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 departments and improve inter-agency data integration.
The Data Management Project Data Engineer serves as an ETL developer and system administrator for the client's multi-year Data Management Project to modernize the agency'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: include:
Specific Duties:
- Develop, test, and maintain extraction, transformation, and load (ETL) processes.
- Support the System Administration of associated tools and software of data and analytics landscape at DOES 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 DOES data standard.
- Participate in the development and maintenance of agency data security, privacy, policies, procedures, and best practices.
Skill Matrix
Experience with Business workflow processes
Required / Desired
Amount
of Experience
Programming: proficiency in SQL, Python, R, JavaScript, JSON, and Excel Formulas & Charts.
Required
11
Years
Operating Systems: Windows and Linux.
Required
11
Years
Modeling Tools: proficiency in the use and administration of Erwin Modeling Suite (Data Modeler Navigator, Data Modeler WGE, Mart Server, Web Portal
Required
11
Years
Testing: proficiency with Agile Testing, Automation Testing, Black-box Testing, Unit Testings, Cross-Browser Testing.
Required
8
Years
Experience and understanding of BI tool architecture, functions, features (ie. Tableau and/or MicroStrategy).
Required
5
Years
Outstanding consultative skills, understanding business needs and translating those needs to technical requirements and solutions.
Nice to have
11
Years
Ability to communicate effectively with all levels of the organization including business owners, leaders, and executives.
Nice to have
11
Years
Bachelor's Degree from an accredited four-year university in Computer Science, Information Management, or other relevant field is preferred.
Required
15
Years
Familiarity with CKAN, DKAN, and/or ArcGIS is an added
Nice to have
8
Years
ETL processes development
Required
11
Years
a
-
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
See who you knowGet notified about new Data Engineer jobs in Washington, DC.
Sign in to create job alertSimilar jobs
People also viewed
-
Full Stack Developer
Full Stack Developer
-
Back End Developer (Remote)
Back End Developer (Remote)
-
Full-Stack Java Web Application Developer (100% Remote)
Full-Stack Java Web Application Developer (100% Remote)
-
Front End Engineer
Front End Engineer
-
Full Stack Software Engineer
Full Stack Software Engineer
-
Front-end Engineer
Front-end Engineer
-
Backend Engineer
Backend Engineer
-
Software Developer
Software Developer
-
Frontend Developer
Frontend Developer
-
Jr. Oracle Developer
Jr. Oracle Developer
Similar Searches
Explore collaborative articles
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
Explore More