Senior Data Engineer

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact hr-accessibleapplication@osu.edu. 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:

ERIK | Office of Research Information Systems

Job Summary:

The Senior Data Engineer is responsible for designing, developing, and maintaining robust ETL solutions to extract, transform, and load data from a wide range of structured and unstructured sources. This role ensures seamless data integration and accessibility to support analytics, reporting, and business intelligence initiatives. Designs, develops, and manages database solutions by leveraging advanced T-SQL to create and maintain stored procedures, functions, and other database objects that support complex data operations and business requirements. Supports the analysis, design, development, and maintenance of Business Intelligence solutions—including reporting and analytics—under the direction of the Manager of Business Application Development within ORIS. Utilizes expertise and knowledge of systems and services to perform responsibilities using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Workday, Tableau, Excel and other relevant tools. Works with data across multiple systems, like SQL Server, AWS Redshift, Workday, Huron and other solutions for efficient data retrieval, analysis, processing and management of large and disparate datasets.

Required Education and Experience:

• Bachelor's degree in computer and information science or an equivalent combination of education and experience.
• 4 years of experience relevant working experience, such as MS SQL Server, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), Tableau, Workday, Excel, SQL query execution, execution analysis & optimization, indexing strategies, REST based web services, and use of APIs and scripting techniques to automate processing.
• 4 years of practical experience in creating intuitive, interactive, and effective reports, dashboards, and visualizations.
• Working knowledge in AWS and/or Azure data services.
• Demonstrated proficiency in Workday reporting tools and modules, including Report Writer, Composite Reporting, and Advanced Reporting.
• Must have strong analytical skills that allow for the development of data-driven reports. Strong written and verbal communication skills to effectively relate data to coworkers and clients. 

Desired Education and Experience:

• Masters or advanced degree in computer information science, or an equivalent combination of education and experience.
• 4-8 years of relevant work experience.
• Experience with Cloud computing services like AWS, Azure, Data Lake and Warehouse tools, Microsoft Power BI and .NET Framework.
• Possesses or is pursuing an AWS and/or Azure certification.
• Experience in Database Administration (DBA) skills for managing MS SQL Server, Data Analysis, Modeling and Profiling.
• Working knowledge of Data security standards, web accessibility standards, application workflow design, automated testing and Source control tools.
• Knowledge of Research Administration based processes and systems related to proposal and award management, responsible research practices, compliance, funding opportunity, etc.
• Able to converse with a broad spectrum of people with different levels of technical proficiency.

A resume is required to be submitted to be considered for this position. A cover letter is strongly desired.

<