Offer summary

Qualifications:

6+ years of experience as a Data Engineer or in a similar backend development role., Expertise in SQL Server and SSIS for designing and optimizing ETL workflows., Proficient in JavaScript and TypeScript, with experience in building RESTful APIs using Express.js., Strong understanding of relational databases, particularly MSSQL or PostgreSQL, and ORM structures..

Key responsibilities:

Design, develop, and maintain ETL processes using SSIS and SQL Server.

Build and optimize RESTful APIs to support data services and integrations.

Analyze and transform complex SQL queries for performance and reliability.

Collaborate with stakeholders to understand data needs and deliver robust data solutions.

Job description

Important Information

Experience: +6 years

Job Mode: Full-time

Work Mode: Work from home

Job Summary

We are looking for a Senior Data Engineer with at least 6 years of experience who is passionate about building efficient data pipelines and integrating backend systems. The ideal candidate is well-versed in SQL Server, SSIS, and has solid software development experience with JavaScript, TypeScript, and Express.js, particularly in the context of building and optimizing RESTful APIs. This role also demands a strong understanding of MSSQL or PostgreSQL, with the ability to work on complex queries and translate them into scalable ORM-based logic.

Responsibilities and Duties

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.

Qualifications and Skills

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.

About Encora

Encora is a global company that offers Software and Digital Engineering solutions. Our practices include Cloud Services, Product Engineering & Application Modernization, Data & Analytics, Digital Experience & Design Services, DevSecOps, Cybersecurity, Quality Engineering, AI & LLM Engineering, among others.

At Encora, we hire professionals based solely on their skills and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.

Required profile