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. The ETL Developer will act as the technical lead for the Enterprise Reporting Team and will provide technical training and mentoring to Application Developers on the team.
Essential Duties, Tasks and Responsibilities
Works in conjunction with Data Architect 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 data stores. Works with Data Governance and functional teams to ensure data quality
Provides technical leadership and training to application developers. Provides technical support and consultation to report developers. Provides support documentation to the Help Desk
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
Knowledge, Skills or Abilities
Strong problem solving, Communication and technical writing skills required.
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
Ability to transform transactional data into executive informations
Full-time, Administrative staff position available. Administrative Grade Level I56. Salary is commensurate with education and experience. Full benefit package available.
Deadline to apply: August 27, 2019
For a complete job description & to apply for this position visit https://bgsu.hiretouch.com/ or contact the Office of Human Resources at (419) 372-8421. BGSU. AA/EEO/Disabilities/Veterans. In compliance with the ADA Amendments Act (ADAAA), if you have a disability and would like to request an accommodation in order to apply for a position with Bowling Green State University, please call 419-372-8421.
Bachelor's Degree required in Computer Science, Information Systems or related field. Successful candidate must have Bachelor’s degree conferred at the time of application.
The following experience is required:
5 years’ experience in ETL/Business Intelligence development, database design, and SQL programing required.
5 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
Experience with PeopleSoft administrative systems and EPM software, Talend, DataStage, or a similar ETL tool, and Oracle databases preferred.
About Bowling Green State University
Bowling Green State University is a tier-one, public university serving 19,000 students on two campuses in northwest Ohio. The University has nationally recognized programs and research in the natural and social sciences, education, arts, business, health and wellness, humanities and applied technologies. BGSU seeks talented individuals to join our community in Bowling Green, Ohio, recognized as one of the “Best College Towns of America.”Bowling Green State University provides experiences that enhance lives. Students are prepared for lifelong career growth, lives of engaged citizenship and leadership in a global society. U.S. News and World Report names BGSU as one of the top public universities nationwide with a strong commitment to first-year programs that lead to success. Within our transformative learning community, we build a welcoming, safe and diverse environment where the creative ideas and achievements of all can benefit others throughout Ohio, the nation and the world.