Data Operations Engineer

Ektello; Irving (TX); Hybrid; USD 41,000 - 58,000; Full time

Job summary

Ektello is seeking a Data Operations Engineer for a hybrid, nationwide-capable role with a W2 contract. The engineer will design, develop, and operate secure, scalable data and infrastructure solutions supporting a nationwide auto finance organization.

The role focuses on data pipelines, ETL optimization, and warehouse modernization using SQL Server, Azure Data Factory, and Microsoft Fabric. The position requires strong SQL development, ETL expertise, and collaboration with analytics, security,

Qualifications

• Design, develop, and implement data and ETL solutions that are scalable and reliable.
• Ensure solutions align with enterprise architecture and regulatory requirements.
• Experience in data ingestion pipelines and data warehouse modernization.

Responsibilities

• Design, develop, and implement data and ETL solutions and integrations.
• Monitor, troubleshoot, and resolve problems with data systems and ETL processes.
• Document technical processes and configurations; maintain engineering documentation.
• Collaborate on cross‑functional projects to support business and technology initiatives.
• Develop T-SQL code to transform and harmonize data across multiple sources.
• Support data analytics by delivering optimized data models for BI tools.

Skills

SQL development

ETL optimization

Data pipelines

T-SQL

Data warehousing

problem solving

cross-functional collaboration

Education

Bachelor’s degree in Computer Science, Information Technology, or related field

Equivalent combination of education and experience

Tools

SSIS

Azure Data Factory

Microsoft Fabric

Azure SQL

SQL Server

Snowflake

Redis Cache

Cosmos DB

FTP tools

Azure Data Lake

Power BI / Tableau data modeling

Azure Fabric

Job description

Data Operations Engineer W2 contract, min of 6 months HYBRID out of Atlanta, GA; Dallas, TX; Houston, TX; Auburn Hills, MI

Target W2 $36/hr. Reporting to the Director Enterprise Data Management, the Engineer, Data Operations designs, develops, and operates secure, scalable, and high performing data and infrastructure solutions supporting a nationwide auto finance organization. This role serves as a technical contributor within the infrastructure team, driving data pipeline development, ETL optimization, and warehouse modernization across SQL Server, Azure Data Factory, and Microsoft Fabric, as well as the enterprise servers, storage, and software-defined cloud and network environments that underpin them. The Engineer, Data Operations partners with analytics, application, security, and operations teams to ensure data and infrastructure solutions align with enterprise architecture, regulatory requirements, and business objectives.

Essential Duties and Responsibilities

• Design, Develop, and Implement Data and ETL Solutions & Integrations: Assist in the design, development, and implementation of data solutions and integrations to optimize performance, scalability, and reliability.
• Monitor, Troubleshoot, and Resolve Problems: Implement and support effective monitoring to proactively identify and resolve issues, conducting effective root‑cause analysis to address underlying problems and prevent recurrence.
• Provide Support & Optimization: Offer expertise in diagnosing and resolving issues by implementing the necessary corrective actions and/or fixes, ensuring the operational efficiency, reliability, and scalability of data systems and ETL processes.
• Document Technical Processes & Solutions: Maintain documentation for process and system configurations, engineering designs, and troubleshooting procedures to support knowledge sharing and ensure continuity of operations.
• Collaborate on Cross‑Functional Projects: Work with team members and other departments to support business and technology initiatives and integrations, drive innovation, and improve workflows.
• Support Initiatives, Timelines, Budgets, and Deliverables: Support initiatives, timelines, budgets, and deliverables as assigned to ensure successful outcomes, managing priorities and resources effectively to meet business objectives.
• Data Analytics & Performance Monitoring: Collect data to track key metrics (KPIs, SLAs, and SLOs) and identify areas of risk and/or improvement using standard methodologies to deliver value to business partners.
• Ensures Business Alignment: Work closely with Product and/or Process Engineering team members to implement technical solutions with business partners that align with business goals using standard methodologies.
• Develop solutions to retrieve and process vendor data feeds, applying ETL processes to ensure efficient ingestion into enterprise staging systems.
• Develop T‑SQL code to transform staging data from multiple vendors into a cohesive, business aligned warehouse structure, applying logic to enhance clarity and usability.
• Develop solutions to extract and transform data from the warehouse, applying customer specific business logic to create and deliver tailored datasets for internal and external consumers.
• Monitor, analyze, and optimize long‑running T‑SQL processes, applying performance tuning techniques to improve efficiency and ensure timely completion.
• Develop and/or contribute to the Enterprise Data Dictionary.
• Additional duties may be added as business needs evolve.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and relevant professional experience.
• Minimum of five years of experience in SQL development and support, with strong SQL Server fundamentals.
• Solid understanding of ETL development with SSIS workflows.
• Experience with Azure SQL setup and configuration, and Azure Data Factory (pipelines, activities, datasets, linked services, data flows, and integration runtimes), and Microsoft Fabric.
• Strong understanding of database systems monitoring and support, software best practices, and development methodologies.
• Experience with FTP tools for file transfer.
• DBA experience across SQL Server, Azure SQL, Fabric, Snowflake, and Redis Cache.
• Problem‑Solving & Critical Thinking: Ability to analyze, troubleshoot, and develop solutions for complex issues and challenges, including troubleshooting in a multi‑tier environment, supported by strong analytical and diagnostic skills.
• Design & Architecture: Knowledge of designing scalable, efficient, and secure data and ETL solutions.
• Automation: Proficiency in common database technologies (on‑prem and cloud) and ETL tools, along with scripting and automation languages/tools, including T‑SQL, cloud data factory, and data pipelines.
• Business & System Analysis: Ability to translate business requirements into high‑level designs and technical specifications as needed.
• Database Optimization: Ability to analyze query execution plans and optimize database code, perform database maintenance and indexing, and conduct code reviews.
• Documentation & Communication: Ability to document processes, requirements, and troubleshooting steps clearly using industry‑standard methodologies and formats, with strong communication skills to collaborate effectively with technical and non‑technical stakeholders.
• Collaboration & Cross‑Functional Work: Experience working with teams across different disciplines to integrate and optimize solutions.
• Frameworks & Methodologies: Experience utilizing relevant frameworks and methodologies to standardize solutions across on‑prem and cloud database environments.
• Expertise in SQL Server (on‑prem and cloud), with familiarity in Microsoft Fabric and Azure Data Factory.
• Proficiency in designing and managing data ingestion pipelines, ETL/ELT processes, metadata management, and automation of data flows across hybrid environments.
• Experience in building, optimizing, and managing data pipelines using Azure Fabric, ADF, and other data integration tools for efficient data movement and transformation.
• Ability to support BI and analytics teams by providing well‑structured data models and optimized datasets for tools such as Power BI and Tableau.
• Cloud database experience across Azure SQL, Fabric, Redis Cache, Cosmos DB, and Snowflake.
• File Transfer: Ability to use FTP tools to transfer files.
• Strong time‑management and problem‑solving skills, with the ability to work with minimal supervision as a critical thinker and team player.

Must have reliable transportation and live within a commutable distance to one of the following cities: Atlanta, GA; Dallas, TX; Houston, TX; Auburn Hills, MI.

PREFERRED QUALIFICATIONS

• Prior experience in financial services, auto lending, or other highly regulated industries strongly preferred.
• Master’s degree in a STEM discipline or Business Administration is a plus.
• Experience with Cosmos DB is a plus.
• One or more relevant certifications are preferred.

#LI-KB1