EDW Program Manager

Washington, DC
Sep 12, 2023
Sep 22, 2023
Full Time
Job Summary

Aptive Resources is seeking a Technical / Data Warehouse Program Manager, to be part of a team, to support the Department of Veterans Affairs (VA) Office of Performance Analysis and Integrity (PA&I) for the Veterans Benefit Administration (VBA) Enterprise Data Warehouse (EDW). EDW is the source for all data and information about Veterans benefits data. It contains relevant data from each of VBA's transactional systems and arrays the data in a variety of business intelligence reporting for executive managers, business lines and claims processing teams in VBA's Regional Offices. EDW data is used for fraud detection and prevention, financial auditing, and reports to Congress. It is the source for all legal reporting requirements, to include the Government Performance Accounting Act, the American Recovery and Reinvestment Act and the Federal Funding Accountability and Transparency Act of 2006.

The Program Manager must have experience with diverse IT projects both large and small. You will manage a portfolio of projects, diverse team and multiple firms supporting one mission. This position will provide program management support and act as a data warehouse champion, to include all the necessary technical, business, and administrative planning; organizing; managing; coordinating; tracking (e.g., schedule, deliverables); performance management; and resource management required to perform all the program activities successfully.

You will oversee and lead the team providing the technical services required to sustain EDW applications. This team will include Project Management, Data Warehouse Operations and Maintenance, Business Intelligence and Reporting, Tableau Server Administration/Tableau Desktop Administration, Technical Collaboration Support, Lessons Learned, Architectural Design and Enhancement, Cloud Migration and support of Executive Orders and Special Projects.

This position is onsite in Washington, D.C. with an estimated 10% travel, during the normal operating hours of 0800 - 1700 EST Monday to Friday, excluding Federal holidays.

Primary Responsibilities

  • Serve as a focal point and provide leadership for practices related to portfolio, program, and project management.
  • Use and promote industry best practices (such as Project Management Institute (PMI) standards) to implement and support project management methodologies, processes, and acquisition strategies to deliver IT-related projects.
  • Provide governance, Program and Project Management, analysis, and planning support on an enterprise or individual project level.
  • Support a diverse team of IT DBAs, Quality Managers, Developers, Data Scientists, Analysts, and Engineering staff.
  • Employ a highly collaborative approach that maximizes existing resources and supplements the organization of projects and activities in accordance with the mission and goals of the PA&I organization.
  • Ensure requirements development and analysis support, strategic planning, project planning/schedule management, performance management, risk management and issue management are executed per the contract.
  • Build and manage operational performance metrics and communications specific to the project implementation.
  • Identify critical stakeholders and build communication plans that leverage multiple channels and provide support to ensure consistent messaging.
  • Delivery of Project Management Plan, describing the technical approach, timelines, organizational resources, and management controls being employed to meet the schedule and performance requirements.
  • Report on the resource organization structure as well as the processes to establish, organize, and maintain effective resources to support project activities.
  • Management of a diverse technical team, to include onboarding and VA clearances, changes of personnel, substitution or replacement of resources, as necessary.
  • Development, maintenance and delivery of Monthly status, Monthly progress and Quarterly and program assessment reporting.
  • Development and execution of a Quality Assurance Plan, serving to validate and to ensure the integrity of data.
  • Perform defect tracking and reporting, quality control and quality analysis and provide documentation to support the verification section of the QA plan to ensure the project outputs meet the defined acceptance criteria.
  • Develop and execute a Risk Management Plan (RMP) to support the Security Life Cycle of the Data Warehouse, defining the methodology to be used for risk identification, reducing the impact, tracking and monitoring, and reporting the results.
  • Provide BI Recurring Report enhancements based on major initiatives and support the enhancement of current OBIEE and Tableau Desktop reports, and transfer to PowerBI reports.
  • Identify all lessons learned, best practices and information gained through performance of tasks during critical failures or outage and captured in a Lessons Learned Report.
  • Create and manage long-term goals across projects.
  • Ensure goals are met in areas including customer satisfaction, safety, security, quality, and team member performance.
  • Act as a point of escalation.
  • Meet with stakeholders to make communication easy and transparent regarding project issues and decisions on services.
  • Cultivate positive, trusting, and cooperative working relationships with all persons supporting the work, including government employees and other vendors.
  • Establish goals, objectives and key performance metrics.

