Data Warehouse Architect 5 - Sr. ETL/BI Developer

Roles/Responsibilities:

• Utilize the State of Michigan's Project Portfolio Management Tool (Clarity) to prepare project schedules, assign resources and management budgets.
• Prepare information for presentations geared to various audiences ranging from executives, managers and project team members.
• Accountable for monitoring, controlling, and communicating project progress by actively managing the cost, schedule, scope, resources, quality, and risks.
• Accountable and responsible for clear, timely, and accurate communications with stakeholders, particularly the project sponsors, project team members, program managers, and MGCB/DTMB management, on the status of the project, using appropriate communication methods.
• Responsible for providing leadership and fostering collaborative participation between the technical and business teams by obtaining consensus and gaining commitment.
• Responsible for working with the project team members to develop and maintain the following key SUITE Project Management Methodology (PMM) deliverables throughout the project lifecycle: Project Charter - Project Schedule Project Budget - Communication Plan Project Status Report - Risk and Issue Management Plans - Change Requests Project Closedown Summary
• Responsible for managing interfaces related communication with other agencies
• Responsible for ensuring the project adheres to the SUITE PMM and System Engineering
• Methodology (SEM), including appropriate and timely transitions through the stages and phases of the project lifecycle.
• Responsible for facilitating and enforcing the Change Management process (Change Requests) when the project deviates from the approved scope, schedule, or budget. This includes ensuring all Change Requests have appropriate approval before action is taken or information is updated.
• Responsible for creating project Corrective Action Plans (CAP) when necessary for projects in yellow or red status.
• Responsible for understanding the project benefits and the impact of change requests to the benefits business cases. Responsible for ensuring related project artifacts are updated accordingly.
• Responsible for reviewing and understanding vendor contracts to actively manage the vendor deliverables and adherence to the vendor deliverable approval procedure.
• Facilitates the interactions among stakeholders by clarifying the expectations of all participants and ensuring all deliverables are assigned, reviewed, and completed.

Mandatory Skills:

1. 7+ years, In-depth knowledge of and experience in IT project management, including industry standard and best practices and a proven record for delivering projects on time and on budget in a formal project manager role
2. 7+ years, Proven record for delivering projects on time and on budget in a formal project manager role.
3. 7+ years, Experience establishing and maintaining project budgets, schedules, change requests, risk and issue logs.
4. 7+ years, Experience developing and delivering project status
5. 5+ years, Experience using project portfolio management systems and tools (eg.) Clarity
6. 5+ years, Oversee Technical Teams with system architecture and integration across SaaS solutions.
7. 5+ years, Experience managing multi-vendor environment in a government environment.
8. 5+ years, System Security Plans (SSP)
9. 5+ years, Plan of Action and Milestones (POAM).
10. 5+ years, Advanced working knowledge of MS Project
11. 5+ years, Experience handling variety of stakeholders and system owners from other departments.
12. 5+ years, Experience providing project management services for IT Projects involving Commercial Off the Shelf Technology (COTS)
13. 5+ years, Developed and maintained detailed project integration schedule.
14. 5+ years, Prior Developer/Senior Technical Project Management experience
15. Certification: Scrum Master Certified

Desirable Skills:

Certification: Possession of a Project Management Professional (PMP) Certification (Highly desired). 3 years