IT Enterprise Data Architect

The successful Enterprise Data Solutions Architect is a hands-on technologist possessing advanced SQL, BI, and integration skills, combined with a confident and poised leader who has the verbal, written and visual skills to communicate complex issues in business terms. The Enterprise Data Solutions Architect will work as part of the IT Enterprise Data team innovating and applying best practice techniques for developing, enhancing, and deploying database and integration solutions to support American Red Cross operations and analytics efforts. These solutions include our enterprise-wide constituent data integration (CDI) solution, which masters over 100 million constituents including blood donors, learners, financial supporters, volunteers, and clients, as well as critical line-of-service specific ecosystems.The Enterprise Data Solutions Architect must have experience in enterprise scale EDW solutions, real-time as well as batch integration architecture and operations. He or she will serve as the principal Enterprise Data Solutions Architect leading data integration and business intelligence solution design and delivery across one or more of our key lines of service.Major Responsibilities:• Develop a practical line of service roadmap for our Power BI reporting and analytics platform.• Define the overall BI data architecture, including ETL processes, ODS, EDW, data marts and data lakes.• Guide projects to follow reference architectures, strategic technology stacks and standards and best practices. Develop plans to migrate non-standard solutions and manage exceptions.