Job Title

BI ETL Data Developer II or III

Department

Business Intelligence Team

Worker Type

Regular

Pay Type

Salary

Position Salary Minimum

65,000

Position Salary Maximum

87,000

Salary will be commensurate with the level of the position, education, and experience.

Scheduled Weekly Hours

40

Benefit Eligible

Yes

Screening Date

2026-05-01

Job Description Summary

The Business Intelligence ETL Data Developer II develops, maintains, and supports scalable data pipelines and analytics solutions that enable data-informed decision-making across the University.

In this role, you will take ownership of data pipelines and contribute directly to advancing modern data engineering practices within a cloud-based data ecosystem. You will collaborate with stakeholders and technical partners to deliver reliable, high-performing solutions, with a focus on data quality, maintainability, and continuous improvement.

Job Description

Essential Duties

BI ETL Data Developer II

• Develop, maintain, and enhance data pipelines using modern ELT tools (e.g., dbt, Fivetran, Airflow, or similar) in a cloud-based environment.

• Write, optimize, and maintain SQL and/or Python-based transformations that support scalable analytics solutions.

• Monitor, troubleshoot, and resolve issues in production data pipelines to ensure reliability, performance, and data integrity.

• Implement data validation, testing, and quality checks to improve the consistency and trustworthiness of data assets.

• Collaborate with stakeholders and technical partners to translate business needs into scalable data solutions.

• Support and improve existing data integrations and workflows with a focus on maintainability and performance optimization.

• Contribute to and follow best practices for version control, testing, and deployment (CI/CD).

• Create and maintain documentation for data pipelines, models, and system processes.

• Contribute to team practices that support consistent delivery and continuous improvement.

• Stay current with emerging data tools and practices and apply them to improve team outcomes.

Essential Duties

BI ETL Data Developer III

• Design, develop, and optimize scalable data pipelines using modern ELT tools (e.g., dbt, Fivetran, Airflow, or similar) in a cloud-based environment.

• Lead the development of advanced SQL and/or Python-based transformations supporting enterprise analytics and reporting.

• Own production data pipelines, including monitoring, performance tuning, troubleshooting, and ensuring reliability and data integrity.

• Design and implement robust data validation, testing, and quality frameworks to ensure trusted data at scale.

• Design scalable data models and transformation patterns to support enterprise reporting and analytics needs.

• Partner with stakeholders to translate complex business requirements into sustainable, high-impact data solutions.

• Drive improvements to existing data pipelines and processes to enhance performance, scalability, and maintainability.

• Lead adoption of best practices for version control, testing, deployment, and operational support (CI/CD).

• Develop and maintain comprehensive documentation for data pipelines, models, and architecture.

• Guide team practices that support consistent delivery, operational excellence, and continuous improvement.

• Mentor team members and contribute to the growth of technical standards and capabilities across the team.

Minimum Qualifications

• Bachelor’s degree in computer science, information technology, or a relevant field earned by date of hire with two to four or more years of relevant experience OR

• Associate’s degree in computer science, information technology, or a relevant field earned by date of hire and four to six or more years of relevant experience.

Knowledge, Skills, and Abilities:

BI ETL Data Developer II

• Ability to analyze complex data and develop practical, scalable solutions.

• Ability to troubleshoot and resolve data pipeline and data quality issues in a timely manner.

• Ability to translate business needs into effective technical data solutions.

• Ability to communicate technical concepts clearly to both technical and non-technical audiences.

• Ability to work collaboratively across teams and build effective working relationships.

• Ability to manage multiple priorities and adapt to changing requirements in a dynamic environment.

• Ability to document solutions and processes to support maintainability and knowledge sharing.

BI ETL Data Developer III

• Ability to design scalable, maintainable, and efficient data solutions that support enterprise needs.

• Ability to diagnose and resolve complex technical and data-related issues.

• Ability to translate complex business challenges into clear, sustainable technical solutions.

• Ability to communicate complex technical concepts effectively to diverse audiences.

• Ability to lead technical discussions and influence the adoption of best practices.

• Ability to prioritize and manage multiple initiatives in a production environment.

• Ability to mentor others and contribute to the growth and effectiveness of the team.

Preferred Qualifications:

BI ETL Data Developer II

• Experience developing and maintaining data pipelines using modern ELT tools (e.g., dbt, Fivetran, Airflow, or similar).
• Experience working with cloud data platforms such as Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse.
• Experience using Python for data processing, automation, or integration.
• Experience implementing data validation, testing, or monitoring solutions.
• Experience using version control systems (e.g., Git) and contributing to CI/CD workflows.
• Experience building or supporting data models and analytics solutions.
• Experience working in Agile or iterative development environments.
• Experience supporting enterprise data systems in a higher education or similarly complex environment.

BI ETL Data Developer III

• Experience designing and optimizing scalable ELT pipelines using tools such as dbt, Fivetran, Airflow, or similar.

• Experience working with cloud data platforms such as Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse at scale.

• Strong experience using Python for data processing, automation, and system integration.

• Experience designing dimensional data models and large-scale data transformations.

• Experience implementing and managing data quality, testing, and monitoring frameworks.

• Experience leading or significantly contributing to CI/CD practices for data pipelines.

• Experience optimizing data pipelines for performance, scalability, and cost efficiency.

• Experience working in complex organizational environments (e.g., higher education, healthcare, or enterprise settings).

Additional Position Information (if applicable)

Position Prospectus: BI ETL Data Developer II/III

Required Application Documents

resume/CV, cover letter

Special Instructions (if applicable)

N/A

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.

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.

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 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.

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 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

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