Data Engineer

Ascend Learning, LLC; Leawood (KS); Hybrid; USD 80,000 - 110,000; Full time

Benefits offered by this job

Flexible and generous paid time off

401(k) employer matching program

Tuition reimbursement

Wellness resources

Job summary

Ascend Learning, LLC is looking for a Data Engineer responsible for designing and maintaining data pipelines and architectures. You will collaborate with data scientists and analysts to support data-driven decision-making. This position is hybrid, based in Leawood, KS or Burlington, MA, with remote options available in the United States.

The ideal candidate will have a Bachelor's degree and a strong background in data warehousing, SQL Server, and Snowflake, with experience in ETL tools and cloud platforms.

Qualifications

• Bachelor's degree in Computer Science or related field preferred.
• 3+ years of experience in a data engineering role.
• Proficient with SQL Server and Snowflake for data management.
• Strong problem-solving and analytical skills.

Responsibilities

• Design and implement data models and schemas in SQL.
• Maintain data quality and consistency across the organization.
• Collaborate with stakeholders to understand data requirements.
• Monitor and troubleshoot data pipelines and databases.

Skills

Data warehousing and ETL processes

SQL Server

Snowflake

Kafka

Azure Data Factory

Python

Java

Data governance and security

Data modeling

Data visualization tools

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

ETL tools (ADF, SSIS)

Cloud platforms (AWS, Azure, Google Cloud)

Job description

As a 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 data scientists, analysts, and other stakeholders to support advanced analytics initiatives and contribute to our overall data strategy.

WHERE YOU’LL WORK

• This position will work a hybrid schedule from our Leawood, KS or Burlington, MA office location preferred. Remote will be considered within the United States.

HOW YOU’LL SPEND YOUR TIME

• Design and implement data models, schemas, and structures in SQL Server, Snowflake, and other technologies to support efficient data storage and retrieval.
• Implement and maintain enterprise data warehouse methodologies to ensure data quality and consistency across the organization.
• 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, translate them into technical solutions, and deliver data solutions that meet business needs.
• Monitor and troubleshoot data pipelines and databases to ensure data availability and resolve any issues or bottlenecks.
• Enforce data governance policies to ensure compliance with data privacy regulations and company standards.
• Enhance data visibility and observability across the organization by implementing monitoring, logging, and alerting systems to proactively identify and address data-related issues.
• Stay up-to-date with emerging technologies and industry trends to drive innovation within the data team.

WHAT YOU'LL NEED

• Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field preferred. Equivalent work experience required.
• Minimum of 3 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, writing SQL queries, 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, and experience in deploying and managing data solutions on these platforms.
• Understanding of data governance, data security, and compliance regulations.
• Strong problem-solving and analytical skills, with the ability to identify and resolve data engineering issues.
• Strong communication skills and the ability to convey complex technical concepts to non-technical stakeholders.
• 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

Fostering A Sense of Belonging

We seek out and celebrate all people and perspectives and cultivate an inclusive culture where everyone can thrive, feel valued and be their authentic selves. 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.