Data Operations Engineer

Ektello

Auburn Hills (MI)

Hybrid

USD 41,000 - 58,000

Full time

9 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ektello in Auburn Hills, MI, is seeking a Data Operations Engineer to design, develop, and operate secure data pipelines across SQL Server, Azure Data Factory, and Microsoft Fabric. The role supports a nationwide auto finance environment with emphasis on ETL optimization, data warehousing, and scalable infrastructure.

You'll partner with analytics, security, and operations teams to ensure compliance with enterprise standards, document processes, and deliver tailored datasets for internal and

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or related field or equivalent experience.
  • 5+ years of SQL development and support with strong SQL Server fundamentals.
  • Experience with ETL development using SSIS and data integration.
  • Familiar with Azure SQL, Azure Data Factory, Microsoft Fabric, and multiple data platforms.

Responsibilities

  • Design, develop, and operate data and ETL solutions to optimize performance and reliability.
  • Monitor, troubleshoot, and resolve data pipeline issues with root-cause analysis.
  • Collaborate with analytics, security, and ops teams to align solutions with enterprise goals.
  • Create and maintain documentation for processes, configurations, and troubleshooting steps.
  • Develop data ingestion pipelines and T-SQL transformations for a consolidated warehouse.
  • Support BI and analytics by delivering well-structured datasets for Power BI/Tableau.

Skills

SQL development
ETL development
T-SQL
Data warehousing
Azure Data Factory
Microsoft Fabric
SQL Server

Education

Bachelor's degree in CS/IT or related field

Tools

Azure Data Factory
Microsoft Fabric
SQL Server
Snowflake
Redis Cache

Job description

** 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.

  • 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 anequivalent combination of education and relevant professional experience.
  • Minimum of five years of experience in SQL development and support, with strong SQL Serverfundamentals.
  • 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, anddevelopment 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Operations Engineer
Data Operations Engineer

ektello • Irving (TX)

Hybrid
USD 41,000 - 58,000
Senior Data Engineer
Senior Data Engineer

RelMap Consulting • United States

Remote
USD 96,000 - 110,000
Data Engineer
Data Engineer

Sakata Seed America, Inc. • Woodland (CA)

On-site
USD 110,000 - 125,000
Azure Data Engineer
Azure Data Engineer

Recru • Fort Worth (TX), Arlington (TX), Dallas (TX)

On-site
USD 120,000 - 150,000
Data Engineer Lead
Data Engineer Lead

VSE AVIATION INC (US) • Phoenix (AZ)

On-site
USD 140,000 - 200,000
Data Engineer Lead
Data Engineer Lead

VSE AVIATION INC (US) • Florida

On-site
USD 130,000 - 190,000
Data Engineer
Data Engineer

Jack • United States

On-site
USD 70,000 - 90,000
Competitive medical, dental, and vision plans
Company-paid life, AD&D, and disability insurance
401(k) with company match
+3
Sr. Data Engineer
Sr. Data Engineer

iSpace Inc. • Anaheim (CA)

Hybrid
USD 120,000 - 160,000
Senior Data Engineer
Senior Data Engineer

NBMBAA • Charlotte (NC)

On-site
USD 120,000 - 180,000
Data Engineer / Lead Data Engineer
Data Engineer / Lead Data Engineer

MSR Cosmos • Houston (TX)

Hybrid
USD 90,000 - 96,000