BI ETL Data Developer II or III

BI ETL Data Developer II or III 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 perform