Wellsky is seeking a Sr. Data Engineer to design, build, and maintain scalable data solutions on GCP.

Develop, maintain, and optimize data pipelines, data models, reporting, and dashboards using GCP and BigQuery to support business needs and assigned tasks across multiple teams
Build and maintain semantic models and reporting in Looker using LookML so business users can answer questions without writing SQL
Operate and troubleshoot production data pipelines, resolving issues such as file processing failures, data quality anomalies, and integration errors
Improve and document workflows for complex data challenges by identifying patterns, trends, and anomalies and by optimizing data processing and storage through automation to support data quality
Increase understanding of WellSky solutions and develop subject matter expertise in the healthcare domain
Participate in code reviews, identify improvement opportunities, and help establish best practices and coding standards
Follow Wellsky core values, ensure PHI data security, and adjust to evolving BI technologies
Use AI tools and platforms as part of daily work to support decision-making, streamline workflows, and drive data-informed outcomes
Perform other duties as assigned

Bachelor’s degree or relevant work experience
4-6 years of relevant work experience
Strong SQL skills, including hands-on development and support of data pipelines and data warehouse solutions
Experience with SQL Server data integration and ETL development, including SSIS or equivalent
Experience with cloud-based data platforms and services, preferably in GCP environments

Direct experience developing in Looker and LookML
Experience with DBT for ELT/ETL, including data modeling, testing, and documentation
GCP expertise, especially Cloud SQL, BigQuery, and Datastream
Experience with data replication tools such as HVR, Datastream, or Fivetran (or similar CDC/replication technologies)
Experience supporting BI/reporting environments such as Looker or Tableau with well-modeled, performant datasets, including migrating reporting between BI platforms
Git-based workflows, including pull requests, code review, and CI/CD
Python for data engineering, tooling, and automation
Healthcare industry experience

Willing to work additional or irregular hours to support scheduled data loads, releases, and time-sensitive production issues
Must follow applicable security policies and procedures to safeguard company and client information
Ability to sit and view a computer screen for extended periods

Location: Overland Park, KS (onsite)

Sr. Data Engineer

Job Description