The IT Senior Engineer, ETL Developer job with the University of Maryland offers a unique opportunity for professionals in the field to contribute to a strategic initiative aimed at enhancing data-driven decision-making on campus. As an ETL Developer, the individual will be responsible for designing, implementing, and maintaining a new ETL process to support the creation of an Enterprise Data Warehouse and data platform. Collaborating with the Enterprise Data Services team and receiving guidance from the Data Warehouse Architect, the ETL Developer will play a key role in selecting and implementing the appropriate ETL techniques and ensuring the efficient storage and usage of structured files for data analysis. With a focus on technical hands-on activities and the ability to communicate and collaborate with non-technical stakeholders, this role requires experience in ETL implementations, strong SQL skills, and the ability to make critical decisions. The candidate should also possess knowledge of data privacy practices, technical support documentation, research capabilities, and effective communication skills. A Bachelor’s degree in computer science or a related discipline, along with 4-6 years of experience in ETL processes and SQL, is required. Preference will be given to candidates with experience in Informatica, Python or Java, JSON, OLTP and OLAP data models, Amazon Redshift or other MPP database platforms, and AWS for data applications. The salary range for this position is $115,000-$130,000, with additional benefits including medical, dental, and vision coverage, flexible work opportunities, tuition remission, paid time off, and retirement benefits.
Read more about the Job you will love
Job Description
The IT Senior Engineer, ETL Developer position at the University of Maryland in College Park, Maryland, is responsible for designing, implementing, and maintaining ETL (Extract, Transform, Load) processes. These processes are crucial for the creation and evolution of a new Enterprise Data Warehouse (EDW) and data platform. The ETL Developer will use cloud-based technologies and establish best practices and procedures for ETL development. They will collaborate with the Enterprise Data Services (EDS) team and receive technical guidance from the Data Warehouse Architect.
The ETL Developer will also have the opportunity to interact with Business Stakeholders and develop requirement documentation that translates business needs into technical requirements. The emphasis of this position is on technical hands-on activities for the creation and evolution of a new ETL process.
Responsibilities
The responsibilities of the IT Senior Engineer, ETL Developer include:
- Designing and implementing ETL processes to support the creation of a new Enterprise Data Warehouse (EDW) and data platform.
- Using cloud-based technologies for ETL development.
- Establishing best practices and procedures for ETL development.
- Collaborating with the Enterprise Data Services (EDS) team on a day-to-day basis.
- Receiving technical guidance from the Data Warehouse Architect.
- Interacting with Business Stakeholders to develop requirement documentation.
- Selecting and implementing appropriate ETL or ELT techniques.
- Storing all data as structured files for subsequent usage in a data warehouse or Big Data analysis.
Read more about the Job you will love
Requirements
To be eligible for the IT Senior Engineer, ETL Developer position, candidates must meet the following requirements:
- Bachelor’s degree from an accredited college or university in computer science, information systems, or a related discipline.
- 4-6 years of experience in designing, implementing, and maintaining ETL processes.
- Experience with SQL.
- 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.
- Effective oral and written communication skills.
- Ability to persuade and lead others in critical discussions.
Preferences
In addition to the minimum qualifications, the following preferences would be beneficial for the IT Senior Engineer, ETL Developer position:
- Experience with various ETL platforms, ideally including Informatica.
- Experience with Python or Java.
- Experience with JSON.
- Experience with OLTP and OLAP data models.
- Must be self-motivated, energetic, detail-oriented, and a team player.
- 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.
Additional Information
Benefits Included
The University of Maryland offers a range of benefits to employees, including:
- Medical, dental, and vision coverage designed to support an employee’s and their family’s health.
- Flexible work opportunities.
- UMCP Tuition Remission for employees and their dependents.
- Generous paid time off package.
- Retirement benefits to aid employees in reaching future retirement goals.
Physical Demands
The IT Senior Engineer, ETL Developer position requires sedentary work. The employee will need to be able to sit for long periods of time to work on a computer. They may also need to travel occasionally to meet with clients and customers on and off campus. Additionally, the position may require being on call to provide some outside of business hours support.
Best Consideration Date
The best consideration date for applications for the IT Senior Engineer, ETL Developer position is November 13, 2023. However, applications will be accepted until the position is filled.
Background Check
Offers of employment for the IT Senior Engineer, ETL Developer position are contingent on the completion of a background check. The background check will not automatically disqualify applicants from employment.
Similar Jobs
If the IT Senior Engineer, ETL Developer position is not the right fit, there are several similar positions available at the University of Maryland, including:
- IT Systems Analyst, Linux Administrator
- IT Principal Engineer, Network Architect
- IT Network Engineer, IT Junior Wireless Network Engineer
About the Employer
University of Maryland
The University of Maryland, located in College Park, Maryland, is a renowned public research university. It is dedicated to advancing knowledge, providing excellent education, and serving the state, nation, and world. The university offers a wide range of academic programs and is committed to fostering a diverse and inclusive community.
Location
The University of Maryland is located in College Park, Maryland. The campus is situated just outside of Washington, D.C., providing easy access to the nation’s capital and all it has to offer.
Posted Date
The IT Senior Engineer, ETL Developer position was posted on October 23, 2023.
Function
The IT Senior Engineer, ETL Developer position falls under the IT function at the University of Maryland. The position is responsible for designing, implementing, and maintaining ETL processes.
Industry
The IT Senior Engineer, ETL Developer position is in the technology and software industry. The University of Maryland is committed to utilizing technology to further its research, education, and administrative initiatives.
