Advanced Analytics - Sr Data Architect

Job Title & Specialty Area: Sr Data Architect

Department: Advanced Analytics

Location: Dallas, TX

Shift: Full-Time

Job Type: Remote (Texas Resident Required)

Why Children's Health?

At Children's Health, our mission is to Make Life Better for Children, and we recognize that their health plays a crucial role in achieving this goal.

Through our cutting-edge treatments and affiliation with UT Southwestern, we strive to deliver an extraordinary patient and family experience, ensuring that every moment, big or small, contributes to their overall well-being.

Our dedication to promoting children's health extends beyond our organization and encompasses the broader community. Together, we can make a significant difference in the lives of children and contribute to a brighter and healthier future for all.

Summary:

This role must be able to see how logical design will translate to one or more physical objects/databases and how data will flow through successive stages. The candidate will need to address data migration, validation, cleanup, and mapping, build relational objects/databases, optimize processes for performance, develop strategies for data acquisitions, and demonstrate broad and deep knowledge in a dimensional database environment. Demonstrating excellent data analysis skills using SQL, korn shell, and bat file scripting and working well with others on the team to meet project milestones, managing client satisfaction, and mentoring others on the team and expectations of this role.

Responsibilities:

• Work collaboratively with all levels of business stakeholders to architect, implement, and test data based analytical solutions from disparate sources

• Designs Data Architectures; Develops strategies for data acquisitions

• Architect, design and maintain high-performing ELT/ETL processes

• Work closely with the Users, systems designers, and the developers on a Project team

• Demonstrate an understanding of concepts, best practices, and functions to implement an Enterprise Data solution in a corporate environment

• Conduct business analysis, event modeling, logical and physical database design, database optimization, load strategy design and implementation, security and change management

• Design scalable Enterprise Data Architectures and solutions

WORK EXPERIENCE

• At least 10 years hands-on experience in data extraction, data architecture, database administration, data modeling, data management, and BI, with a heavy focus on data warehousing and ETL technologies. (Required)

EDUCATION

• Four-year Bachelor's degree or equivalent experience (Required)
• Graduate or professional work or advanced degree; or equivalent experience (Preferred)

LICENSES AND CERTIFICATIONS

• Epic certification (Cache Operations, Cogito, Clarity, or Caboodle) or Windows certification (Windows server, Windows OS, Active Directory, or Windows Network Infrastructure) depending on assigned application support (within 180 Days Required)
• Oracle or SQL Server depending on assigned application support (Required)
• Informatica (Preferred)

A Place Where You Belong

We put our people first. We welcome, value, and respect the beliefs, identities and experiences of our patients and colleagues. We are committed to delivering culturally effective care, creating meaningful partnerships in the communities we serve, and equipping and developing our team members to make Children's Health a place where everyone can contribute.

Holistic Benefits - How We'll Care for You:

• Employee portion of medical plan premiums are covered after 3 years.

• 4%-10% employee savings plan match based on tenure

• Paid Parental Leave (up to 12 weeks)

• Caregiver Leave

• Adoption and surrogacy reimbursement

As an equal opportunity employer, Children's Health does not discriminate against employees or applicants because of race, color, religion, sex, gender identity and expression, sexual orientation, age, national origin, veteran or military status, disability, or genetic information or any other Federal or State legally-protected status or class. This applies to all aspects of the employer-employee relationship including but not limited to recruitment, hiring, promotion, transfer pay, training, discipline, workforce adjustments, termination, employee benefits, and any other employment-related activity.