35-Exempt Contingent Category 2
Applicant Search Category:
University Authorized FTE:
DIT-EE-Enterprise Data Services
Founded in 1856, University of Maryland, College Park is the state’s flagship institution. Our 1,250-acre College Park campus is just minutes away from Washington, D.C., and the nexus of the nation’s legislative, executive, and judicial centers of power. This unique proximity to business and technology leaders, federal departments and agencies, and a myriad of research entities, embassies, think tanks, cultural centers, and non-profit organizations is simply unparalleled. Synergistic opportunities for our faculty and students abound and are virtually limitless in the nation’s capital and surrounding areas. The University is committed to attracting and retaining outstanding and diverse faculty and staff that will enhance our stature of preeminence in our three missions of teaching, scholarship, and full engagement in our community, the state of Maryland, and in the world.
The University of Maryland has made the safety of our students, faculty and staff, and our surrounding communities a top priority. As part of that commitment, the University System of Maryland (USM) recently announced that students, faculty, and staff on USM campuses this fall, including UMD, are required to be vaccinated against COVID. As a prospective and/or a new employee at UMD, you will be required to comply with the University’s vaccination protocol. Proof of full vaccination will be required before the start of employment in order to work at any University of Maryland location. Prospective or new employees may seek a medical or religious exemption to the vaccination requirement at return.umd.edu and must have an approved exemption prior to the start of their employment. Failure to provide proof of vaccination or to obtain approval for a medical or religious exemption will result in the offer of employment being rescinded.
Position Summary/Purpose of Position:
The Data Warehouse Developer will report directly to the Business Intelligence Manager, Enterprise Data Services (EDS) within the Division of Information Technology (DIT). This is a C2 position which serves as an opportunity to contribute to a strategic initiative to improve data-driven decision-making on campus. The Data Warehouse Developer will be responsible for requirements gathering and data modeling (conceptual, logical and physical) to support the creation of a new Enterprise Data Warehouse (EDW) and data platform. This includes conducting user interviews, facilitating data modeling sessions, writing business and technical requirements, maintaining data models in LucidChart and Confluence, creating DDL and DML scripts as needed and documentation. The Data Warehouse Developer will collaborate with the EDS team on a day-to-day basis and receive technical guidance from the Data Warehouse Architect. The Data Warehouse Developer must have strong command of the SQL query language.The position also requires a solid understanding of data integration as the Data Warehouse Developer will be expected to build out ETL processes to load data into the data warehouse. It is also critical that the Data Warehouse Developer is able to guide non-technical stakeholders through requirements gathering and design sessions. Clear communication, demonstrated organizational skills, the ability to collaborate with nontechnical stakeholders, create clear and concise technical documentation, and make critical decisions are requirements to be successful in this position.
Bachelor’s degree from an accredited college or university in computer science, information systems or a related IT discipline
At least 6 years of experience building out ETL processes
At least 3 years of experience developing and maintaining large scale, enterprise data warehouse integrations
At least 6 years of hands-on SQL development experience
Extensive experience conducting user interviews, facilitating design walk through and guiding customers in developing business and technical requirements
Experience translating business requirements into technical requirements and serving as a liaison between business and technical team members
Hands on experience building reports either using SQL or industry standard BI tools such as Tableau
At Least 4 years of experience building dimensional models
Ability to communicate clearly, in written or spoken word, with customers and team members.
Experience working with a common RDBMS platform such as Oracle, SQL Server, Amazon Redshift
Self-motivated, energetic, detail oriented and a team player
Experience using JIRA for task tracking and sprint planning
Experience performing data profiling activities
Experience with Amazon Redshift or other cloud-based data warehouse technologies
Additional Certifications:Additional Information:
- This position does not provide sponsorship for Visas
Job Risks Not Applicable to This Position
Sedentary work. Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects. Repetitive motion. Substantial movements (motions) of the wrists, hands, and/or fingers. The worker is required to have close visual acuity to perform an activity such as: preparing and analyzing data and figures; transcribing; viewing a computer terminal; extensive reading.
Must have the ability to walk short distances to attend meetings on campus.
Open Until Filled Yes
Best Consideration Date 10/11/2021
The University of Maryland, College Park, an equal opportunity/affirmative action employer, complies with all applicable federal and state laws and regulations regarding nondiscrimination and affirmative action; all qualified applicants will receive consideration for employment. The University is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, religion, sex, national origin, physical or mental disability, protected veteran status, age, gender identity or expression, sexual orientation, creed, marital status, political affiliation, personal appearance, or on the basis of rights secured by the First Amendment, in all aspects of employment, educational programs and activities, and admissions.