Data Engineer

Show job

Job Title: Data Engineer 

Summary 

Ken Garff Automotive Group is looking for a passionate, persistent, humble, and hungry Data Engineer that can help transform and mature Ken Garff’s Data Management & Analytics team. Ken Garff truly lives the motto of “We hear you”; this motto applies to all we do within our corporate and regional teams. This individual will be part of the back-end data function of the Data Management & Analytics team.  Reporting to the Director of Engineering, this position will ETL data, design data models, and manage integrations.  

 

Essential Duties and Responsibilities 

  • Create, Update, and Maintain multiple relational DB systems.  T-SQL, MySQL, Snowflake (migration happening now), Procedures/Functions/etc…  

  • Utilize Informatica Cloud (IICS) to rapidly prototype out designs and support data engineering. 

  • Data Engineering Tasks: ELT/ETL/Data Pipelines following best practices and standards developed by the team.  

  • Understand the needs of the business and assist in aligning the strategic goals and tactical objectives to decisions made with data. 

  • Working with other members of the Data & Analytics team to understand business requirements and developing new data products. 

  • Data validation, testing, QA of new and existing data products.  

  • Maintenance & Updates of our Snowflake & SQL Server platform consisting of a large quantity of Stored Procedures/Functions/API Development  

  • Provide excellent customer service with timely, accurate, and courteous responses to all team members. 

  • Participate in the on-call rotation for monitoring our data pipelines/platform.  

  • Utilize JIRA/Confluence to document, track, and record work.  

 

QUALIFICATIONS: 

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed here are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Applicants must be 18 years or older and be authorized to work in the U.S., have a valid driver license and professional appearance. 

All employees must adhere to the below Company Values: 

 

Respect: Above everything else 

Integrity: Do the right thing 

Growth: One step at a time 

Humility: Actions speak louder than words 

Teamwork: Stronger together 

 

Other Required Attributes: 

  • Attitude – Demonstrate a positive “can do” attitude; show motivation; must be goal oriented and a self-starter; be “solution-minded” rather than “problem-minded” 

  • Work Ethic – Must be dedicated, responsible, hard-working, and a team player 

  • Oral Communication – Speak clearly with customers and employees in all situations; listen “We Hear You” and get clarification; respond well to questions; demonstrate positive response to others 

  • Written Communication – Write clearly and informatively; vary writing style to meet needs; able to read and interpret written information 

  • Professionalism – Approach others in a tactful manner; react well under pressure; treat others with respect and consideration, regardless of their status or position; accept responsibility for own actions; follow through on commitments 

  • Hybrid Work – Ability to work in a hybrid environment.  Critically important to develop relationships with IT and business stakeholders with a varying degree of in office time and communication styles.  Currently, the IT team works Mon/Wed/Fri in office, with business stakeholder days varying.   

Knowledge, Skills, and Abilities 

  • Demonstratable fluency in SQL querying with large, complex datasets (Snowflake, Microsoft SQL Server, MySql) and hands on experience in developing stored procedures, table value functions, and views. 

  • Prior utilization of ETL tools and technology (IICS, airflow, spoon, APIs) 

  • Self-directed and analytical, and comfortable working in ambiguous environments 

  • Problem solver and an agent for change and innovation 

  • Ability to analyze data and determine connection between business processes and determine data transformation requirements.   

  • Knowledge of project/process management tools for work analysis (JIRA, TEMPO, etc..) 

 

 

Required Education and Experience 

  • Bachelors or advanced degree of Technology, Engineering or related field will be important in this role, along with a minimum of 2 years progressive experience.  A combination of education and related experience would also qualify you for the role.  

Preferred Education and Experience 

  • Experience utilizing IICS 

 

We are an Equal Opportunity Employer 

 

Organisation: 
Ken Garff Automotive Group