Minimum Qualifications

  • Bachelor's Degree in a relevant field (Computer Science, Computer Engineering or Business).
  • 8+ years relevant experience as a Technical Program Manager, Technical Project Manager, and/or Data Warehouse Champion.
  • Experience with Data Warehouse O&M, ETL, architectural design, change management, disaster recovery and BI reporting,
  • Past demonstration of ensuring service level agreements (SLAs) are being met with experience of remedial action(s) taken
  • Extensive experience within Oracle environments.
  • Ability to communicate effectively, both verbally and in writing, to interact effectively with IT management, software development and test teams, and data warehouse teams, and with business partners.
  • Delivery of error free reporting within all levels of technical and business operations.
  • Strong organizational and prioritization skills.
  • Excellent written, verbal and presentation skills.
  • Experience acting as coach and mentoring multiple teams on the effective implementation and continuous IT improvement.
  • Excellent communication and interpersonal skills, with the ability to effectively collaborate with diverse stakeholders and facilitate productive discussions.
  • Ability to communicate thoughts, ideas, and solutions logically, written, graphically and orally.
  • Proven ability to lead and inspire teams, fostering a culture of high performance and continuous improvement.
  • Strong analytical and problem-solving skills, with a focus on identifying and removing impediments to team productivity.
  • Experience in communicating detailed and technical concepts to a diverse audience.
  • Ability to obtain and maintain a public trust clearance.
  • Legal authorization to work in the U.S.

Desired Qualifications

  • Experience with Tableau servers, PowerBI, SAS Linux platforms, ITIL v4, Informatica ETL, Structured Query Language (SQL), PL*SQL, Unix shell scripts, OBIEE, Oracle Data Marts, EDW and APEX infrastructures.
  • Project Management Professional (PMP).
  • Data Warehouse Engineering Professional Certificate
  • Certified Scrum Master (CSM).
  • Experience within the federal government in technical teams.
  • Extensive experience coaching and mentoring Agile teams, including facilitating Agile ceremonies and resolving team-level challenges.
  • Strong critical thinking and analytical skills.
  • Proven ability to organize, prioritize, and work well with others.
  • Ability to get up to speed quickly on complex issues; desire to work in a fast-paced, rapidly evolving environment.
  • Presentation experience on enterprise data warehouse efforts.
  • Experience supporting large Cabinet-level federal agencies, ideally the Department of Veterans Affairs.
  • Strong customer interaction skills and a demonstrated ability to work with various stakeholders-including government Senior Executives-across multiple tasks.
  • Capable self-starter with a drive to get all types of work done and high attention to detail.
  • Management of diverse teams and experienced consultants across various roles and responsibilities.

About Aptive

Aptive is a modern federal consulting firm focused on human experience, digital services, and business transformation. We harness creativity, technology, and culture to connect people and systems to impact the world. We're advisors, strategists, and engineers focused on people, above all else.

We believe in generating success collaboratively, leaving client organizations stronger after every engagement and building trust for the next big challenge. Our work inspires people, fuels change and makes an impact. Join our team to be part of positive change in your community and our nation.

EEO Statement

Aptive is an equal opportunity employer. We consider all qualified applicants for employment without regard to race, color, national origin, religion, creed, sex, sexual orientation, gender identity, marital status, parental status, veteran status, age, disability, or any other protected class.

Veterans, members of the Reserve and National Guard, and transitioning active-duty service members are highly encouraged to apply.

Similar jobs