Talent.com
BI ETL Data Developer III
BI ETL Data Developer IIIMiami University • Oxford, OH, United States
BI ETL Data Developer III

BI ETL Data Developer III

Miami University • Oxford, OH, United States
16 hours ago
Job type
  • Full-time
Job description

BI ETL Data Developer III

The Business Intelligence Team is 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.

Essential Duties :

  • 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 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.
  • Develop / assist end-user training and training materials and provide guidance and mentoring for the campus BI Community.
  • Develop / provide documentation and support for deployed BI applications.
  • Build positive relations and serve as a liaison with IT clients and IT Services staff.

Minimum Qualifications :

  • Bachelors degree earned by date of hire AND 4+ years of relevant experience OR Associates degree earned by date of hire AND 6+ years of relative experience.

    • Preferred Qualifications :

  • Associates or Bachelors Degree in Computer Science, Information Technology, Business Analytics, or a related field.

    • Required Knowledge, Skills, and Abilities :

    Technical :

  • 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), Snowflake
  • 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.

    • Team :

  • Working as a member of a team using Agile development techniques (Scrum or Kanban)

    • Preferred Knowledge, Skills, and Abilities :

  • Demonstrable ability to be a strong verbal and written communicator both at the technical and people level.
  • Demonstrable ability in building consensus among teams, clients and organizational leaders.
  • Experience with Snowflake and / or conversion from OAS to Snowflake and Tableau.

    • Additional Position Information (if applicable) :

  • Additional details are available in our Prospectus.
  • This position is open only to individuals authorized to work in the United States on an indefinite basis.
  • Eligible candidates must currently reside in, or be willing to relocate to, Ohio, Kentucky, or Indiana within 90 days of position acceptance.

    • Required Application Documents :

    Resume

    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.

    Reasonable Accommodations : Requests for reasonable accommodations for disabilities related to employment should be directed to ADAFacultyStaff@ or 513-529-3560.

    Miami University Values Statement : Miami University is a scholarly community whose members believe that a liberal education is grounded in qualities of character as well as of intellect. We respect the dignity of other persons, the rights and property of others, and the right of others to hold and express disparate beliefs. We believe in honesty, integrity, and the importance of moral conduct. We defend the freedom of inquiry that is the heart of learning and combine that freedom with the exercise of judgment and the acceptance of personal responsibility.

    Equal Opportunity / Affirmative Action Statement : Miami University, an Equal Opportunity / Affirmative Action employer, encourages applications from 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.

    Clery Act : 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.

    Labor Law Posters for Applicants : Please visit our webpage to access all relevant and applicable labor law information.

    Create a job alert for this search

    Etl Developer • Oxford, OH, United States