Senior Data Engineer

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact ... . 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 EngineerDepartment: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 solutionsincluding reporting and analyticsunder 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.

Additional Information:

The Target Hiring Range for this position is $88,300-$115,350. The salary offer for this position may fall within this range based on the candidate's qualifications, internal equity, and the unit's available budget, which will be the primary determining factor.

This is a hybrid position, requiring residency in the state of Ohio by the time of start.

The Ohio State University will not sponsor applicants for work visas for this position.

Function: Information Technology

Subfunction: Data Engineering

Career Level: Specialized- 3

ERIK Overview:

Join the Enterprise for Research, Innovation and Knowledge (ERIK) at The Ohio State University and become a part of a dynamic, forward-thinking team dedicated to pushing the boundaries of discovery and innovation. ERIK positions Ohio State to expand curiosity-driven research and creative expression, further develop our research community of faculty, staff, and students, and grow the innovation ecosystem to address big challenges and improve communities locally and globally. We are seeking passionate individuals who are committed to making a meaningful impact through collaboration, innovation, and excellence. To learn more about our mission and work, please visit .

ORIS Overview:

The ERIK Office of Research Information Systems (ORIS) data team is responsible for providing services related to Data Analysis, Engineering, Integration, Management, Reporting and Security to all units and centers within ERIK.

Location:Mount Hall (0311)Position Type:RegularScheduled 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.