Satellite Healthcare is a successful, nonprofit organization that has improved the lives of people living with kidney disease since 1973. We earn our national reputation for excellent patient care each day by offering a complete range of dialysis therapy choices, personalized clinical services, and unparalleled wellness education.
Satellite Healthcare provides expert, personalized kidney care at over 90 centers across the U.S. as well as at acute dialysis locations in California and Texas. Learn more about Satellite Healthcare at www.satellitehealth.com.
The Sr Data Warehouse Developer works as a senior member of the data warehouse team to promote, enhance, develop, and maintain enterprise data warehouse-related services and solutions that align with business stakeholder requirements and optimize the use of the company's data assets to improve business capabilities. Such services and solutions include, but are not limited to, maintenance of the integrity of the structure and data within the warehouse, implementation and drive toward best performance standards, and design optimization.
Essential Functions The essential functions listed are not a comprehensive inventory of all duties, tasks, and responsibilities. Employees may also perform other duties as assigned. All employees must work in accordance with Satellite's I-CARE Standards.
Clarify, develop, and document requirements and goals for data design, ETL, performance, efficiency, reporting, and analysis to support and align with company goals, strategies, and operational needs
Lead the development of queries, schema, dimensional models, and other analytical data structures for the purposes of identifying business improvement opportunities as well as data issues
Implement and manage ETL processes, including but not limited to SSIS packages, stored procedures, and SQL scripts, to import, translate, and cleanse data
Understand and interface with multiple data sources to create a unified solution that implements enterprise business rules and supports analytical needs
Optimize processes involving large data sets to improve performance
Oversee critical aspects of production environment(s), including but not limited to uptime, performance, deployments, access control, and maintenance
Suggest and implement best practice design and performance mechanisms to achieve best-in-class data warehouse
When appropriate, meet with business stakeholders to lead and facilitate implementation of improved processes and coordinate post-implementation support, including end-user reviews, for modified and new development
Analyze potential data quality issues to determine the root cause and create effective solutions
Deliver high quality projects on time and budget in fast paced environments
Drive the Satellite Healthcare culture through values and customer service standards
Be accountable for outstanding customer service to all external and internal customers
Develop and maintain effective relationships through effective and timely communication
Take initiative and action to respond, resolve and follow up regarding customer service issues with all customers in a timely manner
Minimum Qualifications Any combination of education and experience that would likely provide the required knowledge, skills, and abilities as well as possession of any required licenses or certifications is qualifying.
Education: Bachelor's degree in the field of computer science, information management systems or a related field (or equivalent work experience)
Experience: 10+ years related work experience, with a minimum 8 years' experience at the senior level developing and maintaining an enterprise data warehouse, including writing SSIS packages, SQL queries, and stored procedures
Knowledge, Skills & Abilities:
Advanced experience using Microsoft tools for ETL including SSIS and SQL
Excellent understanding of how data warehouse solutions are designed and constructed
Excellent understanding of performance implications of alternative query designs
Solid experience in technical requirements analysis, dimensional and data modeling
Ability to follow company development practices and coding standards
Ability to effectively prioritize and execute tasks while under pressure
Excellent listening, interpersonal, written, and oral communication skills
Ability to thrive in both individual and team environments
Experience with SSRS is a plus
Experience with clinical (healthcare-related) data is a plus
Microsoft Azure cloud experience is a plus
Able to read, write, speak, understand and satisfactorily communicate with others in English in person, over the phone and via email
Satellite Healthcare – Improving the Lives of Patients with Chronic Kidney Disease (CKD)In 1973, Norman S. Coplon, M.D. began Satellite Healthcare with the objective of improving the quality of life of his dialysis patients. Dr. Coplon established Satellite Healthcare as a not-for-profit, community benefit organization, which allows us to focus primarily on patients.Four decades later, Satellite H...ealthcare has shaped CKD healthcare in our industry, and continues to elevate the standards of patient care and innovation.Today, we provide a range of expert services to patients with chronic kidney disease (CKD). Satellite strives to individualize each patient's care to help him or her enjoy their life to the fullest.Satellite Dialysis — We operate 40 high-quality, state-of-the-art, patient-friendly dialysis centers that meet the long-term clinical needs of more than 4,000 CKD patients.Satellite WellBound — With more than 20 centers in place, we focus on personalized training and support for patients performing dialysis at home. In addition, WellBound provides a robust complement of pre-dialysis patient wellness education programs that can help prevent or slow the progression of early stage CKD.At each of our centers, we put our patients first by providing:Compassionate care with a personalized touchWellness education to empower longer, healthier livesBest clinical practices resulting in outcomes that consistently exceed industry performance standards Opportunities for nephrologists to focus on their patients in comfortable, state-of-the-art environmentsIn addition to patient care, our clinical research division works on finding medical breakthroughs for CKD patients by conducting both internal and external research.For more information, contact Info@SatelliteHealth.com.