Data Engineer

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.