← Back to jobsJob ID col-cmv8fixle06gxoz01p4le5jqi

AnblicksPosted 30+ days ago

SQL Server Data Engineer

Full-time
On-site
7+ years
Competitive
Posted 30+ days ago

Anblicks is hiring a SQL Server Data Engineer to design and build OLTP systems and pipelines for real-time or near-real-time transactional data processing. The role focuses on transactional system design, API-driven data flows, SQL Server optimization, Azure data services, system performance, and collaboration with backend engineers.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Design, build, and maintain OLTP pipelines for real-time or near-real-time transactional data processing
  • Build and consume APIs to handle data ingestion, updates, and retrieval from operational systems
  • Design SQL Server database schemas optimized for transactional workloads — normalization, indexing, concurrency control, and locking behavior
  • Write and optimize SQL queries, stored procedures, and transaction logic for high-throughput, low-latency operations
  • Ensure data consistency, atomicity, and integrity (ACID compliance) across services
  • Develop ETL processes as needed to support data migration, system integration, or occasional batch sync between transactional systems
  • Handle API request/response cycles: validation, error handling, retries, and rate limiting on data-write operations
  • Monitor system performance, diagnose issues (deadlocks, query latency, contention), and tune for scale
  • Deploy and manage data services using Azure (Azure SQL Database, API Management, Azure Blob)
  • Use SSIS (SQL Server Integration Services) for occasional data migration or integration tasks
  • Collaborate with backend engineers to integrate data layers into application services
  • Implement validation, idempotency checks, and integrity constraints at the transactional level
  • Create and maintain documentation for system architecture, API contracts, and database schemas

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience)
  • 7–10 years of experience in SQL Server and relational database design for OLTP systems — normalization, indexing, transactions, isolation levels
  • Solid experience building or consuming APIs (REST) for data read/write operations
  • Working knowledge of Azure services: Azure SQL Database, API Management,, Azure Blob Storage
  • Experience working with transactional data in high-concurrency, production environments
  • Experience writing and optimizing SQL stored procedures for transactional systems
  • Hands-on experience with SSIS or similar tools for data migration/integration tasks
  • Working knowledge of ETL development for occasional batch sync or migration needs
  • Understanding of system design fundamentals: concurrency, caching, request handling, and service scalability
  • Experience collaborating with backend/application engineers to integrate data layers into services
  • Strong analytical, troubleshooting, and communication skills

Required skills

SQL ServerRelational Database DesignOLTP SystemsREST APIsAzure SQL DatabaseAzure API ManagementAzure Blob StorageSQL Stored ProceduresSSISETL DevelopmentConcurrency ControlSystem Scalability

Full job description

Anblicks is hiring a SQL Server Data Engineer to design and build OLTP systems and pipelines for real-time or near-real-time transactional data processing. The role focuses on transactional system design, API-driven data flows, SQL Server optimization, Azure data services, system performance, and collaboration with backend engineers.

Responsibilities

  • Design, build, and maintain OLTP pipelines for real-time or near-real-time transactional data processing
  • Build and consume APIs to handle data ingestion, updates, and retrieval from operational systems
  • Design SQL Server database schemas optimized for transactional workloads — normalization, indexing, concurrency control, and locking behavior
  • Write and optimize SQL queries, stored procedures, and transaction logic for high-throughput, low-latency operations
  • Ensure data consistency, atomicity, and integrity (ACID compliance) across services
  • Develop ETL processes as needed to support data migration, system integration, or occasional batch sync between transactional systems
  • Handle API request/response cycles: validation, error handling, retries, and rate limiting on data-write operations
  • Monitor system performance, diagnose issues (deadlocks, query latency, contention), and tune for scale
  • Deploy and manage data services using Azure (Azure SQL Database, API Management, Azure Blob)
  • Use SSIS (SQL Server Integration Services) for occasional data migration or integration tasks
  • Collaborate with backend engineers to integrate data layers into application services
  • Implement validation, idempotency checks, and integrity constraints at the transactional level
  • Create and maintain documentation for system architecture, API contracts, and database schemas

Company

  • Enterprise AI solutions, data foundations, and cloud infrastructure.
  • Dallas, Texas, USA
  • https://www.anblicks.com/
  • Founded in 2004
  • 501-1000 employees
  • Anblicks is a cloud data analytics company that provides data, cloud, analytics, and software services.

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience)
  • 7–10 years of experience in SQL Server and relational database design for OLTP systems — normalization, indexing, transactions, isolation levels
  • Solid experience building or consuming APIs (REST) for data read/write operations
  • Working knowledge of Azure services: Azure SQL Database, API Management,, Azure Blob Storage
  • Experience working with transactional data in high-concurrency, production environments
  • Experience writing and optimizing SQL stored procedures for transactional systems
  • Hands-on experience with SSIS or similar tools for data migration/integration tasks
  • Working knowledge of ETL development for occasional batch sync or migration needs
  • Understanding of system design fundamentals: concurrency, caching, request handling, and service scalability
  • Experience collaborating with backend/application engineers to integrate data layers into services
  • Strong analytical, troubleshooting, and communication skills

Required skills

  • SQL Server, Relational Database Design, OLTP Systems, REST APIs, Azure SQL Database, Azure API Management, Azure Blob Storage, SQL Stored Procedures, SSIS, ETL Development, Concurrency Control, System Scalability

Experience

  • 7+ years

Job details

Employment type

Full-time

Seniority level

7+ years

Date posted

Oct 14, 2026

Work mode

On-site

Job source

Ethic Leaf recruiter

Company

Anblicks

Information Technology & AI

Enterprise AI solutions, data foundations, and cloud infrastructure.

  • Dallas, Texas, USA
  • Information Technology & AI
  • 501-1000 employees
  • Founded 2004
  • anblicks.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Dallas

Bluebeam

1d ago

New

Data Engineer III

Full-timeHybridDallas, TX$109K – $136K/yr

Bluebeam is hiring a Data Engineer III to support Revenue Operations and cross-functional business teams. The role manages data extraction, transformation, storage, ETL/ELT pipelines, integrations, and data architecture for operational and analytics needs.

Why similarSame roleDallas

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleETL DevelopmentRemote

Dice

1d ago

New

Senior Data Engineer with AI

TemporaryHybridDallas, TXCompetitive

The hiring employer is not identified in the posting. The role builds and maintains scalable data infrastructure across ingestion, transformation, orchestration, and delivery, while using AI-assisted development tools and collaborating with backend, BI, and…

Why similarSame roleDallas

Get new Data Engineer jobs in Dallas by email

Create job alert

SQL Server Data Engineer

Anblicks · Competitive

Apply via Ethic Leaf