Senior Data Engineer

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact [email protected]. If you have questions while submitting an application, please review these frequently asked questions.

Current Employees And Students

If you are currently employed or enrolled as a student at The Ohio State University, please log in to Workday to use the internal application process.

Welcome To The Ohio State University's Career Site. We Invite You To Apply To Positions Of Interest. In Order To Ensure Your Application Is Complete, You Must Complete The Following

• Ensure you have all necessary documents available when starting the application process. You can review the additional job description section on postings for documents that may be required.
• Prior to submitting your application, please review and update (if necessary) the information in your candidate profile as it will transfer to your application.

Job Title:Senior Data Engineer

Department:OCIO | Enterprise Applications

The Data and Analytics Team within the Office of Technology and Digital Innovation (OTDI) at The Ohio State University manages the enterprise data reporting, analytics, and governance environments that support leaders, decision-makers, and data analysts/scientists across campus. Our vision is to enable a culture of data enablement and thought leadership through accurate, accessible information and innovative analytics.

This Senior Data Engineer position will help realize the design and build of ETL/ELT and other data integration movement processes for the Reporting and Analytics Environment; among other systems we manage within the department. Our current system implementations include cloud-based analytics solutions (IAAS PAAS SAAS) and interactions with internal OSU systems across the enterprise.

The technologies we use daily focus on modern data analytics architectures backed by big data tools. This role will utilize data integration methodologies and design practices to move data from source systems into secure and governed data analytics and/or data hub environment. The work also focuses on making this data available to analysts, users, and systems.

The Senior Data Engineer will be responsible for engaging with other data engineers within the team as well as collaborating with OTDI Infrastructure colleagues and specialists in designing and implementing integrations from multiple systems into the team's data environments. It is expected that this resource will work to obtain and refine data requirements, build data integration flows, partner with data and visualization analysts on query optimization and tuning, and confer with data governance resources on metadata requirements.

Also, will provide production support duties for the systems we manage; this role will respond to help desk issues related to our systems, be responsible for monitoring the production support queue, and respond to data flow failures in a timely manner. This includes participating in rotating off-hours and weekend on-call/pager duty.

Required Education And Experience

Bachelor's Degree or equivalent experience. 4 years of relevant experience related to

• Demonstrated deep understanding of SQL and hands-on experience implementing ETL (or ELT) best practices at scale.
• 3 to 5 years using Python, Java, Scala, or other programming languages for data processing (Python preferred)
• Experience in working with business and process analysts in gathering requirements as well as in collaborative data movement design and data governance.
• Familiar with modern data analytics technologies and techniques, such as cloud-based
• analytics environments (AWS, Azure, GCP) serverless coding streaming and micro-batch data loads code automation continuous development delivery and integration
• Experience with web services/APIs (REST, SOAP), S/FTP, and data interchange formats (JSON, XML, CSV)
• Strong interpersonal skills, including excellent customer service and relationship management skills.
• Detail-oriented and desire to continually keep up with advancements in data engineering practices.
• Strong written and verbal communication skills, including presenting complex topics to business teams and leadership.
• Ability to flex and adapt to changing environments and direction in team development goals.

Must have experience working with both technical and business/process analysts in a fast-moving and high caliber environment

Desired Education And Experience

• Experience in Higher Education
• More than 4 years of relevant experience with the AWS or Azure data analytics components
• Experience with Tableau or other analytics tools

This position maps to Information Technology , Data Engineering , Individual Contributor - Specialized , and S3 .

Additional Information

Location:Mount Hall (0311)

Position Type:Term (Fixed Term)

Scheduled Hours:40

Shift: First Shift

Final candidates are subject to successful completion of a background check. A drug screen or physical may be required during the post offer process.

Thank you for your interest in positions at The Ohio State University and Wexner Medical Center. Once you have applied, the most updated information on the status of your application can be found by visiting the Candidate Home section of this site. Please view your submitted applications by logging in and reviewing your status. For answers to additional questions please review the frequently asked questions.

The university is an equal opportunity employer, including veterans and disability.

As required by Ohio Revised Code section 3345.0216, Ohio State will: educate students by means of free, open and rigorous intellectual inquiry to seek the truth; equip students with the opportunity to develop intellectual skills to reach their own, informed conclusions; not require, favor, disfavor or prohibit speech or lawful assembly; create a community dedicated to an ethic of civil and free inquiry, which respects the autonomy of each member, supports individual capacities for growth and tolerates differences in opinion; treat all faculty, staff and students as individuals, hold them to equal standards and provide equality of opportunity with regard to race, ethnicity, religion, sex, sexual orientation, gender identity or gender expression.