Senior Data Engineer (Leawood, KS, US, 66211)

We Impact Lives Through Purpose-Driven Work in A People First Culture Ascend Learning, a leading healthcare and learning technology company, is the connection between a powerful portfolio of brands serving students, educators, and employers with outcomes-based, data-driven solutions across the lifecycle of learning. From testing to certification, Ascend Learning products are used by physicians, emergency medical professionals, nurses, allied health professionals, certified personal trainers, financial advisors, skilled trades professionals and insurance brokers. Headquartered in Burlington, MA, with additional office locations and hybrid and remote workers in cities across the U.S., Ascend Learning was recognized by Newsweek and Plant-A Insights Group as one of America’s 2025 Greatest Workplaces as well as America’s Best Places to work for Mental Well-Being for 2025. We're always looking for talented, passionate professionals to join us in our mission to help change lives. If this sounds like an environment where you'd thrive, read on to learn more. WHAT YOU'LL DO As a Senior Data Engineer, you will be responsible for designing, building, and maintaining scalable and robust data pipelines and architectures. You will play a critical role in enabling data-driven decision-making by ensuring the availability, integrity, and performance of our data systems. You will work closely with business intelligence team, data scientists, and other stakeholders to support advanced analytics initiatives and contribute to our overall data strategy. WHERE YOU’LL WORK This position has the flexibility of remote work in the United States. HOW YOU’LL SPEND YOUR TIME Design and optimize complex data models, schemas, and storage structures across SQL Server, Snowflake, and other platforms to maximize performance, scalability, and data accessibility. Lead the implementation and continuous improvement of enterprise-wide data warehouse strategies, ensuring data integrity, consistency, and alignment with organizational standards. Design, develop, and maintain robust, scalable ETL/ELT pipelines leveraging SQL Server, Kafka, Azure Data Factory, Snowflake, and complementary technologies to support high-volume, real-time, and batch data processing. Partner closely with business intelligence teams, data scientists, analysts, and key stakeholders to gather detailed requirements, translate them into scalable technical solutions, and deliver actionable data assets that drive business outcomes. Collaborate with the data architecture team to define and implement scalable, high-performance data infrastructure and solutions aligned with enterprise data strategy. Proactively monitor, troubleshoot, and optimize data pipelines and database systems to ensure high availability, reliability, and minimal latency, swiftly addressing any bottlenecks or failures. Define, enforce, and champion data governance frameworks, ensuring compliance with data privacy regulations, security policies, and organizational standards. Drive enhanced data observability by implementing comprehensive monitoring, logging, and alerting mechanisms to enable proactive identification and resolution of data quality and pipeline issues. Stay abreast of emerging data engineering technologies, tools, and industry best practices to continuously innovate and improve data platform capabilities. Provide technical leadership and mentorship to junior data engineers, fostering a culture of excellence, knowledge sharing, and adherence to best practices in data engineering and management. WHAT YOU'LL NEED High school diploma or GED required. Bachelor’s degree in computer science, software engineering, information technology, or a related field or relevant work experience preferred 6+ years of experience in a data engineering role with a strong focus on data warehousing and ETL processes Skilled in SQL Server, MySQL, and Snowflake. Design data models, write SQL queries, and optimize database performance. Experienced in building ETL pipelines using Azure Data Factory, SSIS, and Kafka for data integration and transformation. Strong background in real-time data processing with Kafka and streaming technologies. Knowledgeable in data warehouse design, data modeling, and database best practices. Proficient in Python and Java for scripting and automating data workflows. Hands-on experience with Azure Cloud Services like Azure Data Factory, Azure Databricks, and Azure SQL Database. Deploy and manage scalable data solutions on Azure. Familiar with cloud infrastructure, automation, and security best practices to ensure reliable and secure data systems. Understand data governance, data security, and compliance standards such as GDPR and HIPAA. Strong problem-solving skills to quickly identify and fix data engineering issues. Good communication skills to explain technical details clearly to both technical teams and business users. Experience with RESTful APIs for integrating data systems. Comfortable with additional programming languages like Scala and advanced Python. Familiar with data visualization and BI tools to help deliver clear insights. BENEFITS Flexible and generous paid time off Competitive medical, dental, vision and life insurance 401(k) employer matching program Parental leave Wellness resources Charitable matching program On-site workout facilities (Leawood, Gilbert, Burlington) Community outreach groups Tuition reimbursement Fostering A Sense of Belonging Our values-driven culture unifies our teams and inspires a mindset of action, innovation, and collaboration, with a relentless focus on customers. We seek out and celebrate all people and perspectives and cultivate an inclusive culture where everyone can thrive, feel valued, and be authentic. Our culture is firmly rooted in the belief that by embracing our differences and drawing on diverse perspectives, we are a stronger, more innovative, and more successful organization where employees experience a sense of belonging. Ascend Learning, LLC is proud to be an equal opportunity employer (M/F/Vets/Disabled). No agency or search firm submissions will be accepted. Applications for U.S.-based positions with Ascend Learning, LLC must be legally authorized to work in the United States, and verification of employment eligibility will be required at the time of hire.