Job Title
BI ETL Data Developer II
Department
Business Intelligence Team
Worker Type
Regular
Pay Type
Salary
Position Salary Minimum
$64,000
Position Salary Maximum
$75,000
Salary will be commensurate with the level of the position, education, and experience.
Scheduled Weekly Hours
40
Benefit Eligible
Yes
Screening Date
2024-10-25
Job Description Summary
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 unifies 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.
Job Description
Duties:
• As an important member of our 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 the 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.
Minimum Qualifications:
• Require a Bachelor's degree earned by date of hire and two or more years of relevant experience. OR Associate's degree earned by date of hire and four or more years of relevant experience.
Preferred Experience:
• Degree in Computer Science, Information Technology, Business Analytics, or a related field.
• 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 a 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.
• Team:
• Working as a member of a team using Agile development techniques (Scrum or Kanban)
Additional Position Information (if applicable)
ETL Developer Job Prospectus
Required Application Documents
resume/CV, cover letter
Special Instructions (if applicable)
None
Additional Information
A criminal background check is required. All campuses are smoke- and tobacco-free campuses.
This organization participates in E-Verify.
Remote Work
For positions that are approved for remote work: Remote work is not a right, it is a work arrangement that can be modified or revoked by Miami University at any time for any reason, including the convenience of the University.
Reasonable Accommodations
Requests for reasonable accommodations for disabilities related to employment should be directed to ADAFacultyStaff@miamioh.edu or 513-529-3560. Questions and follow-ups regarding requests should also be directed here.
Diversity Statement
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 Transformational and Inclusive Excellence webpage. For more information on Miami University’s mission and core values, please visit the Mission and Core Values webpage.
Equal Opportunity/Affirmative Action Statement
Miami University, an Equal Opportunity/Affirmative Action employer, encourages applications from minorities, women, protected veterans and individuals with disabilities. Miami University proh
Location: Oxford, OH
Posted: Nov. 3, 2024, 10:17 p.m.
Apply Now Company Website