Business Intelligence Architect

Children's Healthcare of Atlanta • Atlanta, GA

19h • Onsite

About The Position

Serves as subject matter expert with in-depth knowledge of the complete business intelligence and analytics delivery lifecycle including data ingestion, integration, warehousing, data mart design, quality, governance, and information delivery. Identifies data management improvement opportunities and contributes to the implementation of Data & Analytics Program strategies and initiatives. Collaborates with technology teams and cross-functional business partners to design, architect, and deliver enterprise analytics solutions. Mentor’s data and analytics team members to effectively design complex data architectures to create well-defined, trusted, and reusable data assets that empower analytics.

Requirements

• Minimum of 12 years of experience in Business Intelligence, Data Warehousing, and Data Engineering disciplines in an enterprise IT environment
• Implementation and oversight of multiple enterprise data warehouses (custom-developed and vendor-packaged) in synchronization and support of organizational initiatives
• Implementation of integrated data model solutions spanning multiple subject areas and departments (e.g., Clinical, Healthcare Finance, Operations, HR, and Supply Chain)
• Optimization of data warehousing concepts including sustainability, performance, quality control, security, regulatory compliance, and data governance
• Working knowledge of database and ETL technologies, both custom-developed and vendor-packaged
• Experience conceptualizing, visualizing, and communicating complex solution designs with functional and technical audiences across all levels of the organization
• Experience coordinating diverse project teams spanning business/clinical Subject Matter Experts, Developers, Database Administrators, Analysts, Clinicians, and IT Administrators
• Working knowledge of an organization’s core systems and their purpose including data assets, architecture, usage, and quality
• Ability to evaluate, develop, and implement leading business intelligence technologies and principles for data acquisition, transformation, integration, modeling, quality, security, governance, and visualization
• Ability to analyze data and business processes (e.g., Clinical, Financial, HR, Operational, etc) with business partners to develop requirements documentation
• Ability to visualize and document end-to-end business intelligence solutions based on data sources and analytic requirements for functional and technical business partners
• Ability to champion strategic initiatives by identifying tangible project milestones with supporting tasks; identifying risks, dependencies, and prerequisites for an optimized workstream; managing expectations; and coordinating multiple teams to fulfill a common objective
• Working knowledge of data modeling best practices (e.g., denormalization, star schema, snowflake) and data architecture constructs (e.g., data warehouses, operational data stores, data marts, staging areas) to optimize analytics delivery and self-service discovery
• Working knowledge of ETL/ELT tools (e.g., Talend, SSIS) and complex SQL programming
• Ability to manage enterprise-level vendor software upgrades by identifying, planning, and mitigating impacts on data repositories used for analytics and reporting

Nice To Haves

• Demonstrated knowledge of SQL Server-based Kimball data modeling concepts
• Experience with EHR (e.g., Epic, Cerner), ERP (e.g., Workday), and other business systems

Responsibilities

• Formulate and provide direction for the Clinical Data Warehouse, Business Data Warehouse, and other analytics repositories ensuring alignment with strategic priorities and identification of analytics opportunities.
• Through expert knowledge, translate high-level business requirements into data model designs (e.g., conceptual, logical, and physical), processes, and data assets that are well-defined, integrated, reusable, and trusted to empower analytics.
• Provide oversight of cross-functional and technical teams to ensure that Data & Analytics solutions meet business needs with the expected quality of service and adhere to guiding principles and standards associated with usability, data quality, optimization, sustainability, and security.
• Mentor technical developers in data architecture practices to propagate high-quality design, build, and processes to support the strategic data architecture direction.
• Lead complex support services with very little management input, including coordination of Data & Analytics initiatives, data warehouse application software support, system upgrade coordination, and vendor liaison activities.
• Research technology trends/directions, identify and recommend tools and technologies using best practices/industry standards, and identify alternative methods of utilizing data for optimization and elegant problem resolution.
• Take an active role in structuring, creating, and maintaining business intelligence and data warehouse knowledgebase of technical and design artifacts including current- and target-state object and data models and metadata reporting.
• Advise, educate, and assist team members with data quality principles and methods to ensure high-quality data assets.
• Act a positive influence and change agent for compliance within and across teams.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior