Senior Data Engineer

GM Financial • Arlington, TX

6h • Hybrid

About The Position

The Senior Data Engineer is responsible for architecting and implementing resilient data ingestion pipelines and designing normalized database schemas optimized for transactional processing. This role ensures seamless integration between vendor systems and internal applications, maintaining high availability and performance for operational data services. The Senior Data Engineer collaborates with cross-functional teams to deliver secure, efficient, and scalable solutions that support GM Financial’s operational data strategy. This team member will design and maintain an Operational Data Store (ODS) that serves as the authoritative source for integrated applications, while implementing strategies for synchronization, conflict resolution, and resilience. The role requires deep expertise in Azure SQL performance tuning and OLTP optimization to guarantee sub-second response times for critical applications.

Requirements

• Expert-level proficiency in Azure SQL or SQL Server, including OLTP design, normalization (3NF), referential integrity, and constraints
• Strong experience with Azure ecosystem for event-driven or micro-batch data movement
• Deep understanding of SQL internals—locking, latches, execution plans, and isolation levels (e.g., Read Committed Snapshot)
• Experience consuming RESTful APIs, handling pagination, rate limiting, and JSON parsing
• Working knowledge of security methodologies, policies, and best practices for financial data
• Ability to troubleshoot and optimize high-volume transactional systems for performance and reliability
• 6-8 years of hands-on experience with data engineering required
• High School Diploma or equivalent required
• Bachelor’s Degree in related field or equivalent work experience required

Nice To Haves

• Experience building DR (Disaster Recovery) hot/warm sites for financial data
• Familiarity with Change Data Capture (CDC) tools to minimize payload size
• Experience with FIS or similar financial systems

Responsibilities

• Architect and build resilient pipelines to extract data from vendor APIs/SFTP and load it into Azure SQL with minimal latency
• Design and maintain a normalized (3NF) database model optimized for OLTP and application integration, rather than analytical reporting
• Create and optimize Views, Stored Procedures, and Table Functions that allow internal applications to safely read/write data without direct access to raw tables
• Implement strategies to ensure the internal ODS matches the vendor “State of Truth,” handling record updates, deletions, and conflict resolution
• Aggressively tune Azure SQL for application performance (index tuning, locking/blocking reduction, query plan analysis) to ensure sub-second response times for integrated apps
• Build “self-healing” mechanisms to queue and retry requests when vendor systems fail, preventing downstream application crashes

Benefits

• Generous benefits package available on day one to include: 401K matching, bonding leave for new parents (12 weeks, 100% paid), tuition assistance, training, GM employee auto discount, community service pay and nine company holidays.
• Competitive pay and bonus eligibility
• Flexible hybrid work environment, 2-days a week in office

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level