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

Work Day(s)

Shift Start Time

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.

• 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

• 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

• Bachelor's degree in Computer Science, Information Technology, related field, or equivalent technical training and experience

• No professional certifications required

• 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

• →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.