ETL Developer

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.Offers of employment are contingent on completion of a background check. Information reported by the background check will not automatically disqualify someone from employment. Prior to any adverse decision, finalists have an opportunity to provide information to the University regarding the background check.The University reserves the right to rescind offers of employment or otherwise decline or terminate employment if the information reported by the background check is deemed incompatible with the position, regardless of when the background check is completed. Offers are contingent on providing proof of employment eligibility in the United States no more than 3 days after the initial start date. If this proof is not provided within this timeframe, the offer may be rescinded or employment terminated.Position Summary/Purpose of Position:The ETL Developer will report directly to the Assistant Director for Business Intelligence, Enterprise Data Services (EDS) within the Division of Information Technology (DIT) at the University of Maryland, College Park. 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 ETL Developer will be responsible for the design, implementation and maintenance of a new ETL process to support the creation of a new Enterprise Data Warehouse (EDW) and data platform. This includes using cloud-based technologies, establishing best practices and procedures for ETL development, implementing ETL processes, and documentation. The ETL Developer will collaborate with the Enterprise Data Services (EDS) team on a day-to-day basis and receive technical guidance from the Data Warehouse Architect. The ETL Developer should also be able to interact with Business Stakeholders and develop requirement documentation that will translate business needs into technical requirements.The emphasis of this position is the technical hands-on activities for the creation and evolution of a new ETL process. Of utmost importance is the ability to select and implement the appropriate ETL or ELT techniques and storing all data as structured files for subsequent usage in a data warehouse or Big Data analysis; prior successful ETL implementations and experience are essential, as is SQL experience. Clear communication, demonstrated organizational skills, and the ability to collaborate with non-technical stakeholders, create clear and concise technical documentation, and make critical decisions are requirements to be successful in this position. This position is considered an essential position and may be required to work at the normal work location or an alternative location during a major catastrophic event, weather emergency, or other operational emergencies to help maintain continuity of University services.Minimum Qualifications:Bachelor’s degree from an accredited college or university in computer science, information systems, or related discipline.Experience:4-6 years of experience in designing, implementing and maintaining ETL processes, including experience with SQL and data warehouse design.Knowledge, Skills and Abilities:Knowledge of data privacy practices and laws;Skill in technical support documentation;Ability to conduct research into database issues, standards and products;Ability to present ideas in user-friendly language;Ability to communicate effectively orally, and in writing;Ability to persuade and lead others to think critically in discussions;Must be self-motivated, energetic, detail oriented and a team player.Preferences:Experience with various ETL platforms, ideally including Informatica.Experience with Python or Java.Experience with JSON.Experience with OLTP and OLAP data models.Experience with Amazon Redshift or other MPP database platforms.Experience using AWS for data applications (e.g. EC2, S3, Redshift, RDS, Data Pipeline).Experience with Oracle.Experience with data related Monitoring tools.Experience with Business Intelligence Tools.Job Risks:Job Risks Not Applicable to This PositionPhysical Demands:Sedentary work. Employee will need to be able to sit for long periods of time to work on a computer, as well as travel occasionally to meet with clients and customers on and off campus.This position may require some nights and weekend work.This position is considered an essential position and may be required to work at the normal work location or an alternative location during a major catastrophic event, weather emergency, or other operational emergencies to help maintain continuity of University services.Posting Date:

08/06/2024Closing Date:

Open Until FilledBest Consideration Date:

08/27/2024Diversity Statement: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.Required Documents:ResumeCover LetterList of References (no emails sent from system)Optional Documents:1100 Chesapeake BldgUniversity of MarylandCollege Park, MD 20742uhr.umd.eduCurrent UMD Employees: Please create a case with HR on AskHR.umd.eduAnyone not currently employed at UMD: Please email uhrconnect@umd.edu

#J-18808-Ljbffr