Sr. Data Engineer

The Sr Data Engineer is responsible for designing, building, and maintaining scalable data pipelines, infrastructure, and data visualization to support our data-driven decision-making processes. The scope of this job includes collaborating with data scientists, analysts, solutions partners, and other stakeholders to increase data quality, accessibility, and security. Key Responsibilities:Create, develop, maintain, and leverage data pipelines, data models, reporting, and dashboards on GCP and BigQuery to solve business problems or assigned tasks in coordination with multiple teams. Develop and maintain semantic models and reporting in Looker (LookML) so business users can answer questions without writing SQL. Support operational data pipelines by troubleshooting and resolving production issues, including file processing failures, data quality anomalies, and integration errors. Enhance and document workflows for complex data-related challenges by identifying patterns, trends, and anomalies in the data, and find ways to optimize data processing and storage to promote data quality through automation. Develop understanding of different WellSky solutions and become a subject matter expert in the healthcare domain. Identify opportunities in code reviews and contribute to the development of best practices and coding standards. Adhere to WellSky core values, ensure PHI data security, and adapt to changing BI technologies. Leverage AI tools and platforms as an integral part of daily responsibilities to enhance decision-making, streamline workflows, and drive data-informed outcomes. Perform other job duties as assigned. Required Qualifications:Bachelor’s degree or relevant work experience 4-6 years of relevant work experience Strong SQL skills with hands-on experience developing and supporting 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 within GCP environments Preferred Qualifications:Direct Looker and LookML development experience Experience with DBT for ELT/ETL processes, data modeling, testing, and documentation GCP expertise, especially with 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 through well-modeled, performant datasets, including migrating reporting from one BI platform to another Git-based development workflow, including pull requests, code review, and CI/CD Python for data engineering, tooling, and automation Healthcare industry experience Job Expectations:Willing to work additional or irregular hours as needed to support scheduled data loads, releases, and time-sensitive production issues Must work in accordance with applicable security policies and procedures to safeguard company and client information Must be able to sit and view a computer screen for extended periods of time #LI-TC1 #LI-Onsite WellSky is where independent thinking and collaboration come together to create an authentic culture. We thrive on innovation, inclusiveness, and cohesive perspectives. At WellSky you can make a difference.Here are some of the exciting benefits full-time teammates are eligible to receive at WellSky:Excellent medical with Rx, dental, and vision benefitsMental Health support through EAPGenerous paid time off, plus 13 paid holidays100% vested 401(K) retirement plansEducational assistance up to $2500 per yearWellSky provides equal employment opportunities to all people without regard to race, color, national origin, ancestry, citizenship, age, religion, gender, sex, sexual orientation, gender identity, gender expression, marital status, pregnancy, physical or mental disability, protected medical condition, genetic information, military service, veteran status, or any other status or characteristic protected by law. WellSky is proud to be a drug-free workplace.Applicants for U.S.-based positions with WellSky must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. Certain client-facing positions may be required to comply with applicable requirements, such as immunizations and occupational health mandates.Data Privacy Notice for Job Applicants and TeammatesSummaryLocation: Overland Park, KSType: Full time