[Remote] Senior Data Engineer

Note: The job is a remote job and is open to candidates in USA. Aubrant Digital is a leader in multi-shore custom application development, dedicated to solving clients’ business problems through innovative software solutions. As a Senior Data Engineer, you will design and optimize data solutions on Azure and SQL Server while mentoring team members and collaborating with various stakeholders to enhance database performance and scalability.ResponsibilitiesDesign and maintain SQL Server 2019+ schemas, indexes, and query patterns that meet performance, scalability, and concurrency requirementsAnalyze execution plans, identify bottlenecks, and tune queries, indexes, and statistics; advise on RCSI and isolation level choicesDesign and operate Change Data Capture (CDC) pipelines and other change-tracking patterns to support downstream consumersImplement and review data access using linq2db, LINQ-to-SQL (DBML), Entity Framework, and ADO.NET; choose the right tool for each scenarioTranslate business and application requirements into efficient SQL and C# data access code that is performant, testable, and maintainablePartner with application engineers to align ORM usage with database performance characteristics and avoid common anti-patternsDesign and operate data solutions on Azure, including Azure SQL, storage, networking, and security configurationsContribute to CI/CD for database changes through migration scripts, schema versioning, and automated deploymentsMentor engineers on database design, query optimization, and data access patterns; set standards for the teamSkillsBachelor'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 focusExpert-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 CaptureExpert-level proficiency in database performance tuning, including bottleneck identification, index design, query rewrites, and concurrency design under production loadStrong 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 pitfallsStrong proficiency in Python for data engineering tasks, scripting, and automationHands-on experience with Azure data services (Azure SQL, storage, networking, security) and deploying production data workloads in AzureExperience with database CI/CD, schema versioning, and migration toolingSolid Git, code review discipline, and familiarity with modern engineering practices including testing and observabilityExcellent analytical and problem-solving skills; strong communication, collaboration, customer orientation, innovation mindset, and adaptability under ambiguityExperience with Azure Data Factory, Synapse, or other Azure analytics services is a plusExperience designing event-driven or streaming data architectures is a plusCompany OverviewAubrant Digital offers enterprise software, cloud architecture, and data analytics solutions. It was founded in 2013, and is headquartered in Minnetonka, Minnesota, USA, with a workforce of 51-200 employees. Its website is https://aubrant.com.