Business Intelligence Architect

10 Children's Healthcare of Atlanta, Inc.; United States; On-site; USD 140,000 - 190,000; Full time

Job summary

Children’s Healthcare of Atlanta seeks a senior BI/Data Warehouse expert to shape enterprise analytics. You will own data model design, ETL pipelines, and governance, guiding cross-functional teams to deliver trusted data assets for analytics. Strong communication will be required to align clinical, financial, and operational data initiatives.

You will mentor staff, coordinate system upgrades, and drive scalable architectures across data warehouses and marts.

Qualifications

• Minimum 12 years in BI, data warehousing, and data engineering in enterprise IT.
• Experience overseeing multiple enterprise data warehouses and data models across departments.
• Knowledge of denormalization, star/snowflake schemas, governance, and security.

Responsibilities

• Direct Clinical and Business Data Warehouse initiatives aligned with strategy.
• Translate requirements into data models, processes, and reusable assets.
• Oversee cross-functional teams to deliver high-quality Data & Analytics solutions.
• Mentor developers in data architecture and best practices.
• Coordinate vendor upgrades and manage analytics tool integrations.
• Develop and maintain BI artifacts, metadata, and data models.

Skills

SQL

Data Modeling

Data Warehousing

ETL

Leadership

Education

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

Tools

Talend

SSIS

Job description

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

Children’s Healthcare of Atlanta has been 100 percent committed to kids for more than 100 years. A not-for-profit organization, Children’s is dedicated to making kids better today and healthier tomorrow. With 3 hospitals, 20 neighborhood locations and a total of 673 beds, Children’s is the largest healthcare provider for children in Georgia and one of the largest pediatric clinical care providers in the country. Children’s offers access to more than 60 pediatric specialties and programs and is ranked among the top children’s hospitals in the country by U.S. News & World Report. Children’s has been recognized as a Fortune 100 Best Place to Work, a Best Place for Working Mothers, and as a top employer for diversity and millennials.

We offer a comprehensive compensation and benefit package that supports our mission, vision and values. We are proud to offer an array of programs and services to our employees that have distinguished us as a best place to work in the country.

Connect to our mission of making kids better today and healthy l. Have questions about the recruitment process? Check out What to Expect. https://careers.choa.org/lp/What%20to%20Expect/2895392d3ba166e6/?locale=en_US