Business Intelligence Solutions Architect

This individual will be responsible for developing, selecting and executing integrated technology solutions for support and analysis of business intelligence across AHA. Responsible for collaborating with stakeholders and team members to define, design and deliver actionable insights from master data sources in an Agile environment. Other responsibilities will include:

• Designs integration architectures, defines data mappings, develops data models, and consults with the infrastructure team on server and data storage services.
• Formulates and recommends standards for achieving maximum performance, compliance and efficiency of the Data Warehouse and Master Data Management systems.
• Ensures accuracy and integrity of service-oriented architecture through analysis, coding, writing clear documentation and problem resolution.
• Reviews issues and enhancements documented in the incident management and project management system for consideration of business needs.
• Maintains in-depth current knowledge of standards, guidelines, and industry trends for Data Warehouse Architecture as it relates to reporting and operations.
• Attends and interacts with user groups and researches new software vendors in the market.
• Fosters use of self-service analytics, data governance and visual discovery while guiding changes and limited reliance on manual data processes.
• Builds proof of concept and tangible results by sharing testing data.
• Participates in the planning for retirement of systems programs, and migration of systems infrastructure by providing current state and future state architectural diagrams.
• Works closely with Business Intelligence Manager to ensure prioritization of corporate and department objectives within the portfolio management system. Champions data quality, integrity and reliability throughout the department by designing data flow models and promoting development best practices with best of breed automation tools.
• Provides mentoring to Extract/Transform/Load (ETL) team members with technical expertise, complex systems, and/or programming knowledge.
• Provides on-the-job training for new or less experienced ETL team members. Provides technical training to external team members to encourage cross-department connections including the development and maintenance of standard operating procedures.
• Provides a methodology for the ongoing assessment of database performance and the identification of problem areas by holding regularly scheduled reviews of code and monitoring software.
• Develops business cases, impacts evaluation and ROI for department to get buy-in from senior management.