Sr. Data Engineer

WellSky•Overland Park, KS

2d•Onsite

About The Position

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 to solve business problems or assigned tasks in coordination with multiple teams. Develop and maintain data solutions to enable new or existing solutions and BI development for the data warehouse and data visualization solutions. 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 expertise 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: Experience with Snowflake data warehouse development and management 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 (or similar CDC/replication technologies) Experience supporting BI/reporting environments such as Tableau through well-modeled, performant datasets Healthcare industry experience Job Expectations: Willing to work additional or irregular hours as needed 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. WellSky 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. Here are some of the exciting benefits full-time teammates are eligible to receive at WellSky: Excellent medical, dental, and vision benefits Mental health benefits through TelaDoc Prescription drug coverage Generous paid time off, plus 13 paid holidays Paid parental leave 100% vested 401(K) retirement plans Educational assistance up to $2500 per year WellSky is a technology company leading the movement for intelligent, coordinated care worldwide. Our next-level software, analytics, and services power better outcomes and lower costs for stakeholders across the health and community care continuum. In today’s value-based care environment, WellSky helps providers, payers, health systems, and community organizations solve tough challenges, improve collaboration for growth, harness the power of data analytics, and achieve better outcomes by further connecting clinical and social care.

Requirements

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

Nice To Haves

Experience with Snowflake data warehouse development and management
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 (or similar CDC/replication technologies)
Experience supporting BI/reporting environments such as Tableau through well-modeled, performant datasets
Healthcare industry experience

Responsibilities

Create, develop, maintain, and leverage data pipelines, data models, reporting, and dashboards to solve business problems or assigned tasks in coordination with multiple teams.
Develop and maintain data solutions to enable new or existing solutions and BI development for the data warehouse and data visualization solutions.
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 expertise 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.