Sr Data Engineer

Ascend Learning - Leawood, KS

Full-time - Mid Level

Remote - Leawood, KS

Management of Companies and Enterprises

About the position

As a Senior Data Engineer at Ascend Learning, you will be responsible for designing, building, and maintaining scalable and robust data pipelines and architectures. This role is critical in enabling data-driven decision-making by ensuring the availability, integrity, and performance of data systems. You will collaborate with data scientists, analysts, and other stakeholders to support advanced analytics initiatives and contribute to the overall data strategy.

Responsibilities

• Design and implement data models, schemas, and structures in SQL Server, Snowflake, and other technologies.
• Implement and maintain enterprise data warehouse methodologies to ensure data quality and consistency.
• Design, develop, and maintain scalable data pipelines using SQL Server, Kafka, Azure Data Factory, Snowflake, and other relevant technologies.
• Collaborate with business intelligence, data scientists, analysts, and other stakeholders to understand their data requirements and deliver data solutions.
• Work with the data architecture team to design and implement scalable and performant data solutions.
• Monitor and troubleshoot data pipelines and databases to ensure data availability and resolve issues.
• Establish and enforce data governance policies to ensure compliance with data privacy regulations.
• Enhance data visibility and observability by implementing monitoring, logging, and alerting systems.
• Stay up-to-date with emerging technologies and industry trends to drive innovation.
• Mentor junior data engineers and promote best practices in data engineering.

Requirements

• Bachelor's or Master's degree in Computer Science, Engineering, Information Technology, or a related field preferred.
• Minimum of 6 years of experience in a data engineering role with a strong focus on data warehousing and ETL processes.
• Proficient with SQL Server, MYSQL and Snowflake, including designing and implementing data models and optimizing performance.
• Proficient in ETL tools like ADF, SSIS, Kafka Messaging data integration and transformation.
• Strong experience with real-time data processing and streaming technologies such as Kafka.
• Solid understanding of data warehouse methodologies and best practices, data modeling, and database design principles.
• Knowledge of programming languages such as Python or Java for scripting and automation.
• Familiarity with cloud platforms like AWS, Azure, or Google Cloud.
• Understanding of data governance, data security, and compliance regulations.
• Strong problem-solving and analytical skills.
• Strong communication skills and the ability to convey complex technical concepts to non-technical stakeholders.

Nice-to-haves

• Familiarity with RESTful API development and integration.
• Experience with additional programming languages (e.g., Python, Java, Scala).
• Experience with data visualization tools and BI platforms.
• Knowledge of machine learning and advanced analytics techniques.
• Certifications in relevant technologies (e.g., Microsoft Azure, Snowflake).

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
• Hybrid work
• On-site workout facilities (Leawood, Gilbert, Burlington)
• Community outreach groups
• Tuition reimbursement