ETL Developer
The ETL (Extract, Transform, Load) Developer designs data storage solutions, develops technical specifications, creates and maintains ETL jobs within multiple large projects, and monitors and enhances report query performance for the Enterprise Reporting environments at BGSU. The ETL Developer will interpret and transform information based on business requirements and provide the data for delivery in support of University strategic initiatives.
Works in conjunction with BI developers in analyzing data requirements, performing data discovery on complex source data, designing the data model and building the tables, views, procedures, and ETL jobs to populate the data warehouse and other data stores.
Conducts continual testing to ensure the accuracy and quality of data extracted from transactional databases and stored in the data warehouse and other datastores. Works with Data Governance and functional teams to ensure data quality.
Provides technical support and consultation to report developers. Provides support documentation.
Performs troubleshooting and maintenance on ETL applications and jobs. Develops, monitors, maintains, and troubleshoots nightly and weekly job schedules; send communications when jobs fail.
Works with Systems and Database Administrators to manage database strategy and performance.
Investigates tools and technologies related to supporting Business Intelligence systems. Participates in webinars, presentations, and self-study to broaden knowledge base and stay current in the field.
Performs other duties as needed which apply to the related technical skill set.
Required Degree:
Bachelor's degree
Bachelors Degree in Computer Science, Information Systems or related field preferred
Required Experience:
3 years experience in ETL/Business Intelligence development, database design, SQL, and programming
3 years experience in technical definition and data mapping
3 years experience in understanding data warehouse processes
3 years of hands on technical experience in data warehouse projects
Preferred Experience:
Experience with ERP (PeopleSoft preferred) and ETL tools (Talend preferred), and Databases (Oracle databases preferred)
Knowledge, Skills and Abilities:
Strong problem solving, Communication and technical writing skills
Knowledge of data warehouse ETL tools, preferably Talend
Knowledge of SQL coding for relational databases
Knowledge of dimensional data models and Ralph Kimball methodology for data warehouses
Knowledge of Business Intelligence tools, preferably Microsoft Power Bi
Ability to transform transactional data into executive information
This is a full-time position located in Bowling Green, Ohio, which offers the option for a flexible/hybrid work schedule (remote/on-campus).
Application Deadline: The search committee will review applications until the position is filled; however, for best consideration, applications should be provided by May 11, 2026.
Required Application Materials & Evaluation: Experience must be fully documented on the official application.
The application will be used to evaluate if candidates meet the minimum requirements for the position and for consideration when determining starting pay rate.
Experience requirements are inclusive of relevant professional experience, or experience attained through relevant internships, co-ops, student employment positions, or graduate assistantships.
Uploads: Required: Resume (for supplemental information only) Optional: Cover Letter
Essential Requirement: Work Authorization BGSU does not offer H-1B or other work authorization visa sponsorship for this position. Candidates must be legally authorized to work in the United States at the time of hire and maintain work authorization throughout the employment term.