Senior Data Engineer

Safelite Group, Inc.
Columbus, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Columbus, United States of America

Tech stack

Airflow
Google BigQuery
Cloud Database
Computer Programming
Databases
Continuous Integration
Data Architecture
Information Engineering
Data Governance
Data Infrastructure
Data Integration
ETL
Data Transformation
Python
Mainframes
Oracle
Role-Based Access Control
SQL Databases
Data Streaming
Talend
Virtual Storage Access Methods
Data Ingestion
Sql Optimization
System Availability
Snowflake
GIT
Data Lake
Information Technology
Data Pipelines

Job description

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

Requirements

  • 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)

Benefits & conditions

  • 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

About the company

Does this position interest you? You should apply - even if you don't match every single requirement! We're known as an auto glass company. That's the focus of what we do. But beyond the glass, we're so much more. We'll help you build a fulfilling career and encourage you to have a life. Let us be the best place you'll ever work. Does this position interest you? You should apply - even if you don't match every single requirement! We're known as an auto glass company. That's the focus of what we do. But beyond the glass, we're so much more. We'll help you build a fulfilling career and encourage you to have a life. Let us be the best place you'll ever work., Other qualifications may be required to ensure employment eligibility in accordance with local laws, regulations and with Safelite Group, Inc. policies and practices.

Apply for this position