Data engineer • plano tx
Job Title: SQL Data Engineer with OLTP Exp.Location: Plano, TX (5 days onsite/week) F2F Must Need Only Locals.Job Overview</b></p> <p style="text-align:justify">... Show more
JLL empowers you to shape a brighter way.Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients.We are... Show more
Seeking a Senior Data Engineer for a full-time, hybrid role in Addison, TX (3 days onsite).This position will play a key role in building and ultimately owning a modern data platform for a growing ... Show more
We’re seeking driven, curious people who bring energy to what they do and see challenges as opportunities to learn and improve.Our team of co-owners values enthusiasm, creativity, and a growth mind... Show more
Extensive experience in designing, configuring, deploying, managing and automating AWS Core Services like S3, IAM, EC2, Route53, SNS, SQS, ELB, CloudWatch, Lambda and VPC.Experience in automating c... Show more
Our client is currently seeking a Data Engineer with strong experience in data modeling, data warehousing, and cloud-based data platforms.The ideal candidate will have hands-on experience with AWS ... Show more
Domicilie Location: </strong>The location for this hybrid position is Plano, TX.Candidates residing within 50 miles of a FedEx campus will be required to work on-site at a FedEx location seve... Show more
As a CBRE Building Engineer, you will be responsible for monitoring, maintaining and repairing building system operations and the performance of various areas including plumbing, electrical, painti... Show more
Taking care of our customers, our communities and each other.By honoring this commitment, we have maintained our reputation as one of the best property casualty insurers in the industry for over 17... Show more
Bright Vision Technologies is a technology consulting and software development company delivering cloud, AI, data, and enterprise solutions across the United States.This is an opportunity to contri... Show more
Data Engineer 5 Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive and iterative delivery environ... Show more
Senior Data Engineer – Plano, TX | Full-Time / Hybrid.We are seeking a highly skilled and experienced .This role will focus heavily on .Azure Databricks, PySpark, Spark SQL, scalable ETL/ELT pipeli... Show more
We have an opportunity to impact your career and provide an adventure where you can push the limits of what's possible.As a Lead Software Engineer at JPMorganChase within the CIB, you are an integr... Show more
Please review the JD below and let me know if you would be interested in exploring the opportunity</i></p> <p class="wordsection1"> </p> <p class="wordsec... Show more
Mod Op is a full-service advertising agency able to offer clients a full suite of solutions.Mod Op can offer you access to low-cost, high-quality health care options and a team of enthusiastic, col... Show more
Work Authorization: US Citizen, Green Card, or GC EAD preferred.No C2C, 1099, or third-party profiles accepted.Strong hands-on experience in Python, PySpark and Bigdata technologies for data engine... Show more
Software Data Operations Engineer Plano (Dallas), Texas About MAQ Software MAQ Software enables leading companies to accelerate their business intelligence and analytics initiatives.Our AI-powered ... Show more
Ingest data from sources such as Microsoft SQL Server (BOSS) and Oracle into the Bronze layer, implementing CDC-based incremental ingestion.Develop dbt models for the Silver layer including cleansi... Show more
Understand and document scope and requirements through interactions with analysts and stakeholders.Design and develop scalable code based custom ETL pipelines using big data technologies on Cloud p... Show more
We are seeking a mid-level Data Platform Engineer to build a new greenfield data platform integrating internal systems (GSCM, SEASI, SMART, and BOSS) using a Medallion Architecture.This role owns t... Show more
The average salary range is between $ 107,500 and $ 171,127 year , with the average salary hovering around $ 126,944 year .
The average salary range is between $ 105,570 and $ 172,017 year , with the average salary hovering around $ 130,000 year .
Job Title: SQL Data Engineer with OLTP Exp.
Location: Plano, TX (5 days onsite/week) F2F Must Need Only Locals.
Duration: 6 Months Contract.
Job Overview
We are hiring a Mid Level Data Engineer to design and build OLTP Online Transaction Processing systems and pipelines. This role focuses on transactional system design API driven data flows and building reliable high performance data services. The ideal candidate thinks in terms of system architecture transactional integrity and low latency data handling rather than scheduled data warehouse loads.
Key Responsibilities
Design build and maintain OLTP pipelines for Realtime or near Realtime 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 behaviour.
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.
Requirements
Bachelors degree in Computer Science Information Technology or a related field or equivalent practical experience.
7 to 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.
Handson 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.
Skills
Mandatory Skills: MS SQL Server, OLTP, RDBMs Design, REST APIs, Azure, Azure Blob Storage, SQL, Stored Procedures, SSIS, Data Migration, Integration, ETL, Batch Sync or Migration
