For a better experience, click the Compatibility Mode icon above to turn off Compatibility Mode, which is only for viewing older websites.

Careers at Drexel

About Drexel University

Located in the heart of Philadelphia, Drexel University is a world‐class, comprehensive, R1 research institution and a global leader in experiential education. For more than 100 years, our renowned Cooperative Education (co-op) program has enabled students to gain professional work experience before they graduate, setting them apart from their peers.

Committed to becoming the nation’s most civically engaged university, Drexel supports engagement along three dimensions: research and academic programs that directly benefit communities, business practices that support equitable local and regional economic development, and public service by students, faculty, and staff. Our engagement is long‐term, multigenerational, and fundamental to the University’s mission, heritage, and future.

At Drexel, we are devoted to fostering an inclusive and welcoming environment that promotes healthy lifestyles and is based on integrity, trust, and respect. We center equity, inclusion and belonging, and incorporate an anti‐racism approach to our strategic plan, organizational systems, policies and structures.

Drexel offers its highly engaged faculty and professional staff a comprehensive and world‐class benefits package that includes generous vacation and paid time off as applicable (including civic engagement days), up to an 11% 403(b) Retirement Plan match with immediate vesting, and remote and flexible work options for many roles. Our exceptional medical plans include domestic partner and fertility assistance and our award‐winning A Healthier U wellness program. In addition, faculty and professional staff at Drexel enjoy free tuition for themselves and their dependents for Drexel degree programs, certification, and non‐certification programs. And as part of the tuition offering to employees, Drexel participates in a tuition exchange program for dependents with other higher education institutions. These are just a sample of our extensive benefit offerings. Please see this Benefits Brochure for more information.

Data Warehouse Developer

Apply now Job no: 504085
Work type: Full-Time
Location: University City - Philadelphia, PA
Categories: Drexel University

Job Summary 

The Data Warehouse Developer will primarily be responsible for advancing and managing the technical and logical design for the University data warehouse for improved data integration with business intelligence end-user tools. 

The position plans, designs, builds, tests, and deploys data warehouse and data mart solutions to support the university operational and strategic reporting activities.  The desired candidate will be an agile and creative thinker who will listen to what people are trying to achieve and infuse the possibilities that visual analytics can bring to the problem and create a solution that can be delivered with high quality.

Essential Functions 

  • Lead data warehousing design plans, development, and testing.
  • Develop data models that are flexible and sound.
  • Collaborate with teams to develop sound physical, logical and presentation design for data integration. 
  • Develop a security model that is sustainable and secure.
  • Provide Technical Documentation for enterprise operational and strategic reporting models.

Required Qualifications 

  • Minimum of Bachelors degree in Computer Science or related field. (or equivalent experience).
  • Minimum of 3-5 Years’ experience in data warehousing, data marts, data management or related field.
  • Minimum of 3-5 years’ experience in database and information systems technology.
  • Proven experience with Advance SQL in Oracle, MS SQL Server, or other relational databases.
  • Strong skills in time management and project management, including developing project plan documents, technical specs, detail design documents, and test strategy documents as part a development release strategy.
  • Skilled in designing and documenting automated ETL processes and ability to create entity relationship diagrams.
  • Excellent interpersonal skills and communication skills.
  • Be self-motivated and able to work both independently and as part of team.
  • Ability to analyze project, program and portfolio needs, as well as to determine the resources needed to achieve objectives and overcome cross-functional barriers.

Preferred Qualifications

  • Data-modeling and information classification expertise at the enterprise level.
  • Understanding of the differences between relational modeling and object modeling.
  • Professional experience with multiple (two or more) business intelligence tools (OBIEE or Tableau preferred).
  • Exposure to multiple (two or more) data integration tools.
  • Delivery of at least three data warehouse/marts/lakes from specification through end-user acceptance testing.
  • Exposure to machine learning and predictive analytics.
  • Strong understanding of databases and data structures.
  • Excellent written and verbal communication.
  • Experience with data governance processes and approaches to ensure data is secure, private, accurate, available, and usable. 
  • Exposure to database administration skills and practices.

Physical Requirements         

  • Typically sitting at a desk/table.

Location 

  • University City, Philadelphia, PA.

Additional Information 

This position is classified as an exempt grade P. Compensation for this grade ranges from $ 90,430 to $ 135,640.00 per year. Please note that the offered rate for this position typically aligns with the minimum to midrange of this grade, but it can vary based on the successful candidate’s qualifications and experience, department budget, and an internal equity review.   

We encourage you to explore Drexel's Professional Staff salary structure and Compensation Guidelines & Policies for more details on our compensation framework.  

You can also find valuable information about our benefits in the Benefits Brochure.  

Special Instructions to the Applicant 

Please make sure you upload your CV/resume and cover letter when submitting your application. 

A review of applicants will begin once a suitable candidate pool is identified.       

Advertised: Eastern Standard Time
Applications close: Eastern Standard Time

Back to search results Apply now Refer a friend

Drexel University is an Equal Opportunity/Affirmative Action employer that welcomes individuals from diverse and neurodiverse backgrounds and perspectives, and believes that an inclusive and respectful environment enriches the University community and the educational and employment experience of its members. The University prohibits discrimination against individuals on the basis of race, color, national origin, religion, sex, sexual orientation, disability, age, status as a veteran or special disabled veteran, gender identity or expression, genetic information, pregnancy, childbirth or related medical conditions and any other prohibited characteristic. Please visit our Policies page to view all University policies related to Human Resources and News and Announcements for workplace postings.

Background investigations are required for all new hires as a condition of employment, after the job offer is made.

Drexel University, in compliance with the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act (Clery Act) publishes the Drexel University Security & Fire Safety Annual Report for current and prospective students and employees. This report contains important safety information and crime statistics for the previous three years. These statistics pertain to reported crimes that have occurred on campus, in certain non-campus buildings or properties that are owned or controlled by Drexel University, and on public property within, or immediately adjacent to and accessible from the campus.

Printed copies of this report are also available by calling the Public Safety Administrative Office, 215.895.1550.

Additional information about the services provided by the Drexel University Department of Public Safety can be obtained by visiting their website.

Position Type

Work type

Locations

Philadelphia

Categories

Organization