Data Engineer - job 1 of 2

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 Data Engineer will implement and maintain key data pipelines, focusing on data ingestion, replication, and continuous integration for batch and streaming data. This position will leverage their proficiency in programming, ETL processes, and cloud data technologies to develop, maintain, test, and deploy scalable data pipelines while ensuring data quality and reliability. This role will focus on building robust, maintainable, accessible, cost effective, and observable data pipelines between source systems and our Snowflake data lake.

What you will do

• Build scalable ETL pipelines to automate data ingestion, for both batch and streaming data processes, into a centralized data lake in Snowflake. Leverage some off-the-shelf connectors and some custom python solutions to deliver these pipelines.

• Develop and deploy orchestration solutions to facilitate near real time data availability for strategically important data sets.

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

• Build security and access controls into data pipelines to enable granular Role Based access to enterprise data, including security at row and column levels.

• Parter with Software Engineering teams to understand their development roadmap and ensure that data pipelines are maintained and prepared for any schema or business logic changes.

• Provide support to Analytics Engineers tasked with transforming and interpreting raw source system data into dimensional models.

• Performs other duties as assigned

• Complies with all policies and standards

Education Qualifications

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

Experience Qualifications

• 1-3 years hands on experience in a data engineering or related role Required

Skills and Abilities

• Proficiency with at least one cloud based ELT technology (Fivetran, AWS Kinesis, Snowpipe, Airbyte). (High proficiency)

• Experience building and operating highly available, self healing systems for data extraction, ingestion, and continuous integration and deployment. (High proficiency)

• Experience with cloud-based data warehousing and data lake solutions like Snowflake, Redshift, and BigQuery. (High proficiency)

• Familiarity with one or more DevOps tools (Git, Jenkins, CI/CD, Jira). (High proficiency)

• Proficiency in at least one general purpose interpreted programming language (Python preferred). (Medium proficiency)

• Ability to think strategically and provide recommendations utilizing modern cloud architectural components based on business needs with a focus on simplicity and maintainability. (Medium proficiency)

• Experience building data pipelines to ingest data from systems build on legacy technologies (IBM VSAM) into modern cloud-based data lake tooling (Snowflake). (Medium proficiency)

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

• Expertise with SQL, database design/structure, and data structures (star, snowflake schemas, de/normalized designs). (Medium proficiency)

• Experience with script-based data transformation tools (e.g., dbt, Talend) and version control tools. (Medium proficiency)

• Desire and ability to collaborate with cross-functional teams of software engineers, product managers, and business stakeholders. (Medium proficiency)

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.

This position description is not all inclusive for every aspect of this role. Reasonable accommodation 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 and regulations and with Safelite Group, Inc. policies and practices.

--