Business Intelligence ETL Data Developer II
COVID-19 Vaccination Policy:
Employees must have received at least the first dose of the vaccine before beginning on-campus employment, be fully vaccinated within 30 days of beginning employment and provide proof of vaccination, unless exempted as provided for in Miami University's COVID19 Vaccination Program and Policy. If you need additional information regarding exemptions, please contact AcademicPersonnel@miamioh.edu or Employment@miamioh.edu.
Job no: 500547
Department: Enterprise Information Systems
Location: Oxford, OH
Work type: Salary Staff
Categories: Information Technology
Status: Full Time
Job Title: Business Intelligence ETL Data Developer II
Hours Per Week: 40
We are looking for someone who loves all things data, loves a challenge and is looking for a dynamic and highly rewarding position at a nationally respected University. Is this you?
Our ideal candidates, like you, will help Miami University to continue to take big steps forward with our data analytic environment that is unifying multiple successful data-driven business intelligence and data analysis efforts across campus. This is a chance to help guide Miami’s data-driven future.
As the Business Intelligence ETL Data Developer and a member of our team, reporting to the Director of the Business Intelligence Center, you will have great opportunities to grow technically and professionally in multiple data driven disciplines.
- As an important member of our agile team you will build, create, or improve solutions that help analysts transform data into knowledge.
- Develop and deploy ETL (Extract, Transform, Load) processes and supporting programs.
- Work with essential players to develop custom Business Intelligence (BI) solutions for the University.
- Lead small projects in the development and use of our BI software tools and systems.
- Lead proactive change management efforts for BI platforms integrated with enterprise applications.
- Bring new development ideas to existing applications and processes, look for ways to enhance existing specifications based on current requirements.
- Work in partnership with the university offices to optimize use of data driven solutions, including the development of stories and test cases.
- Assist with the development of end-user training and training materials and provide guidance and mentoring for the campus BI Community.
- Provide documentation and support for deployed BI applications.
- Require a Bachelor's degree earned by date of hire and two or more years of relevant experience.
- Associate's degree earned by date of hire and four or more years of relevant experience.
- Degree in Computer Science, Information Technology, Business Analytics, or a related field.
We are looking for you to have strong knowledge and experience in:
- PL/SQL and SQL programming
- Relational database architectures at enterprise scale. Environments such as SQL Server, MySQL, Oracle, or Redshift.
- Enterprise business intelligence and data analytics technologies, such as Oracle OBIEE, MS Power BI, Tableau, Oracle Warehouse Builder (OWB), and Oracle Data Integrator (ODI).
- Industry standard data models such as Kimball’s dimensional model
- Methods in change data capture and slowly changing dimension loads and updates processes.
- BI development best practices such as source code, prototyping, and testing.
- Basic troubleshooting best practices with specific focus on enterprise BI systems.
- Data analytics and BI industry trends including data mining, data modeling, machine learning, visualization, data lakes and predictive modeling.
- Supporting BI technology in a higher educational setting.
- Analytical tools available in cloud infrastructure such as AWS, Azure, and GCP.
- Working as a member of a team using Agile development techniques (Scrum or Kanban)
Knowledge, Skills and Abilities
See Minimum Qualifications.
Special Instructions to Applicants:
Miami University recognizes that technology enables us to find new ways of providing first-class service and workplace flexibility. This position is approved for remote work on a hybrid basis. Remote work is a working arrangement that can be modified or revoked by Miami University at any time for any reason.
Miami University is committed to creating an inclusive and effective teaching, learning, research, and working environment for all.
For more information on Miami University’s diversity initiatives, please visit the Office of Institutional Diversity & Inclusion webpage. For more information on Miami University’s mission and core values, please visit the Mission and Core Values webpage.
EO/AA Statement/Clery Act:
Miami University, an Equal Opportunity/Affirmative Action employer, encourages applications from minorities, women, protected veterans and individuals with disabilities. Miami University prohibits harassment, discrimination and retaliation on the basis of age (40 years or older), color, disability, gender identity or expression, genetic information, military status, national origin (ancestry), pregnancy, race, religion, sex/gender, status as a parent or foster parent, sexual orientation, or protected veteran status in its application and admission processes, educational programs and activities, facilities, programs or employment practices. Requests for reasonable accommodations for disabilities related to employment should be directed to ADAFacultyStaff@miamioh.edu or 513-529-3560.
As part of the University’s commitment to maintaining a healthy and safe living, learning, and working environment, we encourage you to read Miami University’s Annual Security & Fire Safety Report at: http://www.MiamiOH.edu/campus-safety/annual-report/index.html, which contains information about campus safety, crime statistics, and our drug and alcohol abuse and prevention program designed to prevent the unlawful possession, use, and distribution of drugs and alcohol on campus and at university events and activities. This report also contains information on programs and policies designed to prevent and address sexual violence, domestic violence, dating violence, and stalking. Each year, email notification of this website is made to all faculty, staff, and enrolled students. Written notification is also provided to prospective students and employees. Hard copies of the Annual Security & Fire Safety Report may be obtained from the Miami University Police Department at (513) 529-2223.
Labor Law Posters for Applicants:
Miami University is committed to providing up-to-date information from the Department of Labor to our applicants for employment. Here, you will find links to the current information regarding the Family and Medical Leave Act (FMLA), Equal Employment Opportunity (EEO), and the Employee Polygraph Protection Act (EPPA).
A criminal background check is required. All campuses are smoke- and tobacco-free campuses.
For questions regarding reasonable accommodations for disabilities, or to follow-up with a request, please contact ADAFacultyStaff@Miamioh.edu or (513) 529-3560.
Advertised: 23 Jun 2022 Eastern Daylight Time