Summary
Ken Garff Automotive Group is looking for a passionate, persistent, humble, and hungry Data Modeler/Data Engineer that can help 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 partner closely with Technology and Business stakeholders to create an alignment of data-driven decisions throughout the company at both the strategic and tactical levels. Reporting to the Director of Data Engineering. They will design new data models, star schemas, new data marts, grow the culture of self-service reporting, and support a company that has been truly data-driven for over 20 years!
Essential Duties and Responsibilities
- Work with Business, Architects, and System Analysts to fully understand the business requirements and translate them into Conceptual, Logical, and Physical models.
- Create and maintain conceptual, logical and physical data models defining information requirements to meet end user needs.
- Analytical ability and business acumen to collect multiple sources of data and draw conclusions.
- Has demonstrable analytical SQL experience working with dimensional modeling.
- Utilize your experience in reporting and data modeling to make key decisions on structure and data model design. (Star schema/data mart design)
- Develop a deep understanding of the needs of the business and assist in aligning the strategic goals and tactical objectives to decisions made with data and analytical products.
- Design the company data model and analytic products that analyze every aspect of the business ranging from finance, sales, customer 360, marketing, and operations.
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
Knowledge, Skills, and Abilities
- Extensive experience in multidimensional data modeling, such as star schemas, denormalized models, and handling “slow-changing” dimensions/ attributes
- Expert hands-on experience on any data modelling tools like Erwin, ER studio.
- Self-directed and analytical, and comfortable working in ambiguous environments
- Expertise in data warehousing and the usage of star-schema and data-mart design in self-service reporting applications
- Working knowledge of DMBS(SQL Server, Oracle, SnowFlake), Domo, SQL, Google Ad/Analytics, Confluence….
- Familiarity with data engineering and data pipeline data movements
Top Skills
What We Do
Ken Garff founded his business in 1932 upon the principles of honesty, integrity, personalized customer service, and being a good corporate citizen. Today, Ken Garff has more than 50 locations throughout Utah, Texas, Iowa, Nevada, Michigan, and California.
To distinguish and strategically position its dealerships, Ken Garff recently retooled its brand. The need for this retooling was driven by an evolving market place and super-savvy customers wanting a different car-buying experience, including more transparency and a higher level of trust. These changes were built around the new brand slogan, "We Hear You."
Despite the company's growth and changes within a challenging market place, Ken Garff is going to great lengths to keep alive and well the principles upon which Ken founded the company, of providing an unsurpassed experience for every customer, every time.
Ken Garff believes in giving back to the communities in which it serves. Since Ken founded his business over 81 years ago, the company has given millions of dollars and thousands of hours to schools, charities and community organizations.
Why Work for Ken Garff?
Ken Garff recognizes the importance of a benefit program that provides protection to our employees and their families. A comprehensive benefits program has been created to fulfill a wide range of needs.
Benefits available to employees include:
• Competitive Compensation Package
• Medical , Dental and Vision
• 401K Plan with Company match
• Paid Time Off
• Holiday Pay
• Volunteer Time Off Program
• Year-end bonus program for all employees
• Personal Wellness Plan
• GarffCare Roadside Assistance Program
• Discounts on Parts and Service and More!
Ken Garff is an Equal Opportunity Employer
((We Hear You))
