Job Description :
Hi,
Hope you are doing well,

Let me know if you are available.

Senior Data Warehouse Specialist
Jackson Graham Building (Washington DC)
Due Date to SFA for Consideration: Due to SFA 11/17/2020 at 2:00PM
Duration of Project: 3000 Hours

Good afternoon,
If a candidate meets minimum requirements, send the following complete information for consideration:
Resume: All resumes shall be submitted in a Word document with no company name/logo anywhere on the resume. The candidate's personal email and phone number must be on the resume, as well as information regarding current location and citizenship status. The candidate resume must reflect experience that meets the minimum requirements of deliverables and duties.
Education verification: Please include copies of diplomas/certifications
Exclusivity statement: Use the template attachment and update the requirement number and title for this specific requirement, sign in ink, date and scan. The statement must include the requirement number of this posting.
Rate: Provide rate for position commensurate with qualifications

Requirement #: FQ15124-TOG1-RFQ311- PR55122
Posting Title: Senior Data Warehouse Specialist
Location: Jackson Graham Building
Due Date to SFA for Consideration: Due to SFA 11/17/2020 at 2:00PM
Duration of Project: 3000 Hours



Data Warehouse Specialist for GTFS Datamart-API project to develop a Datamart with an API enabled to deliver data in GTFS format internally and externally in real time.



Deliverables:

Data Mart Designs, ETL Program and algorithm designs, Data stage upgrade and administration, Cognos Framework Manager models Lifecycle, metadata, and other technical documentation as required by SDLC and WMATA IT Business Intelligence standards standards. The successful candidate will have in-depth and broad experience related to: Capture and use mobile device data for customer analysis Create relational data models Develop robust data cleansing routines, complex algorithms, and aggregate data for dashboards using mobile device and financial data Provide technical leadership for other team members Communicate and collaborate effectively with end users, analysts, SMEs, and report developers on full lifecycle BI projects Technical skills required include: At least 10 years experience designing and developing ETL and data models in data warehouse/data mart environments involving extensive data cleansing and/or tight algorithm design; At least 2 years experience developing for Oracle 12(c); At least 3 years experience using SQL Server Integration Services (SSIS) 2008/2016 for end to end ETL development for BI applications, especially for financial reporting; At least two years experience developing for consumption by Cognos; Experience developing in Java;



Supplemental Duties:

WMATA currently publishes rail and bus schedule and real-time vehicle location information in the GTFS format via an API. The API is used by third-party app developers to provide customers with information about our scheduled and real-time service to aid in trip planning and decisions to ride our system. WMATA does not currently consume or store the data in the GTFS format for its own use, but has several new requirements to do so: 1. Share GTFS data with regional partners to fulfill Bus Transformation Project commitments. The region has agreed to collect and share standardized bus operations and performance data across agencies to improve transparency and better plan bus service (Recommendation B of the Bus Transformation Project The WMATA data management working group (composed of staff from BTSS, IT, PERF, PLAN, IPLN and STIN) decided to leverage the GTFS formatted data as much as possible in order to minimize the burden on WMATA and regional staff to collect and share data. 2. Use GTFS as the official source of performance metrics (e.g. Bus on-time performance) for internal and external reporting. This will enhance transparency and accountability, as third parties are already using WMATA GTFS data to calculate their own performance metrics. It will also improve the data quality of our GTFS feed¿the primary source of information used by our customers to make decisions to ride our system¿by increasing the visibility and attention that senior leaders pay to this source. 3. Use free, open source analytic tools developed by staff at other transit agencies to evaluate performance and inform service planning decisions (e.g. bus speed map developed by Metro Transit in Minneapolis, prediction accuracy evaluation developed by MBTA This will allow Metro to replace purchased tools, saving money (e.g. a current Swiftly contract is $500K per year, including a module on bus speeds that could be replaced with the open source tool by Metro Transit)



Responsibilities
3.1.13.1.1. Perform difficult and complex technical assignments regarding the modification and/or development of complex data warehousing initiatives to align information technology solutions with business initiatives
3.1.13.1.2. Contribute to the requirements analysis, data design, database architecture, metadata and repository creation for the data warehouse
3.1.13.1.3. Design and develop the most complex Extract-Transform-Load (ETL) processes for the data warehouse

3.1.13.1.4. Quality review data loaded into the warehouse
3.1.13.1.5. Trouble-shoot and tune existing data warehouse applications

3.1.13.2. Minimum Requirements
3.1.13.2.1. Eight (8) years related experience performing difficult and complex data engineering activities regarding the design and development of existing and new data marts
3.1.13.2.2. Demonstrated experience in Oracle data warehouse development
3.1.13.2.3. Complex ETL design and development experience using PL/SQL and ETL tools
3.1.13.2.4. Bachelor's degree in Computer Science/Systems, Information Systems/Technology, Engineering/Engineering Technology, Software Engineering/Programming
3.1.13.2.5. Experience with transit data warehousing is a plus


Sunny Kumar
Technical Recruiter Cybertec, Inc
11710 Plaza America Suite 2000
Reston, VA 20190
Direct
Fax
Email:





If you would like to unsubscribe from Cybertec, Inc., please click here.

* The information and any attachments contained in this electronic message are solely intended for the exclusive use of the addressee(s) and may contain Bodhtree’s confidential, privileged information and / or subject to copyright. If you are not the intended recipient, copying, printing, disseminating this e-mail is prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and destroy all copies of this message and any attachments. While all care has been taken, Bodhtree disclaims all liabilities for loss or damages arising from misuse of any information provided or the message being infected by the computer virus or other contamination. * As a contribution towards environment, Bodhtree recommends to avoid printing unless absolutely necessary.

Client : wmata