Job Title: Data Engineer
Summary Ken Garff Automotive Group seeks a passionate, persistent, humble, and hungry Data Engineer to help transform and mature Ken Garff's Data Management and analytics team. Ken Garff truly lives the motto "We hear you", which 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 and Analytics team. Reporting to the Director of Engineering, this position will involve ETL data, designing data models, and managing 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 designs and support data engineering pipelines.
- 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 Data & Analytics team members to understand business requirements and developing new data products.
- Data validation, testing, and 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 to monitor 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 represent 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's license, and have a professional appearance.
All employees must adhere to the following 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, 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 )
- Salary range will begin at $80,000-$90,000 annually
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