Data Engineer

Lithia Motors Medford , OR 97501

Posted 2 months ago

Dealership:

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!

The Opportunity:

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

Qualifications:

  • 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:

  • Competitive pay

  • 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

  • Wellness Programs

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.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Network Engineer

Harry And David, LLC

Posted 2 weeks ago

VIEW JOBS 9/6/2020 12:00:00 AM 2020-12-05T00:00 * Minimum 5 years in Cisco Technology experience * Strong and Extensive knowledge of LAN and WAN based technologies and protocols, including BGP, OSPF, EIGRP, Layer 2/3 Switching & Routing and proficient in TCP/IP * Above average Level Layer 1 through 3 troubleshooting ability * Minimum 4 years Hands-on experience in the installation, operation, maintenance, and troubleshooting of multi-user, multi-protocol networks * Hands-on experience using Cisco and other networking products, including Load Balancers, switches, VPN devices, and routers. * Hands-on Cisco ASA Firewalls, IPSEC/GRE & SSL User VPN and Remote Access technologies * Familiarity with network management tools such as Cisco Prime, Cisco Security Manager, Cisco ACS, Riverbed Profiler/Shark, Cacti * Experience with Cisco Wireless technologies including Prime, WLC, Light APs and Aruba * F5 LTM & GTM * Palo Alto Firewalls * In depth knowledge of Infrastructure Security and Policy * Bachelor's degree in Information Systems related field or Equivalent work experience. * Experience working in a fast paced and dynamic Internet environment. * Previous experience with design and implementation of large complex networks. * Previous experience with coordinating vendors, carriers and other service provider activities * Must have worked on a project from beginning to end that involved a major Network roll out which can be characterized as an "Evolution of a Network" * Excellent verbal and written communication skills. * Must be willing to be "on-call" for after-hours support as needed. * Must be willing to work extended hours and critical Holidays. * VoIP experience a plus. INDCH Harry And David, LLC Medford OR

Data Engineer

Lithia Motors