L0105 Support Services
Lithia Motors, Medford OR
Lithia Motors (NYSE: LAD) is the third largest automotive retailer in the U.S. and was named a 2019 Oregonian Top Workplaces award winner. We are one of the fastest-growing companies on the Fortune 500 (#265 in 2019)
With a mission of Growth Powered by People, Lithia continuously creates new opportunities for our people. We aim to create an environment where you are enabled to reach your highest potential, where you feel both inspired and supported.
With core values to Earn Customers for Life, Take Personal Ownership, Improve Constantly and Have Fun, we believe in celebrating success and cheering one another on!
Lithia is seeking a Data Engineer to join our Digital Innovation Group, focused on delivering and supporting data solutions to cross-functional teams and applications across the organization.
The ideal candidate is an innovative, flexible, professional, with strong analytical skills allowing them to work collaboratively across teams to solve critical business problems. We are seeking a self-starter with past experience working within the Azure stack (Data Lake, Data Warehouse, Data Factory, Functions), doing dimensional modeling, SQL script design/dev, and stored procedure development in medium-to-large organizations. This role will initially focus on a Cloud Payroll and Advanced Incentive Compensation Project to calculate and generate the pay for Lithia's 15,000 employees.
What You'll Do:
Participate in design, implementation, and support of a data warehouse and analytics platform utilizing Azure cloud technology
Design and implement data load processes from On Premises sources into Azure Data Lake and subsequent Azure SQL & SQL Data Warehouse
Migrate existing processes and data from our On Premises SQL Server and other environments to Azure Data Lake
Design, develop, and support Azure SQL Database Data Marts for functional area data consumers
Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using Microsoft SSIS and/or Azure cloud technology.
Troubleshoot and support Microsoft SSIS ETL processes for On Premises SQL Data Warehouse
Explore and learn the latest Azure technologies to provide new capabilities and increase efficiency
Work with top-notch technical professionals developing complex systems at scale and with a focus on sustained operational excellence
Collaborate with DW developers; for products that require reporting data and ensure that datasets are in place and are used consistently internally/externally
Collaborate with data governance; ensure all existing data is created in the right way, and that new data is created according to appropriate standards and with proper documentation
Read, write, and configure code for end-to-end service telemetry, alerting and self-healing capabilities
Strive for continuous improvement of code quality and development practices
Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers
5+ years of experience in working as an analytics or data engineering member working with cross functional teams
5+ years of SQL Server development or equivalent
2+ years of experience designing solutions in Azure specializing in any of the following technologies: Azure Data Factory, Azure Data Lake, Azure SQL & Azure SQL Data Warehouse, Azure Functions
2+ years of Spark, Python and PowerShell development
Bachelor's Degree in computer sciences, Analytics, Systems Eng., Statistics or related field
Strong attention to detail and sense of urgency
Excellent communication skills both written and oral
Hands-on experience in R/python
DevOps and automation experience integrating azure resources with CICD technologies
We offer best in class industry benefits:
Medical, Dental and Vision Plans
Paid Holidays & PTO
Short and Long-Term Disability
Paid Life Insurance
401(k) Retirement Plan
Employee Stock Purchase Plan
Lithia Learning Center
Vehicle Purchase Discounts
High School graduate or equivalent, 18 years or older required. Acceptable driving record and a valid driver's license in your state of residence necessary for select roles. We are an equal opportunity employer and a drug free work place. A criminal background check and pre-employment drug screen will be conducted on the final candidate prior to beginning employment.