Data Engineer

Summary

Join Encora as a Senior Data Engineer with 6+ years of experience in building efficient data pipelines and integrating backend systems. You will design, develop, and maintain ETL processes using SSIS and SQL Server, build and optimize RESTful APIs using JavaScript/TypeScript and Express.js, and work with large datasets to analyze and optimize complex SQL queries. This role requires expertise in SQL Server and SSIS, proficiency in JavaScript and TypeScript, and experience building RESTful APIs using Express.js. Strong understanding of relational databases (MSSQL or PostgreSQL) and skills in query optimization and translating SQL logic into ORM structures are essential. Collaboration with data analysts, software engineers, and business stakeholders is also a key aspect of this position.

Requirements

• 6+ years of professional experience as a Data Engineer or in a similar backend development role
• Expertise in SQL Server and SSIS, with the ability to design and optimize complex ETL workflows
• Proficient in JavaScript and TypeScript development
• Experience building RESTful APIs using Express.js
• Strong understanding of relational databases, especially MSSQL or PostgreSQL
• Skilled at query analysis, optimization, and translating SQL logic into ORM structures (e.g., Sequelize, TypeORM, Prisma)
• Solid understanding of software development best practices, version control, and Agile methodologies
• Excellent problem-solving skills and attention to detail
• Strong communication and collaboration abilities

Responsibilities

• Design, develop, and maintain ETL processes using SSIS and SQL Server
• Build and optimize RESTful APIs using JavaScript/TypeScript and Express.js to support data services and integrations
• Work with large datasets to analyze, optimize, and transform complex SQL queries, ensuring performance and reliability
• Translate intricate SQL logic into clean, maintainable ORM-based implementations
• Ensure high data quality, integrity, and availability across multiple systems and environments
• Collaborate with data analysts, software engineers, and business stakeholders to understand data needs and deliver robust data solutions
• Implement and maintain best practices for data pipeline architecture, error handling, and system scalability
• Participate in code reviews, system design discussions, and contribute to architectural decisions