Data Engineer

Fire Rover, LLC; Farmington Hills (MI); On-site; USD 75,000 - 100,000; Full time

Benefits offered by this job

401(k)

Health insurance

Paid time off

Professional development assistance

Job summary

Fire Rover, LLC is seeking a Data Engineer in Farmington Hills, MI to design, optimize, and maintain data pipelines and relational databases for reporting, analytics, and AI/ML projects.

You will collaborate with the Data Architect and cross-functional teams to build reliable, well-structured datasets that power analytics and product initiatives. The role emphasizes SQL development, data modeling, and data quality.

Qualifications

• 2+ years in data engineering or a closely related role.
• Strong SQL skills with optimization and schema design.
• Experience designing and maintaining relational databases.
• Experience building ETL/ELT data pipelines.
• Familiarity with Azure data services (Azure SQL, Data Factory).
• Solid data modeling and data quality practices.
• Ability to collaborate across multiple teams.

Responsibilities

• Design, write, and optimize SQL queries, procedures, and views.
• Build and maintain data pipelines for diverse sources.
• Model and maintain relational database schemas for performance.
• Collaborate with Data Architect to enhance data architecture.
• Provide clean, reliable datasets for analytics, AI/ML, and products.
• Contribute to reporting and data governance best practices.
• Monitor and troubleshoot database performance and data quality.

Skills

2+ years data engineering

Strong SQL skills

Relational database design

ETL/ELT pipelines

Azure data ecosystem

Tools

Azure SQL

Azure Data Factory

Power BI

Python

SQL Server

Job description

Data Engineer position in Farmington Hills, MI to design, optimize, and maintain data pipelines and relational databases for reporting, analytics, and AI/ML projects, collaborating with the Data Architect and cross-functional teams.

Responsibilities

• Design, write, and optimize SQL queries, stored procedures, and views to support applications, reporting, and analytics
• Build and maintain data pipelines that move and transform data from various sources into our databases
• Model and maintain relational database schemas that are performant, well-documented, and easy to build on
• Partner with the Data Architect to extend and improve our overall data architecture
• Support development, AI/ML, and product teams by providing clean, reliable, well-structured datasets
• Help build and maintain operational and customer-facing reporting
• Monitor, troubleshoot, and tune database performance and data quality
• Contribute to data governance, documentation, and best practices across the team

Requirements

• 2+ years of experience in a data engineering, SQL development, or database-focused role (or a strong equivalent background)
• Strong SQL skills, including query writing, optimization, stored procedures, and schema design (SQL Server or Azure SQL preferred)
• Experience designing and maintaining relational databases
• Experience building ETL/ELT data pipelines
• Familiarity with the Azure data ecosystem (e.g., Azure SQL, Azure Data Factory) or a comparable cloud platform
• Solid understanding of data modeling concepts and data quality practices
• Strong problem-solving skills and the ability to collaborate across multiple teams

Technologies

• SQL
• SQL Server
• Azure SQL
• Azure Data Factory
• Power BI
• Python
• Azure

Compensation

Salary: USD 75,000 - 100,000 per year

Job Type: Full-time

Location: Farmington Hills, MI (onsite)

Benefits

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Professional development assistance
• Referral program
• Tuition reimbursement
• Vision insurance

About the role

We are seeking a Data Engineer to strengthen our data team and provide additional capacity as our platform and data volumes grow. You will turn raw data into reliable, well-structured, accessible information that powers reporting, internal analytics, and the applications our engineering teams build. Working with the Data Architect, you will expand our data capabilities and support projects across development, AI/ML, and product teams from a data and SQL perspective.

Work Location

In person