BI Data Warehouse Project Lead - Airflow & Redshift

American Corporation for Public Well Being; Milwaukee (WI); Sur place; USD 95 000 - 125 000; Plein temps

Résumé du poste

American Corporation for Public Well Being (ACPWB) is seeking a hands-on IT Project Manager for the Business Intelligence team in Milwaukee to own components of the employee data warehouse, working with Airflow and Redshift on AWS. The role offers breadth, ownership, and visibility within a small team.

You will participate in sprint ceremonies, ensure data quality, and help drive engineering standards while collaborating with analysts and advisors who rely on reliable analytics.

Qualifications

• Proficiency in Airflow and Redshift with production experience.
• Ability to communicate technical concepts clearly to non-technical stakeholders.
• Experience with version control (Git), code review practices, and CI/CD pipelines.

Responsabilités

• Develop and maintain BI dashboards and analytical reports for internal stakeholders using Airflow and Redshift.
• Participate in sprint planning, standups, and retrospectives as part of the BI engineering cadence.
• Collaborate with Information Security on vulnerability assessments, patching, and compliance audits.
• Build and maintain automated data pipelines and ETL processes supporting the employee data warehouse.
• Enforce data quality standards and develop automated validation and monitoring for data pipelines.
• Contribute to code reviews, technical documentation, and engineering standards for the BI team.

Outils

Airflow

Redshift

Git

CI/CD pipelines

AWS

PostgreSQL

Snowflake

Description du poste

American Corporation for Public Well Being (ACPWB) is seeking a hands-on IT Project Manager for the Business Intelligence team in Milwaukee to own components of the employee data warehouse, working with Airflow and Redshift on AWS. The role offers breadth, ownership, and visibility within a small team.

You will participate in sprint ceremonies, ensure data quality, and help drive engineering standards while collaborating with analysts and advisors who rely on reliable analytics.