Business Intelligence Architect

Note: If you are CURRENTLY employed at Children's and/or have an active badge or network access, STOP here. Submit your application via Workday using the Career App (Find Jobs). Work Shift Day Work Day(s) Monday-Friday Shift Start Time 8:00 AM Shift End Time 5:00 PM Worker Sub-Type Regular Children’s is one of the nation’s leading children’s hospitals. No matter the role, every member of our team is an essential part of our mission to make kids better today and healthier tomorrow. We’re committed to putting you first, and that commitment is at the heart of our company culture: People first. Children always. Find your next career opportunity and make a difference doing what you love at Children’s. Job Description 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. Experience Minimum of 12 years of experience in Business Intelligence, Data Warehousing, and Data Engineering disciplines in an enterprise IT environmentImplementation and oversight of multiple enterprise data warehouses (custom-developed and vendor-packaged) in synchronization and support of organizational initiativesImplementation 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 governanceWorking knowledge of database and ETL technologies, both custom-developed and vendor-packagedExperience conceptualizing, visualizing, and communicating complex solution designs with functional and technical audiences across all levels of the organizationExperience coordinating diverse project teams spanning business/clinical Subject Matter Experts, Developers, Database Administrators, Analysts, Clinicians, and IT Administrators Preferred Qualifications Demonstrated knowledge of SQL Server-based Kimball data modeling conceptsExperience with EHR (e.g., Epic, Cerner), ERP (e.g., Workday), and other business systems Education Bachelor's degree in Computer Science, Information Technology, related field, or equivalent technical training and experience Certification Summary No professional certifications required Knowledge, Skills, And Abilities Working knowledge of an organization’s core systems and their purpose including data assets, architecture, usage, and qualityAbility to evaluate, develop, and implement leading business intelligence technologies and principles for data acquisition, transformation, integration, modeling, quality, security, governance, and visualizationAbility to analyze data and business processes (e.g., Clinical, Financial, HR, Operational, etc) with business partners to develop requirements documentationAbility to visualize and document end-to-end business intelligence solutions based on data sources and analytic requirements for functional and technical business partnersAbility 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 objectiveWorking 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 discoveryWorking knowledge of ETL/ELT tools (e.g., Talend, SSIS) and complex SQL programmingAbility to manage enterprise-level vendor software upgrades by identifying, planning, and mitigating impacts on data repositories used for analytics and reporting Job 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. Children’s Healthcare of Atlanta is an equal opportunity employer committed to providing equal employment opportunities to all qualified applicants and employees without regard to race, color, sex, religion, national origin, citizenship, age, veteran status, disability or any other characteristic covered by applicable law. Primary Location Address 1575 Northeast Expy NE Job Family Business Intelligence