Description

Accelerate your Career!

At Swift, our greatest asset is OUR PEOPLE! We strive to be the best and give our best every day. We are passionate about learning and cultivating an environment of safety, honesty and mutual respect. We are a family where everyone has a voice and plays an essential role in our overall success and the success of our drivers. Your voice and perspective matter at Swift Transportation. We understand that you are the subject matter expert, and we trust you to ideate and execute those ideas based on the best interest of the company.

Be a part of something bigger. Be a part of the #1 full truckload carrier in the nation. Be a part of Swift Transportation.

Job Responsibilities: What you will do

Work with designated team to identify, design and implement solutions for extraction and integration of data to and from operational system and the data warehouse.

• Monitor and troubleshoot Extract-Transfrom-Load (ETL) and system performance, including optimization and tuning of data loads.
• Work with business users to understand and document business and technical requirements to drive design and development.
• Collaborate on the design of physical structure and implementation of database objects.
• Document and build physical database objects from table, column, index and view definitions.
• Develop scripts for the creation of the physical data warehouse tables, views and macros.
• Adhere to data security and protection policies.
• Understand job and activity schedules to promote optimal performance, maximize availability and minimize data latency and data load duration.
• Provide off hours on-call support to resolve production issues within the stated service level agreement.
• Perform additional duties as assigned by leadership.

Copy and paste URL into browser to view full description: https://knxtrans.jdxpert.com/ShowJob.aspx?EntityID=2&id=7356

Qualifications: What you need to bring

• 3+ years experience as ETL developer in data warehouse / business intelligence environment required.
• Experience across multiple systems and platforms utilizing various technologies such as ODBC, FTP, Window, Unix/Linux, and AS/400 required.
• Experience working with high volume databases with partitioned data, performance and tuning required.
• Bachelors degree or equivalent combination of education and/or experience required.
• Good verbal and written communication skills.
• Detail-oriented with strong organizational skills.
• Microsoft Office Suite
• Report generation
• Mathematical, analytical and problem solving skills.
• Ability to interpret user needs and translate into system requirements.
• Ability to understand system data and to identify discrepancies
• Previous knowledge of system analytics helpful

Pay Range: $64,500.00 - $85,500.00 Annual

What we offer:

• Competitive starting salary commensurate with experience and geographic location.
• Potential bonus pay based on company performance.
• Opportunities to volunteer and give back to local communities.
• Comprehensive Benefits Package which includes:
  • 401(K)
  • Medical, Dental, Vision, Disability, Supplemental and Life Insurance
  • Paid Time Off
  • Employee Stock Purchase Plan

The Company is an equal employment opportunity employer. The Company's policy is not to unlawfully discriminate against any applicant or employee on the basis of race, color, sex, sexual orientation, gender identity, religion, national origin, age, military status, disability, genetic information or any other consideration made unlawful by applicable federal, state, or local laws. The Company also prohibits harassment of applicants and employees based on any of these protected categories.