Provide sustained reporting and data support for capacity management and patient flow initiatives
Compensation
Pay Range Minimum: $120,000.00 annual
Pay Range Maximum: $146,808.00 annual
Responsibilities
Provide sustained reporting and data support for capacity management and patient flow initiatives
Serve as a key partner with operational stakeholders, translating requirements into actionable dashboards, reports, and data insights
Focus on development and optimization of analytics tools supporting decision-making, capacity monitoring, and patient throughput
Provide the analytic foundation needed for operational teams to take action to improve patient flow and hospital capacity
Collaborate with Analytics leadership, Business Analysts, application analysts, and hospital Patient Flow stakeholders to gather, document, and confirm business requirements
Requirements
Bachelor’s degree in Computer Science, Health Information Systems, Math, Information Technology, Business Administration, or related field or equivalent combination of experience/education
Design, build, test, and support scalable data platforms and pipelines for financial services clients.
Locations (3)
Dallas, Texas, United States
San Antonio, Texas, United States
Raleigh, North Carolina, United States
Compensation
The base salary range for this job is: New York City, Boston, and Washington DC Metro Areas, Washington State, and Southern California offices – $78,600 to $146,100 Bay Area California offices – $81,900 to $152,100 All other offices locations in the US, including Sacramento – $65,500 to $134,000
Responsibilities
Build resilient batch and streaming pipelines
Design data models and cloud data applications
Apply data quality standards and observability
Own workstreams from design through production support
Collaborate across product, engineering, testing, and operations teams
Build and maintain the data platform behind Kindsight's customer-facing analytics products, ingesting data from customer Salesforce environments into an AWS data lake and transforming it through a dimensional data warehouse that powers dashboards and AI-driven insights.
Build and maintain ELT pipelines that ingest data from customer Salesforce environments into our AWS data lake, covering both scheduled batch loads and near-real-time change data capture.
Develop data transformation layers (medallion architecture) and dimensional models in dbt on Redshift or Snowflake, implementing incremental logic, slowly changing dimensions, and derived metrics against defined specifications.
Write and optimize advanced SQL for transformation, aggregation, and data quality validation across large, multi-tenant datasets.
Work hands-on with AWS: S3, Glue, Athena, Redshift, Step Functions, Lambda, IAM, Lake Formation, and CloudWatch.
Onboard new customer data sources by extending existing configuration-driven pipelines, and verify each onboarding against defined acceptance criteria.
Requirements
Bachelor's degree in Computer Science, Data Science, Engineering, or a related field, or equivalent practical experience.
Nice to have: Salesforce REST API
Nice to have: Salesforce Bulk API
Nice to have: Salesforce Change Data Capture
Requirements
Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field
