Data Engineer

Ascend Learning - Leawood, KS

Full-time - Mid Level

Remote - Leawood, KS

Management of Companies and Enterprises

About the position

As a 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, and Snowflake.
• Collaborate with business intelligence, data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions.
• Monitor and troubleshoot data pipelines and databases to ensure data availability and resolve issues.
• 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.

Requirements

• 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 focus on data warehousing and ETL processes.
• Proficient with SQL Server, MYSQL, and Snowflake, including designing and implementing data models and writing SQL queries.
• Proficient in ETL tools like ADF, SSIS, and Kafka for data integration and transformation.
• Strong experience with real-time data processing and streaming technologies such as Kafka.
• Solid understanding of data warehouse methodologies, 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 to convey complex technical concepts to non-technical stakeholders.

Nice-to-haves

• Familiarity with RESTful API development and integration.
• 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
• Community outreach groups
• Tuition reimbursement