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.
Similar Jobs
What We Do
Headquartered in Santa Clara, California, and backed by renowned private equity firms Advent International and Warburg Pincus, Encora is the preferred technology modernization and innovation partner to some of the world’s leading enterprise companies. It provides award-winning digital engineering services including Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering. Encora's deep cluster vertical capabilities extend across diverse industries, including HiTech, Healthcare & Life Sciences, Retail & CPG, Energy & Utilities, Banking Financial Services & Insurance, Travel, Hospitality & Logistics, Telecom & Media, Automotive, and other specialized industries.
With over 9,000 associates in 47+ offices and delivery centers across the U.S., Canada, Latin America, Europe, India, and Southeast Asia, Encora delivers nearshore agility to clients anywhere in the world, coupled with expertise at scale in India. Encora’s Cloud-first, Data-first, AI-first approach enables clients to create differentiated enterprise value through technology
