Job Details

Sr. Data Warehouse Architect

for

Draper Laboratory

in

Cambridge, MA 02138

(map)

Draper is an independent, nonprofit research and development company headquartered in Cambridge, MA. The 1,600 employees of Draper tackle important national challenges with a promise of delivering successful and usable solutions. From military defense and space exploration to biomedical engineering, lives often depend on the solutions we provide. Our multidisciplinary teams of engineers and scientists work in a collaborative environment that inspires the cross-fertilization of ideas necessary for true innovation. For more information about Draper, visit www.draper.com.

Our work is very important to us, but so is our life outside of work. Draper supports many programs to improve work-life balance including workplace flexibility, employee clubs ranging from photography to yoga, health and finance workshops, off site social events and discounts to local museums and cultural activities. If this specific job opportunity and the chance to work at a nationally renowned R&D innovation company appeals to you, apply now www.draper.com/careers.



Equal Employment Opportunity

Draper is committed to creating a diverse environment and is proud to be an affirmative action and equal opportunity employer. We understand the value of diversity and its impact on a high-performance culture. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information.

Draper is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. To request reasonable accommodation, please contact hr@draper.com.

Responsibilities

Provide conceptual, architectural and technical leadership for all aspects of the company's enterprise data warehouse and business intelligence reporting. Provide hands-on guidance and expert advice to the team responsible for the design, development, integration, tuning and production support of the data warehouse stack: data management and modeling, ETL, operational data store, data warehouse, datamarts, and the business intelligence reporting application (MicroStrategy).

* Analyze business requirements in various business functional areas and translate them into conceptual, logical and physical data models. Design datamarts using knowledge of data warehouse principles, architectures and technologies.
* Develop Informatica ETL processes for loading the ODS layer of the data warehouse environment from PeopleSoft and other applications; and for transforming data for a central data hub and datamarts.
* Design and develop the business intelligence interface to the warehouse using MicroStrategy tools.
* Integrate the various layers of the warehouse using various Oracle, Unix and PeopleSoft tools.
* Provide infrastructure support (code and object migrations, metadata backups, project duplications, process scheduler setup) for the warehouse project.
* Tune ETL processes and Oracle SQL statements to provide optimal load times and report execution.
* Ensure a stable, reliable and credible data warehouse environment.

Qualifications

* Bachelor of Science in Computer Science, similar degree, or equivalent work experience. Minimum of 5 years experience in data warehousing and business intelligence reporting.
* Demonstrated experience in business intelligence and data warehousing principles, approaches, technologies and architectures.
* Experience with ETL tools required, preferably Informatica's PowerCenter.
* Strong Oracle database background, with SQL, PL/SQL and SQL tuning. Experience as an Oracle DBA strongly preferred.
* Experience in Unix and shell scripting.
* Familiarity with PeopleSoft preferred, e.g. App Designer, App Engines, SQRs.

Post Date:
10/22/2017
Minimum Clearance:
Secret
Workplace:
On-Site/Office
Status:
Employee
Job Category:
Sr. Data Warehouse Architect
Compensation:
Unspecified annual salary
Unspecified hourly wage
Group ID:
RTX17014b