Non-Driving Opportunities >> ETL Data Architect
ETL Data Architect
Description
Location: Appleton, WI
Type of Employment: Full-Time
Industry: Transportation
Function: Operations
Experience: Senior


The Job:

As a ETL Data Architect with TeamRoehl, you make a difference by designing, developing and implementing innovative data solutions that provide deep value to our Roehl team members and drivers. You are responsible for developing and optimizing critical infrastructure, ETL processes and data retrieval methodologies to create and deliver high value Roehl information assets. As a technical leader, you are on the front line of striving for modern data practices.

Roehl Transport is a data rich environment! Our 1,900+ tractors and 5,000+ trailers are generating hundreds of data points per mile. Our proprietary customer and driver management systems and sophisticated communications systems are full of data just ready to be explored and leveraged. We can provide you with a rewarding and challenging work environment, collaborative team culture, and the opportunity to have a meaningful impact. This position has a high level of interaction with end users and will give you the ability to create and maintain purposeful products that make a difference!

You create Driver Success by using your technical skills and abilities to create purposeful products that help us improve driver productivity and satisfaction.

 


The Fit:

At Roehl Transport we value Mutual Support & Teamwork, Respect, Making a Difference, Honesty, Integrity, Accountability, Customer Care, Driver Success, and our Cornerstone Value: Safety! These values guide our daily interactions with each other and our customers. We are looking for an individual who shares our values, someone who is looking to grow and develop professionally with a team who is committed to their success! We work hard and we have fun collaborating together as we accomplish our goals!

Do you love communicating, collaborating and building relationships with a diverse group of people? How about project management and business intelligence analysis? Well, as a Data Warehouse Developer with TeamRoehl you work very closely with end-users to collect, understand and validate business requirements as well as use your business and technical experience to analyze a variety of organizational needs and provide effective business intelligence solutions.

Become a member of one of the top Technology departments in WI!


The Experience:

This is a senior opportunity. This generally means that you have:

  • 4 plus years of building BI solutions.
  • 3 plus years of database and data warehouse development experience
  • 2 plus years of experience developing within Microsoft SQL Stack including SSIS, SSAS and SSRS
  • Significant knowledge of traditional and modern Information Architectures
  • Expert SQL skills
  • Understanding of basic data governance practices 
  • Understanding of master data management practices
  • Understanding of Agile development practices
  • Experience with modern visualization tools such as Power BI or Tableau
  • Cloud experienced highly desired, Azure preferred
  • Experience with Cloud Data Lake implementations is a plus

Additionally you have experience in:

  • Microsoft Stack: SQL Server 2012+, Reporting Services 2012+, Integration Services 2012+ and Analysis Services 2012+
  • Visual Studio
  • Team Foundation System
  • Excel 2010+


The Schedule:

This position is in our Marshfield, WI terminal and is a Monday-Friday schedule with some evening and weekend work as a part of the rotating on-call support schedule.


The Salary:

You will receive a competitive salary, variable compensation bonus, medical, dental, 401k, profit sharing, and paid time off! We even offer 100% tuition reimbursement if you want to further advance your education!


The Start Date:

We are ready for you to start as soon as you can!


The Company:

Roehl Transport was founded by Everett Roehl in 1962 when he began providing motor carrier service with a single truck. Over fifty years later, Roehl Transport, still family owned, has grown to one of the largest, most progressive, and safest transportation and logistics companies in the nation. With over 2,500 employees Roehl is headquartered in Marshfield, Wisconsin and has offices in Appleton, WI; Chicago, IL; Atlanta, GA; Phoenix, AZ; and Dallas, TX. Roehl provides truckload service throughout the United States and Canada. We service over 8,800 customers and some of the most recognized brand names in the nation.

Roehl has earned hundreds of distinctions including two of the industry's highest safety honors: The American Trucking Associations' President's Trophy three times and the Truckload Carrier Associations' Annual National Fleet Safety Grand Prize two consecutive years. We have led the industry in the adoption of advanced operation technologies and are a leader in environmental initiatives. Our management practices have earned us recognition as one of the best managed trucking companies in America. Roehl is built on values - a commitment to efficiency, to timely service and promises kept; to quality, courtesy, reliability and a respected public image with a cornerstone value of safety.

This opening is closed and is no longer accepting applications