Customer Experience Reporting and Analytics Senior Developer
DaVita Kidney Care
Summary
Serves as a lead technical authority and subject matter expert responsible for the architectural design, development, and end-to-end optimization of enterprise data solutions, analytical models, and reporting infrastructure supporting DaVita's Customer Experience (CX) and IT Service Management ecosystems. Lead the transformation of complex business requirements into high-performance SQL views, analytical data structures, and executive-ready Tableau analytics suites.
Job description
General Purpose of the Job
Serves as a lead technical authority and subject matter expert responsible for the architectural design, development, and end-to-end optimization of enterprise data solutions, analytical models, and reporting infrastructure supporting DaVita's Customer Experience (CX) and IT Service Management ecosystems. Lead the transformation of complex business requirements into high-performance SQL views, analytical data structures, and executive-ready Tableau analytics suites.
Essential Duties & Responsibilities
- Architect, implement, and maintain complex SQL queries and optimized analytical views for contact center, ticketing, and operational reporting
- Design and maintain optimized SQL views and reporting tables for high-concurrency analytical querying and Tableau visualization
- Define and enforce database development standards, modular SQL design patterns, and naming conventions
- Monitor, diagnose, and optimize query execution plans, indexing strategies, and server resource utilization
- Conduct root-cause investigations on long-running queries and refactor legacy stored procedures
- Implement data partitioning, indexing architectures, and aggregation strategies
- Architect and manage enterprise-grade published Tableau data sources, data models, and interactive dashboards
- Optimize workbook performance through data connection design, extract schedules, LOD expressions, and dashboard rendering
- Serve as lead technical liaison translating business requirements into scalable technical designs
- Play an active technical leadership role in Agile/Scrum ceremonies
- Lead peer code reviews and establish standardized QA test harnesses
- Provide technical mentorship for Developer I/II and Analyst teammates
- Maintain technical documentation including data dictionaries, data lineage maps, and operational runbooks
- Build and maintain Python and PowerShell automation scripts for data reconciliation and validation
- Champion modern DevOps practices including Git-based version control and database change management
Minimum Qualifications
- Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Analytics, or related field (or equivalent progressive professional experience)
- 5+ years of progressive professional experience in advanced SQL engineering (T-SQL / Microsoft SQL Server) and relational database modeling
- 3+ years of hands-on experience designing, deploying, and optimizing enterprise Tableau dashboards and published data models
- Proven track record of query tuning, index optimization, and execution plan analysis
- Expert proficiency in T-SQL (CTEs, window functions, complex joins, indexing strategies, dynamic SQL, stored procedures)
- Solid proficiency in Python for data manipulation, reconciliation, and workflow automation
- Deep understanding of relational database design principles and analytical query optimization
- Demonstrated ability to articulate complex technical architectures to technical and non-technical leaders
- Strong project management and prioritization skills within Agile sprint cycles
Preferred Qualifications
- Domain knowledge of contact center operational telemetry and KPI frameworks (NICE CXone, telephony/IVR flows, AHT, FCR, ASA, CSAT, SLA adherence)
- Hands-on experience with ServiceNow ITSM / CSM data schemas
- Experience with Microsoft SQL Server SQL database environments (Snowflake) and modern database CI/CD deployment practices (Bitbucket)
- Demonstrated experience establishing data quality frameworks and automated testing scripts
Requirements
- Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Analytics, or related field (or equivalent progressive professional experience)
- 5+ years of progressive professional experience in advanced SQL engineering (T-SQL / Microsoft SQL Server) and relational database modeling
- 3+ years of hands-on experience designing, deploying, and optimizing enterprise Tableau dashboards and published data models
- Proven track record of query tuning, index optimization, and execution plan analysis in high-volume relational database environments
- Expert proficiency in T-SQL (CTEs, window functions, complex joins, indexing strategies, dynamic SQL, stored procedures)
- Solid proficiency in Python for data manipulation, reconciliation, and workflow automation
- Deep understanding of relational database design principles, analytical query optimization, and reporting data structures
- Demonstrated ability to articulate complex technical architectures and trade-offs to technical and non-technical business leaders
- Strong project management and prioritization skills within fast-paced Agile sprint cycles
Benefits
- Medical, Dental & Vision
- 401(k) Matching
- Paid Time Off
- PTO Cash Out
- Family Resources
- EAP Counseling
- Headspace Access
- Backup Child & Elder Care
- Maternity/Paternity Leave
- Professional Development Programs
Company overview
DaVita Kidney Care is a leading American healthcare provider specializing in kidney dialysis services, operating as one of the largest dialysis companies in the United States. Founded in 1992 and headquartered in Denver, Colorado, DaVita operates a vast network of 2,675 outpatient dialysis centers across the United States, serving approximately 200,800 patients, with an additional 367 centers in 11 other countries serving 49,400 patients. The company primarily treats end-stage renal disease (ESRD), providing life-sustaining dialysis treatments that patients typically require three times per week. DaVita holds approximately 37% market share in the U.S. dialysis market and is publicly traded on the New York Stock Exchange under the ticker DVA. The company's name, derived from the Italian phrase "Dare Vita" meaning "to give life," reflects its mission to provide essential kidney care services. With approximately 76,000 employees, DaVita has established itself as a Fortune 500 company and a significant player in the healthcare industry, with Berkshire Hathaway owning a 41.2% stake in the organization.