Business Intelligence Architect

choa; Atlanta (GA); On-site; USD 120,000 - 180,000; Full time

Job summary

Children’s Healthcare of Atlanta seeks a seasoned BI and Data Warehouse leader to drive the analytics delivery lifecycle across clinical, financial, and operations domains. You will shape data architectures and ensure trusted data assets.

Responsibilities include enterprise data modeling, governance, quality, mentoring analytics teams, and partnering with IT and business stakeholders to translate requirements into scalable analytics solutions that empower decision-making.

Qualifications

• Minimum 12 years in BI, DW, and data engineering in an enterprise IT environment.
• Experience overseeing multiple enterprise data warehouses and data models.
• Strong knowledge of data modeling concepts (star/snowflake) and governance.
• Ability to translate complex requirements into scalable analytics solutions.
• Experience leading cross-functional teams and collaborating with clinicians, IT, and business partners.

Responsibilities

• Lead the Clinical and Enterprise Data Warehouse strategy and delivery.
• Translate requirements into conceptual, logical, and physical data models.
• Provide oversight of analytics solutions ensuring quality, usability, and security.
• Mentor developers and analysts to propagate best practices in data architecture.
• Coordinate vendor/IT activities for upgrades and analytics initiatives.

Skills

Data warehousing

BI leadership

Data governance

Stakeholder management

ETL development

SQL / data modeling

Mentoring

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

Talend

SSIS

SQL Server

Workday

Epic/Cerner

Job description

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 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

Preferred Qualifications

• 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

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 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

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