Senior Data Engineer
Safelite · Columbus, Ohio, United States
Vehicle Repair and Maintenance · 10,001+ employees
About the role
Implement and maintain scalable data pipelines for batch and streaming data to support analytics engineers and data scientists. Modernize legacy ingestion processes and develop CI/CD pipelines to automate data engineering workflows.
What they look for
Requirements
Requires a Bachelor's degree and 4-6 years of experience in data engineering with high proficiency in SQL, cloud data warehouses, and ETL tools. Candidates should have experience with Python and the ability to orchestrate complex workflows using tools like Airflow.
Benefits
Full description
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.
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.