Senior Data Engineer

City Auto Glass, inc.; Columbus (OH); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Weekly pay & bonus

Comprehensive benefits

Tuition reimbursement

Job summary

Safelite is seeking a Senior Data Engineer to design and maintain scalable data pipelines, focusing on ingestion, replication, and CI/CD automation for both batch and streaming data. You will contribute to a robust data platform that supports analytics engineers and data scientists with reliable, high-quality data.

The role involves modernizing legacy processes, building centralized data lakes, implementing CI/CD, and collaborating with product owners and engineers to meet business needs.

Qualifications

• Bachelor's degree in computer science, engineering, analytics or related field (Required).
• 4-6 years hands-on experience in data engineering or analytics (Required).
• Extensive experience with ETL/ELT jobs and data pipelines using tools such as Fivetran, Airbyte, Stitch, or Informatica (High proficiency).
• Proficiency in cloud data warehouses (Snowflake, BigQuery) (High proficiency).
• Advanced SQL with window functions, CTEs, nested queries (High proficiency).
• Experience with script-based data transformation tools (dbt, Talend) (High proficiency).
• Ability to train and guide developers in using Git (High proficiency).
• Deep understanding of data architecture, security, and RBAC (High proficiency).
• Ability to collaborate across teams (High proficiency).
• Experience mentoring data teams (Medium proficiency).
• Experience architecting ingestion from legacy systems (Medium proficiency).
• Orchestrating workflows with Airflow or Dagster (Medium proficiency).
• Strong data governance and security practices (Medium).
• Python or similar languages (Medium).
• Leadership with project management experience (Medium).

Responsibilities

• Modernize legacy data ingestion processes for streaming and batch systems.
• Build scalable ETL pipelines to centralize data from diverse sources.
• Develop and deploy CI/CD pipelines for data workflows.
• Enhance monitoring and alerting to ensure data quality and availability.
• Collaborate with product owners and software engineers on ingestion needs.
• Integrate source system changes into downstream pipelines and reporting assets.
• Ensure data solutions align with business needs and analytics goals.
• Perform other duties as assigned.
• Comply with policies and standards.

Skills

ETL Pipelines

SQL

Python

Data Warehouses

CI/CD

Monitoring

Cross-functional

Mentoring

Legacy Ingest

Airflow/Dagster

Education

Bachelor's Degree in Computer Science/Engineering/Analytics or related

Tools

Fivetran

Airbyte

Stitch

Informatica

Snowflake

BigQuery

dbt

Talend

Git

Airflow

Dagster

Job description

A Brief Overview The Senior Data Engineer at Safelite is responsible for implementing and maintaining new data pipelines, focusing on data ingestion, replication, and continuous integration for batch and streaming data. This role will contribute to the development, maintenance, and enhancement of key data infrastructure, ensuring data quality and reliability. The expected outcome is a streamlined and efficient data environment that supports data availability for analytics engineers and data scientists.

What You Will Do

• Contribute to the modernization and enhancement of legacy data ingestion processes, ensuring they are efficient, scalable, and maintainable for both streaming and batch processes.

• Build scalable ETL pipelines to automate data ingestion from various sources into a centralized data lake, enabling a proactive posture toward consuming source system updates and changes.

• Develop and deploy continuous integration and continuous deployment (CI/CD) pipelines to automate and streamline data engineering workflows.

• Enhance monitoring and alerting systems to proactively identify and resolve issues, minimizing downtime and ensuring data quality.

• Partner with product owners and software engineers to identify data ingestion requirements and provide a supportable and sustainable data integration solution.

• Participate in cross-functional projects to integrate source system changes into downstream data pipelines and reporting assets.

• Ensure data engineering solutions are aligned with business needs and support data-driven decision-making.

• Performs other duties as assigned.

• Complies with all policies and standards.

What You Will Need

• Bachelor's Degree in computer science, engineering, analytics or related field, or equivalent Required

• 4-6 years hands on experience in data engineering or analytics related role Required

• Extensive Experience with ETL/ELT jobs and data pipelines using tools such as Fivetran, Airbyte, Stitch, or Informatica. (High proficiency)

• Proficiency in cloud data warehouses (e.g., Snowflake, BigQuery) and related databases. (High proficiency)

• Advanced SQL skills, including window functions, CTEs and nested queries. (High proficiency)

• Experience with script-based data transformation tools (e.g., dbt, Talend). (High proficiency)

• Ability to train and guide developers in using version control tools like Git. (High proficiency)

• Deep understanding of data architecture principles, security practices, and RBAC best practices. (High proficiency)

• Ability to collaborate with cross-functional teams. (High proficiency)

• Experience managing and mentoring data teams. (Medium proficiency)

• Experience architecting ingestion patterns from legacy softwares such as IBM VSAM Mainframes, Oracle databases, and on-prem SQL Servers. (Medium proficiency)

• Ability to orchestrate complex workflows using tools like Airflow or Dagster. (Medium proficiency)

• Strong understanding of data governance and security practices. (Medium proficiency)

• Proficiency in Python or similar programing languages. (Medium proficiency)

• Leadership skills with experience in project management. (Medium proficiency)

What You Will Get:

• Competitive weekly pay and bonus opportunities.

• Total job benefits valued at more than $10k*. This includes a 401(k) plan with company matching, medical coverage plans customized to suit your needs and a commitment to work/life balance through our paid time off (PTO) programs, company holidays and paid volunteer days.

• Up to $5,250 in tuition reimbursement per year.

• View all our health, wealth and life offerings at www.safelitebenefits.com

Expected Work Location (In Office)

It is expected that you will primarily perform work at the Safelite Home Office (7400 Safelite Way, Columbus, OH 43235). You are required to work in the office at least 4 days a week. Changes to work location arrangements are subject to managerial approval and business needs. #LI-Onsite #LI-JR2

This job description in no way states or implies that these are the only duties to be performed by an employee occupying this position. Employees may be required to perform other related duties as assigned to ensure workload coverage. This job description does NOT constitute an employment agreement between the employer and employee and is subject to change by the employer as the organizational needs and requirements of the job change.

This position description is not all inclusive for every aspect of this role. Reasonable accommodations will be made for individuals covered by ADA, ADEA, FMLA and other laws and regulations in accordance with their requirements. Physical and mental demands are not, and should not be construed to be job qualification standards, but are illustrated to help the employer, employee and/or applicant identify tasks where reasonable accommodations may need to be made when an otherwise qualified person is unable to perform the job’s essential duties because of an ADA disability.

Other qualifications may be required to ensure employment eligibility in accordance with local laws, regulations and with Safelite Group, Inc. policies and practices.

Diversity

Safelite welcomes everyone. We value our diverse workforce and suppliers, and we’re proud to be an equal opportunity employer. Learn more at Careers http://safelite.com/Careers

Benefit amounts are estimates only. Actual values will depend on benefit elections during enrollment.