IT Project Manager

American Corporation for Public Well Being; Milwaukee (WI); On-site; USD 95,000 - 125,000; Full time

Job summary

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.

Responsibilities

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

Tools

Airflow

Redshift

Git

CI/CD pipelines

AWS

PostgreSQL

Snowflake

Job description

Business Intelligence Staff Full-Time, Exempt

About The Role

ACPWB's Business Intelligence team is looking for a IT Project Manager who takes genuine ownership of the employee data warehouse. This is not a break-fix role or a ticket queue. You will work in Airflow and Redshift, contribute to the cloud platform operations and optimization agenda, and collaborate closely with analysts and advisors who need technology that simply works. We have a small, excellent team. We are looking for someone who fits.

ACPWB's Business Intelligence team of 12 runs the technical infrastructure that makes our analytical work credible. The IT Project Manager will take ownership of specific components of the employee data warehouse, working in Airflow and Redshift on Amazon Web Services (AWS). We are a small team that covers significant technical scope, which means you will have breadth, ownership, and visibility that larger organizations rarely offer.

Key Responsibilities

• 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 Business Intelligence 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 Business Intelligence team

Qualifications

Required

• Strong proficiency in Airflow and Redshift or an equivalent technical stack with demonstrated production experience
• Ability to communicate technical concepts clearly to non-technical stakeholders
• Experience with version control (Git), code review practices, and CI/CD pipelinesDemonstrated curiosity about new tools and technologies with evidence of self-directed technical learning

Preferred

• Background in application security including OWASP principles and secure development practices
• Experience building internal developer tooling or productivity infrastructure
• Experience with PostgreSQL, Snowflake, or other enterprise relational or analytical databases
• Experience with feature flagging, A/B testing infrastructure, or progressive deployment patterns

WHY ACPWB

ACPWB occupies a distinctive position: large enough to be credible, small enough to be agile, old enough to have a track record, young enough to still be building it. The people who thrive here find that combination energizing rather than disorienting.

ACPWB was founded in Milwaukee in 2006 with a simple mandate: help working Americans understand and advocate for the compensation they deserve. Eighteen years later, that mandate has grown into a full-service research and advisory practice serving clients from early-stage employers to Fortune 50 enterprises — and we are still based in Milwaukee, because Milwaukee is genuinely underrated.

INTERVIEW PROCESS

Selected candidates will receive a short written prompt asking them to describe an analytical problem they have solved and how they approached it. This takes approximately 30 minutes. Strong responses advance to a full interview sequence. Every response is reviewed by a human being, not a filter.

What Success Looks Like In Year One

• Establish your own development environment, testing practices, and review standards consistent with team norms
• Identify and resolve at least one performance, security, or reliability gap in the existing infrastructure
• Ship at least two meaningful features or improvements to the employee data warehouse with full documentation
• Establish a reliable on-call rotation and demonstrate competent incident response