Senior Data Engineer

Aubrant Digital

Senior Data Engineer at Aubrant Digital designing and tuning the data layer for mission-critical applications on Azure. Collaborating with teams to deliver high-throughput, low-latency data solutions.

Posted 5/8/2026full-timeMassachusetts, New Jersey • 🇺🇸 United StatesSeniorWebsite

Tech Stack

Tools & technologies

AzureEntity Framework.NETPythonSQL

About the role

Key responsibilities & impact

Design and maintain SQL Server 2019+ schemas, indexes, and query patterns that meet performance, scalability, and concurrency requirements.
Analyze execution plans, identify bottlenecks, and tune queries, indexes, and statistics; advise on RCSI and isolation level choices.
Design and operate Change Data Capture (CDC) pipelines and other change-tracking patterns to support downstream consumers.
Implement and review data access using linq2db, LINQ-to-SQL (DBML), Entity Framework, and ADO.NET; choose the right tool for each scenario.
Translate business and application requirements into efficient SQL and C# data access code that is performant, testable, and maintainable.
Partner with application engineers to align ORM usage with database performance characteristics and avoid common anti-patterns.
Design and operate data solutions on Azure, including Azure SQL, storage, networking, and security configurations.
Contribute to CI/CD for database changes through migration scripts, schema versioning, and automated deployments.
Mentor engineers on database design, query optimization, and data access patterns; set standards for the team.

Requirements

What you’ll need

Bachelor's Degree in Computer Science or a related discipline, or equivalent experience; MUST be proficient in written and spoken English (85%).
5 to 8 years of professional data engineering or back-end engineering experience with a strong database focus.
Expert-level proficiency in SQL on SQL Server 2019+, including complex queries, window functions, set-based operations, query plan analysis, indexing strategy, statistics, RCSI, isolation levels, and Change Data Capture.
Expert-level proficiency in database performance tuning , including bottleneck identification, index design, query rewrites, and concurrency design under production load.
Strong proficiency in C# data access using linq2db, LINQ-to-SQL (DBML), Entity Framework, and ADO.NET; ability to choose the appropriate tool for each scenario and avoid ORM performance pitfalls.
Strong proficiency in Python for data engineering tasks, scripting, and automation.
Hands-on experience with Azure data services (Azure SQL, storage, networking, security) and deploying production data workloads in Azure.
Experience with database CI/CD, schema versioning, and migration tooling.
Solid Git, code review discipline, and familiarity with modern engineering practices including testing and observability.
Experience with Azure Data Factory, Synapse, or other Azure analytics services is a plus.
Experience designing event-driven or streaming data architectures is a plus.
Excellent analytical and problem-solving skills; strong communication, collaboration, customer orientation, innovation mindset, and adaptability under ambiguity.

Benefits

Comp & perks

Professional development opportunities

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQL Server 2019+Change Data CaptureC#linq2dbLINQ-to-SQLEntity FrameworkADO.NETPythondatabase performance tuningCI/CD

Soft Skills

analytical skillsproblem-solving skillscommunicationcollaborationcustomer orientationinnovation mindsetadaptability

Certifications

Bachelor's Degree in Computer Science